none
SQL Server is terminating because of fatal exception c0000005 RRS feed

  • Вопрос

  • На сервере под Windows Server 2003 SP2 установлен SQL2005 (9.00.1399.06). Сервис запускается, но периодически падает с ошибкой:

    SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart)

    ERRORLOG:

    2010-10-14 13:04:41.24 spid5s      Recovery is complete. This is an informational message only. No user action is required.
    2010-10-14 13:04:50.85 Logon       Error: 18456, Severity: 14, State: 16.
    2010-10-14 13:04:50.85 Logon       Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: 192.168.67.72]
    2010-10-14 13:05:05.87 Logon       Error: 18456, Severity: 14, State: 16.
    2010-10-14 13:05:05.87 Logon       Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: 192.168.67.72]
    2010-10-14 13:05:15.86 Logon       Error: 18456, Severity: 14, State: 16.
    2010-10-14 13:05:15.86 Logon       Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: 192.168.67.72]
    2010-10-14 13:05:30.86 Logon       Error: 18456, Severity: 14, State: 16.
    2010-10-14 13:05:30.86 Logon       Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: 192.168.67.72]
    2010-10-14 13:05:55.91 Logon       Error: 18456, Severity: 14, State: 16.
    2010-10-14 13:05:55.91 Logon       Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: 192.168.67.72]
    2010-10-14 13:06:40.96 Logon       Error: 18456, Severity: 14, State: 16.
    2010-10-14 13:06:40.96 Logon       Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: 192.168.67.72]
    2010-10-14 13:07:20.28 spid54      Using 'xpsqlbot.dll' version '2005.90.1399' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
    2010-10-14 13:07:20.85 spid54      Using 'xplog70.dll' version '2005.90.1399' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
    2010-10-14 13:07:46.02 Logon       Error: 18456, Severity: 14, State: 16.
    2010-10-14 13:07:46.02 Logon       Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: 192.168.67.72]
    2010-10-14 13:08:51.03 Logon       Error: 18456, Severity: 14, State: 16.
    2010-10-14 13:08:51.03 Logon       Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: 192.168.67.72]
    2010-10-14 13:09:56.03 Logon       Error: 18456, Severity: 14, State: 16.
    2010-10-14 13:09:56.03 Logon       Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: 192.168.67.72]
    2010-10-14 13:10:44.64 Server      Error: 17311, Severity: 16, State: 1.
    2010-10-14 13:10:44.64 Server      SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).
    2010-10-14 13:10:44.90 Server      Using 'dbghelp.dll' version '4.0.5'
    2010-10-14 13:10:44.90 Server      **Dump thread - spid = 0, PSS = 0x00000000, EC = 0x00000000
    2010-10-14 13:10:44.90 Server      ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0004.txt
    2010-10-14 13:10:44.90 Server      * *******************************************************************************
    2010-10-14 13:10:44.90 Server      *
    2010-10-14 13:10:44.90 Server      * BEGIN STACK DUMP:
    2010-10-14 13:10:44.90 Server      *   10/14/10 13:10:44 spid 0
    2010-10-14 13:10:44.90 Server      *
    2010-10-14 13:10:44.90 Server      * ex_handle_except encountered exception C0000005 - Server terminating
    2010-10-14 13:10:44.90 Server      *
    2010-10-14 13:10:44.90 Server      *
    2010-10-14 13:10:44.90 Server      *  MODULE                          BASE      END       SIZE
    2010-10-14 13:10:44.90 Server      * sqlservr                       01000000  02BA7FFF  01ba8000
    2010-10-14 13:10:44.90 Server      * ntdll                          7C800000  7C8C1FFF  000c2000
    2010-10-14 13:10:44.90 Server      * kernel32                       77E40000  77F41FFF  00102000
    2010-10-14 13:10:44.90 Server      * MSVCR80                        78130000  781CAFFF  0009b000
    2010-10-14 13:10:44.90 Server      * msvcrt                         77BA0000  77BF9FFF  0005a000
    2010-10-14 13:10:44.90 Server      * MSVCP80                        7C420000  7C4A6FFF  00087000
    2010-10-14 13:10:44.90 Server      * ADVAPI32                       7D1E0000  7D27BFFF  0009c000
    2010-10-14 13:10:44.90 Server      * RPCRT4                         77C50000  77CEFFFF  000a0000
    2010-10-14 13:10:44.90 Server      * Secur32                        76F50000  76F62FFF  00013000
    2010-10-14 13:10:44.90 Server      * USER32                         77380000  77410FFF  00091000
    2010-10-14 13:10:44.90 Server      * GDI32                          77C00000  77C48FFF  00049000
    2010-10-14 13:10:44.90 Server      * CRYPT32                        761B0000  76242FFF  00093000
    2010-10-14 13:10:44.90 Server      * MSASN1                         76190000  761A1FFF  00012000
    2010-10-14 13:10:44.90 Server      * MSWSOCK                        71B20000  71B60FFF  00041000
    2010-10-14 13:10:44.90 Server      * WS2_32                         71C00000  71C16FFF  00017000
    2010-10-14 13:10:44.90 Server      * WS2HELP                        71BF0000  71BF7FFF  00008000
    2010-10-14 13:10:44.90 Server      * USERENV                        76920000  769E1FFF  000c2000
    2010-10-14 13:10:44.90 Server      * opends60                       333E0000  333E6FFF  00007000
    2010-10-14 13:10:44.90 Server      * NETAPI32                       71C40000  71C96FFF  00057000
    2010-10-14 13:10:44.90 Server      * SHELL32                        7C8D0000  7D0CEFFF  007ff000
    2010-10-14 13:10:44.90 Server      * SHLWAPI                        7D180000  7D1D1FFF  00052000
    2010-10-14 13:10:44.90 Server      * IMM32                          76290000  762ACFFF  0001d000
    2010-10-14 13:10:44.90 Server      * comctl32                       77420000  77522FFF  00103000
    2010-10-14 13:10:44.90 Server      * psapi                          76B70000  76B7AFFF  0000b000
    2010-10-14 13:10:44.90 Server      * instapi                        48060000  48069FFF  0000a000
    2010-10-14 13:10:44.90 Server      * sqlevn70                       4F610000  4F7A0FFF  00191000
    2010-10-14 13:10:44.90 Server      * SQLOS                          344D0000  344D4FFF  00005000
    2010-10-14 13:10:44.90 Server      * rsaenh                         68000000  68034FFF  00035000
    2010-10-14 13:10:44.90 Server      * AUTHZ                          76C40000  76C53FFF  00014000
    2010-10-14 13:10:44.90 Server      * MSCOREE                        340D0000  34119FFF  0004a000
    2010-10-14 13:10:44.92 Server      * ole32                          77670000  777A8FFF  00139000
    2010-10-14 13:10:44.92 Server      * msv1_0                         76C90000  76CB6FFF  00027000
    2010-10-14 13:10:44.92 Server      * cryptdll                       766E0000  766EBFFF  0000c000
    2010-10-14 13:10:44.92 Server      * iphlpapi                       76CF0000  76D09FFF  0001a000
    2010-10-14 13:10:44.92 Server      * kerberos                       61B20000  61B78FFF  00059000
    2010-10-14 13:10:44.92 Server      * schannel                       76750000  76777FFF  00028000
    2010-10-14 13:10:44.92 Server      * COMRES                         77010000  770D5FFF  000c6000
    2010-10-14 13:10:44.92 Server      * XOLEHLP                        61BD0000  61BD5FFF  00006000
    2010-10-14 13:10:44.92 Server      * MSDTCPRX                       61BE0000  61C58FFF  00079000
    2010-10-14 13:10:44.92 Server      * OLEAUT32                       77D00000  77D8AFFF  0008b000
    2010-10-14 13:10:44.92 Server      * msvcp60                        61C60000  61CC4FFF  00065000
    2010-10-14 13:10:44.92 Server      * MTXCLU                         61CD0000  61CE8FFF  00019000
    2010-10-14 13:10:44.92 Server      * VERSION                        77B90000  77B97FFF  00008000
    2010-10-14 13:10:44.92 Server      * WSOCK32                        71BB0000  71BB8FFF  00009000
    2010-10-14 13:10:44.92 Server      * CLUSAPI                        61CF0000  61D01FFF  00012000
    2010-10-14 13:10:44.92 Server      * RESUTILS                       61D10000  61D22FFF  00013000
    2010-10-14 13:10:44.92 Server      * DNSAPI                         76ED0000  76EF9FFF  0002a000
    2010-10-14 13:10:44.92 Server      * winrnr                         76F70000  76F76FFF  00007000
    2010-10-14 13:10:44.92 Server      * WLDAP32                        76F10000  76F3DFFF  0002e000
    2010-10-14 13:10:44.92 Server      * rasadhlp                       76F80000  76F84FFF  00005000
    2010-10-14 13:10:44.92 Server      * security                       62160000  62163FFF  00004000
    2010-10-14 13:10:44.92 Server      * dssenh                         68100000  68126FFF  00027000
    2010-10-14 13:10:44.92 Server      * msfte                          62780000  629D7FFF  00258000
    2010-10-14 13:10:44.92 Server      * dbghelp                        629E0000  62AF7FFF  00118000
    2010-10-14 13:10:44.92 Server      * WINTRUST                       76BB0000  76BDBFFF  0002c000
    2010-10-14 13:10:44.92 Server      * imagehlp                       76C10000  76C37FFF  00028000
    2010-10-14 13:10:44.92 Server      * hnetcfg                        62F00000  62F59FFF  0005a000
    2010-10-14 13:10:44.92 Server      * wshtcpip                       71AE0000  71AE7FFF  00008000
    2010-10-14 13:10:44.92 Server      * NTMARTA                        77E00000  77E20FFF  00021000
    2010-10-14 13:10:44.92 Server      * SAMLIB                         7E020000  7E02EFFF  0000f000
    2010-10-14 13:10:44.92 Server      * ntdsapi                        766F0000  76703FFF  00014000
    2010-10-14 13:10:44.92 Server      * xpsp2res                       62F60000  63224FFF  002c5000
    2010-10-14 13:10:44.92 Server      * CLBCatQ                        777B0000  77832FFF  00083000
    2010-10-14 13:10:44.92 Server      * sqlncli                        63230000  6344DFFF  0021e000
    2010-10-14 13:10:44.92 Server      * COMCTL32                       77530000  775C6FFF  00097000
    2010-10-14 13:10:44.92 Server      * comdlg32                       762B0000  762F8FFF  00049000
    2010-10-14 13:10:44.92 Server      * SQLNCLIR                       007D0000  00802FFF  00033000
    2010-10-14 13:10:44.92 Server      * msftepxy                       635D0000  635E4FFF  00015000
    2010-10-14 13:10:44.92 Server      * xpstar90                       638C0000  63904FFF  00045000
    2010-10-14 13:10:44.92 Server      * SQLSCM90                       63920000  63928FFF  00009000
    2010-10-14 13:10:44.92 Server      * ODBC32                         63940000  6397CFFF  0003d000
    2010-10-14 13:10:44.92 Server      * BatchParser90                  63980000  6399DFFF  0001e000
    2010-10-14 13:10:44.92 Server      * SQLSVC90                       639B0000  639C9FFF  0001a000
    2010-10-14 13:10:44.92 Server      * SqlResourceLoader              639E0000  639E5FFF  00006000
    2010-10-14 13:10:44.92 Server      * ATL80                          7C630000  7C64AFFF  0001b000
    2010-10-14 13:10:44.92 Server      * odbcint                        63B00000  63B16FFF  00017000
    2010-10-14 13:10:44.92 Server      * SQLSVC90                       63B20000  63B22FFF  00003000
    2010-10-14 13:10:44.92 Server      * xpstar90                       63B40000  63B65FFF  00026000
    2010-10-14 13:10:44.92 Server      * xpsqlbot                       63550000  63555FFF  00006000
    2010-10-14 13:10:44.92 Server      * xplog70                        63570000  6357BFFF  0000c000
    2010-10-14 13:10:44.92 Server      * xplog70                        63590000  63592FFF  00003000
    2010-10-14 13:10:44.92 Server      * oledb32                        64170000  641E8FFF  00079000
    2010-10-14 13:10:44.92 Server      * MSDART                         34420000  34439FFF  0001a000
    2010-10-14 13:10:44.92 Server      * OLEDB32R                       643B0000  643C0FFF  00011000
    2010-10-14 13:10:44.92 Server      * comsvcs                        643D0000  64514FFF  00145000
    2010-10-14 13:10:44.92 Server      * msdasql                        645A0000  645ECFFF  0004d000
    2010-10-14 13:10:44.92 Server      * MSDATL3                        645F0000  64604FFF  00015000
    2010-10-14 13:10:44.92 Server      * MSDASQLR                       34480000  34483FFF  00004000
    2010-10-14 13:10:44.92 Server      * msorcl32                       64690000  646B3FFF  00024000
    2010-10-14 13:10:44.92 Server      * msorc32r                       635A0000  635A4FFF  00005000
    2010-10-14 13:10:44.92 Server      * oci                            646D0000  646ECFFF  0001d000
    2010-10-14 13:10:44.92 Server      * OCIW32                         646F0000  646F8FFF  00009000
    2010-10-14 13:10:44.92 Server      * ORACLIENT9                     64700000  64883FFF  00184000
    2010-10-14 13:10:44.92 Server      * oracore9                       64890000  6492EFFF  0009f000
    2010-10-14 13:10:44.92 Server      * oranls9                        64930000  649A8FFF  00079000
    2010-10-14 13:10:44.92 Server      * oraunls9                       649B0000  649C0FFF  00011000
    2010-10-14 13:10:44.92 Server      * WINMM                          76AA0000  76ACCFFF  0002d000
    2010-10-14 13:10:44.92 Server      * oravsn9                        649D0000  649D5FFF  00006000
    2010-10-14 13:10:44.92 Server      * oracommon9                     649E0000  64A6FFFF  00090000
    2010-10-14 13:10:44.92 Server      * orageneric9                    64A70000  64CC6FFF  00257000
    2010-10-14 13:10:44.92 Server      * oraxml9                        64CD0000  64D4CFFF  0007d000
    2010-10-14 13:10:44.92 Server      * MSVCIRT                        64D50000  64D5FFFF  00010000
    2010-10-14 13:10:44.92 Server      * oraxsd9                        64D60000  64D7FFFF  00020000
    2010-10-14 13:10:44.92 Server      * orannzsbb9                     64D80000  64E08FFF  00089000
    2010-10-14 13:10:44.92 Server      * oran9                          64E10000  64EC3FFF  000b4000
    2010-10-14 13:10:44.92 Server      * oranl9                         64ED0000  64EFBFFF  0002c000
    2010-10-14 13:10:44.92 Server      * oranldap9                      64F00000  64F10FFF  00011000
    2010-10-14 13:10:44.92 Server      * oraldapclnt9                   64F20000  64F43FFF  00024000
    2010-10-14 13:10:44.92 Server      * orancrypt9                     64F50000  64F66FFF  00017000
    2010-10-14 13:10:44.92 Server      * ORATRACE9                      64F70000  64FADFFF  0003e000
    2010-10-14 13:10:44.92 Server      * oranro9                        64FB0000  64FE5FFF  00036000
    2010-10-14 13:10:44.92 Server      * oranhost9                      64FF0000  64FF5FFF  00006000
    2010-10-14 13:10:44.92 Server      * oranoname9                     65000000  65005FFF  00006000
    2010-10-14 13:10:44.92 Server      * orancds9                       65010000  65015FFF  00006000
    2010-10-14 13:10:44.92 Server      * orantns9                       65020000  65026FFF  00007000
    2010-10-14 13:10:44.92 Server      * oranms                         65030000  65036FFF  00007000
    2010-10-14 13:10:44.92 Server      * oranmsp                        65040000  6504FFFF  00010000
    2010-10-14 13:10:44.92 Server      * orapls9                        65050000  65362FFF  00313000
    2010-10-14 13:10:44.92 Server      * oraslax9                       65370000  65376FFF  00007000
    2010-10-14 13:10:44.92 Server      * orasnls9                       65380000  6538FFFF  00010000
    2010-10-14 13:10:44.92 Server      * orawtc9                        65390000  65395FFF  00006000
    2010-10-14 13:10:44.92 Server      * orasql9                        653A0000  65414FFF  00075000
    2010-10-14 13:10:44.92 Server      * odbccp32                       65560000  65579FFF  0001a000
    2010-10-14 13:10:44.92 Server      * dbghelp                        65630000  65747FFF  00118000
    2010-10-14 13:10:44.92 Server      *
    2010-10-14 13:10:44.92 Server      *        Edi: 655FC474:  00162010  00000000  00000000  7C826D49  7D206DFC  00000970 
    2010-10-14 13:10:44.92 Server      *        Esi: 00000000: 
    2010-10-14 13:10:44.92 Server      *        Eax: 655FC358:  000042AC  00000000  00000000  77E4BEF7  00000000  00000002 
    2010-10-14 13:10:44.92 Server      *        Ebx: 0000003F: 
    2010-10-14 13:10:44.92 Server      *        Ecx: 655FC9C8:  00000000  00010007  0090008E  00162014  655FC384  655FC358 
    2010-10-14 13:10:44.92 Server      *        Edx: 0000003D: 
    2010-10-14 13:10:44.92 Server      *        Eip: 77E4BEF7:  10C2C95E  01093D00  840FC000  00000095  F29DE950  9090FFFF 
    2010-10-14 13:10:44.92 Server      *        Ebp: 655FC3A8:  655FC3EC  02172CE4  000042AC  00000000  00000000  00000000 
    2010-10-14 13:10:44.92 Server      *      SegCs: 7813001B:  00000000  00000000  00000000  00000000  00000000  00000000 
    2010-10-14 13:10:44.92 Server      *     EFlags: 00000246: 
    2010-10-14 13:10:44.92 Server      *        Esp: 655FC354:  00000000  000042AC  00000000  00000000  77E4BEF7  00000000 
    2010-10-14 13:10:44.92 Server      *      SegSs: 78130023:  00000000  00000000  00000000  00000000  00000000  00000000 
    2010-10-14 13:10:44.92 Server      * *******************************************************************************
    2010-10-14 13:10:44.92 Server      * -------------------------------------------------------------------------------
    2010-10-14 13:10:44.92 Server      * Short Stack Dump
    2010-10-14 13:10:45.97 Server      77E4BEF7 Module(kernel32+0000BEF7)
    2010-10-14 13:10:45.97 Server      02172CE4 Module(sqlservr+01172CE4)
    2010-10-14 13:10:45.97 Server      02176BA0 Module(sqlservr+01176BA0)
    2010-10-14 13:10:45.97 Server      0217674D Module(sqlservr+0117674D)
    2010-10-14 13:10:45.97 Server      023D8B59 Module(sqlservr+013D8B59)
    2010-10-14 13:10:45.98 Server      77E761B7 Module(kernel32+000361B7)
    2010-10-14 13:10:45.98 Server      77BC3E74 Module(msvcrt+00023E74)
    2010-10-14 13:10:45.98 Server      77BCB547 Module(msvcrt+0002B547)
    2010-10-14 13:10:45.98 Server      77E6482F Module(kernel32+0002482F)
    2010-10-14 13:10:45.98 Server      Stack Signature for the dump is 0xF292E78D
    2010-10-14 13:11:01.07 Logon       Error: 18456, Severity: 14, State: 16.
    2010-10-14 13:11:01.07 Logon       Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: 192.168.67.72]
    2010-10-14 13:11:37.32 Server      Timeout waiting for external dump process 4888.

    2010-10-14 13:11:37.32 spid7s      SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

    Возможно это связано с утановленными недавно обновлениями безопасности (через windowsupdate)...

    14 октября 2010 г. 10:42

Ответы

Все ответы

  • Удалось выяснить, что сервис падает на этапе подключения к оракловой базе (есть джоб, который подключается к ораклу и что-то вытягивает).
    • Помечено в качестве ответа rublin 3 ноября 2010 г. 15:15
    • Снята пометка об ответе rublin 3 ноября 2010 г. 15:15
    14 октября 2010 г. 12:41
  • А почему Вы не устанавливаете обновления на SQL Server?

    • Помечено в качестве ответа rublin 3 ноября 2010 г. 15:15
    14 октября 2010 г. 13:20
  • Спасибо, как раз над этим сейчас работаем )

    По результату отпишусь.

    • Помечено в качестве ответа rublin 3 ноября 2010 г. 15:14
    • Снята пометка об ответе rublin 3 ноября 2010 г. 15:15
    18 октября 2010 г. 7:12
  • Спасибо, как раз над этим сейчас работаем )

    По результату отпишусь.


    Установка SP3 на SQL помогла. Спасибо.
    • Помечено в качестве ответа rublin 3 ноября 2010 г. 15:15
    3 ноября 2010 г. 15:14