none
SqlDumpExceptionHandler: Process 80 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION

    Question

  • Team

    I keep getting this error every so often in the SQL Server(2005.90.3054.00). 2005/SP2/Hot Fixes. Windows Server 2003 SP2. I have researched the web, every one seems to have the same question and nobody seems to have an answer.

    This somehow does not show up in the Profiler. The apps work normally too.

    It is a huge eye sore in the LOGs.

    =================                                            
    BugCheck Dump                                                                                            
    =================                                           
                                                                                                                    
    This file is generated by Microsoft SQL Server  version 9.00.3054.00  upon detection of fatal unexpected error. Please return this file, the query or program that produced the bugcheck, the database and                                               
    the error log, and any other pertinent information with a Service Request.                                       
                                                                                                                    
    Computer type is AT/AT COMPATIBLE.                                                                              
    Bios Version is COMPAQ - 2                                                                                      
    Current time is 15:52:36 09/27/07.                                                                              
    8 Intel x86 level 15, 2694 Mhz processor (s).                                                                   
    Windows NT 5.2 Build 3790 CSD Service Pack 2.                                                                   
                                        
    Memory                              
    MemoryLoad = 93%                    
    Total Physical = 9727 MB            
    Available Physical = 638 MB         
    Total Page File = 13613 MB          
    Available Page File = 4573 MB       
    Total Virtual = 2047 MB             
    Available Virtual = 246 MB          
    ***Stack Dump being sent to E:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump1331.txt                           
    SqlDumpExceptionHandler: Process 91 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
    terminating this process.          

    * *******************************************************************************                               
    *                                                                                                               
    * BEGIN STACK DUMP:                                                                                             
    *   09/27/07 15:52:36 spid 91                                                                                   
    *   Exception Address = 0100E88E Module(sqlservr+0000E88E)                                                      
    *   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION                                                     
    *   Access Violation occurred reading address 0000000C                                                          
    * Input Buffer 36 bytes -                                                                                       
    *    s p S e l e c t  10 00 73 00 70 00 53 00 65 00 6c 00 65 00 63 00 74 00                                     
    *  I n t e r n e t    49 00 6e 00 74 00 65 00 72 00 6e 00 65 00 74 00 00 00                                     
    *  MODULE                          BASE      END       SIZE                                                     
    * sqlservr                       01000000  02C0AFFF  01c0b000                                                   
    * ntdll                          7C800000  7C8BFFFF  000c0000                                                   
    * kernel32                       77E40000  77F41FFF  00102000                                                   
    * MSVCR80                        78130000  781CAFFF  0009b000                                                   
    * msvcrt                         77BA0000  77BF9FFF  0005a000                                                   
    * MSVCP80                        7C420000  7C4A6FFF  00087000                                                   
    * ADVAPI32                       77F50000  77FEAFFF  0009b000                                                   
    * RPCRT4                         77C50000  77CEEFFF  0009f000                                                   
    * Secur32                        76F50000  76F62FFF  00013000                                                   
    * USER32                         77380000  77410FFF  00091000                                                   
    * GDI32                          77C00000  77C47FFF  00048000                                                   
    * CRYPT32                        761B0000  76242FFF  00093000                                                   
    * MSASN1                         76190000  761A1FFF  00012000                                                   
    * MSWSOCK                        71B20000  71B60FFF  00041000                                                   
    * WS2_32                         71C00000  71C16FFF  00017000                                                   
    * WS2HELP                        71BF0000  71BF7FFF  00008000                                                   
    * USERENV                        76920000  769E1FFF  000c2000                                                   
    * opends60                       333E0000  333E6FFF  00007000                                                   
    * NETAPI32                       71C40000  71C96FFF  00057000                                                   
    * SHELL32                        7C8D0000  7D0CDFFF  007fe000                                                   
    * SHLWAPI                        77DA0000  77DF1FFF  00052000                                                   
    * comctl32                       77420000  77522FFF  00103000                                                   
    * psapi                          76B70000  76B7AFFF  0000b000                                                   
    * instapi                        48060000  48069FFF  0000a000                                                   
    * CLUSAPI                        74DE0000  74DF1FFF  00012000                                                   
    * ole32                          77670000  777A8FFF  00139000                                                   
    * OLEAUT32                       77D00000  77D8AFFF  0008b000                                                   
    * RESUTILS                       74EF0000  74F02FFF  00013000                                                   
    * sqlevn70                       4F610000  4F7B8FFF  001a9000                                                   
    * SQLOS                          344D0000  344D4FFF  00005000                                                   
    * rsaenh                         68000000  68034FFF  00035000                                                   
    * AUTHZ                          76C40000  76C53FFF  00014000                                                   
    * MSCOREE                        79000000  79044FFF  00045000                                                   
    * msv1_0                         76C90000  76CB6FFF  00027000                                                   
    * iphlpapi                       76CF0000  76D09FFF  0001a000                                                   
    * kerberos                       61FF0000  62047FFF  00058000                                                   
    * cryptdll                       766E0000  766EBFFF  0000c000                                                   
    * schannel                       76750000  76776FFF  00027000                                                   
    * COMRES                         620B0000  62175FFF  000c6000                                                   
    * XOLEHLP                        62180000  62185FFF  00006000                                                   
    * MSDTCPRX                       62190000  62208FFF  00079000                                                   
    * msvcp60                        62210000  62274FFF  00065000                                                   
    * MTXCLU                         62280000  62298FFF  00019000                                                   
    * VERSION                        77B90000  77B97FFF  00008000                                                   
    * WSOCK32                        71BB0000  71BB8FFF  00009000                                                   
    * DNSAPI                         76ED0000  76EF9FFF  0002a000                                                   
    * winrnr                         622F0000  622F6FFF  00007000                                                   
    * WLDAP32                        76F10000  76F3DFFF  0002e000                                                   
    * rasadhlp                       62320000  62324FFF  00005000                                                   
    * hnetcfg                        62330000  62389FFF  0005a000                                                   
    * wshtcpip                       71AE0000  71AE7FFF  00008000                                                   
    * security                       62890000  62893FFF  00004000                                                   
    * msfte                          63070000  632C8FFF  00259000                                                   
    * dbghelp                        632E0000  633F4FFF  00115000                                                   
    * WINTRUST                       76BB0000  76BDAFFF  0002b000                                                   
    * imagehlp                       76C10000  76C37FFF  00028000                                                   
    * dssenh                         68100000  68126FFF  00027000                                                   
    * NTMARTA                        77E00000  77E20FFF  00021000                                                   
    * SAMLIB                         7E020000  7E02EFFF  0000f000                                                   
    * ntdsapi                        766F0000  76703FFF  00014000                                                   
    * xpsp2res                       63C00000  63EC4FFF  002c5000                                                   
    * CLBCatQ                        777B0000  77832FFF  00083000                                                   
    * sqlncli                        63ED0000  640F3FFF  00224000                                                   
    * COMCTL32                       77530000  775C6FFF  00097000                                                   
    * comdlg32                       00940000  00988FFF  00049000                                                   
    * SQLNCLIR                       64210000  64242FFF  00033000                                                   
    * msftepxy                       64AD0000  64AE4FFF  00015000                                                   
    * xpsqlbot                       64B30000  64B35FFF  00006000                                                   
    * xpstar90                       64F70000  64FB8FFF  00049000                                                   
    * SQLSCM90                       64FD0000  64FD8FFF  00009000                                                   
    * ODBC32                         64FF0000  6502CFFF  0003d000                                                   
    * BatchParser90                  65030000  6504EFFF  0001f000                                                   
    * ATL80                          7C630000  7C64AFFF  0001b000                                                    
                          

    Thanks for your help in advance.

    Paresh Motiwala

    EDS, Boston, USA

    The other half of the error message is in the second message of the same thread below.

              The file is located here:

    Wednesday, September 26, 2007 8:01 PM

All replies

  • * odbcint                        65320000  65336FFF  00017000                                                   
    * xpstar90                       65340000  65365FFF  00026000                                                   
    * xplog70                        65370000  6537BFFF  0000c000                                                   
    * xplog70                        65390000  65392FFF  00003000                                                   
    * msxmlsql                       78800000  788D4FFF  000d5000                                                   
    * msxml2                         65F90000  6603EFFF  000af000                                                   
    * msxml3                         66040000  66159FFF  0011a000                                                   
    * oledb32                        69AC0000  69B38FFF  00079000                                                   
    * MSDART                         69720000  69739FFF  0001a000                                                   
    * OLEDB32R                       6A0D0000  6A0E0FFF  00011000                                                   
    * dbghelp                        693E0000  694F4FFF  00115000                                                   
    *                                                                                                               
    *        Edi: 00000000:                                                                                         
    *        Esi: 08625984:  00000000  00000000  00000000  00000000  00000000  00000000                             
    *        Eax: 00000000:                                                                                         
    *        Ebx: 00000000:                                                                                         
    *        Ecx: 086259A4:  00000000  0862592C  00000000  006C0062  00000000  086259B8                             
    *        Edx: 00000000:                                                                                         
    *        Eip: 0100E88E:  8B0C588B  C9330473  44244C39  34244489  18247489  438A1B74                             
    *        Ebp: 695DF3A4:  695DF454  0100D0CF  695DF410  00000000  695DF1D5  08625908                             
    *      SegCs: 0000001B:                                                                                         
    *     EFlags: 00010202:  0065006B  00700065  00720065  00650053  00760072  00720065                             
    *        Esp: 695DF310:  00000000  08625984  00000000  00000000  695DF410  46F68580                             
    *      SegSs: 00000023:                                                                                         
    * *******************************************************************************                               
    * -------------------------------------------------------------------------------                               
    * Short Stack Dump                                                                                              
    0100E88E Module(sqlservr+0000E88E)                                                                              
    0100D0CF Module(sqlservr+0000D0CF)                                                                              
    023C4CF6 Module(sqlservr+013C4CF6)                                                                              
    023C61B3 Module(sqlservr+013C61B3)                                                                              
    010339A5 Module(sqlservr+000339A5)                                                                              
    010339D6 Module(sqlservr+000339D6)                                                                              
    01097C24 Module(sqlservr+00097C24)                                                                              
    01099878 Module(sqlservr+00099878)                                                                              
    010320F9 Module(sqlservr+000320F9)                                                                              
    01032038 Module(sqlservr+00032038)                                                                              
    01061A53 Module(sqlservr+00061A53)                                                                              
    01C55BB4 Module(sqlservr+00C55BB4)                                                                              
    01C55D60 Module(sqlservr+00C55D60)                                                                              
    0102271B Module(sqlservr+0002271B)                                                                              
    01024725 Module(sqlservr+00024725)                                                                              
    0102390E Module(sqlservr+0002390E)                                                                              
    0103C95C Module(sqlservr+0003C95C)                                                                              
    0103990E Module(sqlservr+0003990E)                                                                              
    01008D98 Module(sqlservr+00008D98)                                                                              
    01008EBE Module(sqlservr+00008EBE)                                                                              
    01008BCE Module(sqlservr+00008BCE)                                                                              
    01468E78 Module(sqlservr+00468E78)                                                                              
    0146998A Module(sqlservr+0046998A)                                                                              
    0146984C Module(sqlservr+0046984C)                                                                              
    014695B3 Module(sqlservr+004695B3)                                                                              
    781329AA Module(MSVCR80+000029AA)                                                                               
    78132A36 Module(MSVCR80+00002A36)   

    PSS @0x501B95F8
    ---------------

     

    CSession @0x501B8278
    --------------------
    m_spid = 91                          m_cRef = 29                          m_rgcRefType[0] = 1                   
    m_rgcRefType[1] = 1                  m_rgcRefType[2] = 18                 m_rgcRefType[3] = 9                   
    m_rgcRefType[4] = 0                  m_rgcRefType[5] = 0                  m_pmo = 0x501B8040                    
    m_pstackBhfPool = 0x00000000         m_dwLoginFlags = 0x03e0              m_fBackground = 0                     
    m_fClientRequestConnReset = 0        m_fUserProc = -1                     m_fConnReset = 0                      
    m_fIsConnReset = 0                   m_fInLogin = 0                       m_fAuditLoginSent = 1                 
    m_fAuditLoginFailedSent = 0          m_fReplRelease = 0                   m_fKill = 0                           
    m_ulLoginStamp = 1508886             m_eclClient = 2                      m_protType = 5                        
    m_hHttpToken = FFFFFFFF             

    m_pV7LoginRec
    ---------------------
    00000000:   59010000 00000070 00100000 00000006 b4050000 †Y......p............                                  

    00000014:   00000000 e0030000 2c010000 09040000 5e000a00 †........,.......^...                                  

    00000028:   72000600 7e000000 88000f00 a6000b00 00000000 †r...~...............                                  

    0000003C:   bc000400 c4000000 c4000a00 00b0d03d 38bed800 †...............=8...                                  

    00000050:   81005901 00000000 00000000 0000†††††††††††††††..Y........... 

     

    CPhysicalConnection @0x501B8188
    -------------------------------
    m_pPhyConn->m_pmo = 0x501B8040       m_pPhyConn->m_pNetConn = 0x501B87B0  m_pPhyConn->m_pConnList = 0x501B8260  
    m_pPhyConn->m_pSess = 0x501B8278     m_pPhyConn->m_fTracked = -1          m_pPhyConn->m_cbPacketsize = 4096     
    m_pPhyConn->m_fMars = 0              m_pPhyConn->m_fKill = 0             

    CBatch @0x501B8AB8
    ------------------
    m_pSess = 0x501B8278                 m_pConn = 0x501B8A18                 m_cRef = 3                            
    m_rgcRefType[0] = 1                  m_rgcRefType[1] = 1                  m_rgcRefType[2] = 1                   
    m_rgcRefType[3] = 0                  m_rgcRefType[4] = 0                  m_pTask = 0x00AA8898                  


    EXCEPT (null) @0x695DD780
    -------------------------
    exc_number = 0                       exc_severity = 0                     exc_func = 0x02416380                 

     

    Task @0x00AA8898
    ----------------
    CPU Ticks used (ms) = 5              Task State = 2                                                             
    WAITINFO_INTERNAL: WaitResource = 0x00000000                              WAITINFO_INTERNAL: WaitType = 0x0     
    WAITINFO_INTERNAL: WaitSpinlock = 0x00000000                              SchedulerId = 0x1                     
    ThreadId = 0x1ccc                    m_state = 0                          m_eAbortSev = 0                       

     

    EC @0x501B9600
    --------------
    spid = 91                            ecid = 0                             ec_stat = 0x0                         
    ec_stat2 = 0x0                       ec_atomic = 0x0                      __fSubProc = 1                        
    ec_dbccContext = 0x00000000          __pSETLS = 0x501B8A58                __pSEParams = 0x501B8CF8              
    __pDbLocks = 0x501B98F0             

    SEInternalTLS @0x501B8A58
    -------------------------
     m_flags = 0                          m_TLSstatus = 3                      m_owningTask = 0x00AA8898            
     m_activeHeapDatasetList = 0x501B8A58                                      m_activeIndexDatasetList = 0x501B8A60
    ----SubprocessMgr Dump----            SubprocessMgr::this = 0x537BE2A8      m_creatorTask = 0x00AA8898          
      m_pmoSubpDescs = 0x0863E028          m_pmoThis = 0x537BE028               m_subpList = 0x537BE2C0             
      m_refcount = 3                                                                                                
    ----Subprocess Dump----               SubprocessDescriptor::this = 0x0863E320                                   
      m_subprocDone = 1                    m_paramsConsumed = 0                 m_subprocTask = 0x00000000          
    ----Subprocess Dump----               SubprocessDescriptor::this = 0x0863FB30                                   
      m_subprocDone = 1                    m_paramsConsumed = 0                 m_subprocTask = 0x00000000          
    ----Subprocess Dump----               SubprocessDescriptor::this = 0x0863F190                                   
      m_subprocDone = 1                    m_paramsConsumed = 0                 m_subprocTask = 0x00000000          
    ----Subprocess Dump----               SubprocessDescriptor::this = 0x0863F660                                   
      m_subprocDone = 1                    m_paramsConsumed = 0                 m_subprocTask = 0x00000000          
    ----Subprocess Dump----               SubprocessDescriptor::this = 0x0863E588                                   
      m_subprocDone = 1                    m_paramsConsumed = 0                 m_subprocTask = 0x00000000          
    ----Subprocess Dump----               SubprocessDescriptor::this = 0x0863EF28                                   
      m_subprocDone = 1                    m_paramsConsumed = 0                 m_subprocTask = 0x00000000          
    ----Subprocess Dump----               SubprocessDescriptor::this = 0x731AA320                                   
      m_subprocDone = 1                    m_paramsConsumed = 0                 m_subprocTask = 0x00000000          
    ----Subprocess Dump----               SubprocessDescriptor::this = 0x731AA7F0                                   
      m_subprocDone = 0                    m_paramsConsumed = 0                 m_subprocTask = 0x00AA92E8          
      Ec = 0x606760E8                   

    EC @0x606760E8
    --------------
    spid = 91                            ecid = 8                             ec_stat = 0x0                         
    ec_stat2 = 0x0                       ec_atomic = 0x0                      __fSubProc = 0                        
    ec_dbccContext = 0x00000000          __pSETLS = 0x0862E588                __pSEParams = 0x731AA5A4              
    __pDbLocks = 0x00000000             

    SEInternalTLS @0x0862E588
    -------------------------
     m_flags = 0                          m_TLSstatus = 3                      m_owningTask = 0x00AA8898            
     m_activeHeapDatasetList = 0x0862E588                                      m_activeIndexDatasetList = 0x0862E590


    SEParams @0x731AA5A4
    --------------------
     m_lockTimeout = -1                   m_isoLevel = 4096                    m_logDontReplicate = 0               
     m_neverReplicate = 0                 m_XactWorkspace = 0x49D80E50         m_pSessionLocks = 0x687AFB60         
     m_pDbLocks = 0x687AFCD0              m_execStats = 0x1C196E40             m_pAllocFileLimit = 0x00000000       

     

    SEParams @0x501B8CF8
    --------------------
     m_lockTimeout = -1                   m_isoLevel = 4096                    m_logDontReplicate = 0               
     m_neverReplicate = 0                 m_XactWorkspace = 0x49D80E50         m_pSessionLocks = 0x501B9B00         
     m_pDbLocks = 0x501B98F0              m_execStats = 0x4B5F28B8             m_pAllocFileLimit = 0x00000000       


     

    Thursday, September 27, 2007 8:17 PM