Лучший отвечающий
SQL Server is terminating because of fatal exception c0000005
Вопрос
-
На сервере под 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
Ответы
-
А почему Вы не устанавливаете обновления на SQL Server?
- Помечено в качестве ответа rublin 3 ноября 2010 г. 15:15
14 октября 2010 г. 13:20 -
Спасибо, как раз над этим сейчас работаем )
По результату отпишусь.
Установка SP3 на SQL помогла. Спасибо.- Помечено в качестве ответа rublin 3 ноября 2010 г. 15:15
3 ноября 2010 г. 15:14
Все ответы
-
Удалось выяснить, что сервис падает на этапе подключения к оракловой базе (есть джоб, который подключается к ораклу и что-то вытягивает).14 октября 2010 г. 12:41
-
А почему Вы не устанавливаете обновления на SQL Server?
- Помечено в качестве ответа rublin 3 ноября 2010 г. 15:15
14 октября 2010 г. 13:20 -
Спасибо, как раз над этим сейчас работаем )
По результату отпишусь.
18 октября 2010 г. 7:12 -
Спасибо, как раз над этим сейчас работаем )
По результату отпишусь.
Установка SP3 на SQL помогла. Спасибо.- Помечено в качестве ответа rublin 3 ноября 2010 г. 15:15
3 ноября 2010 г. 15:14
