Inquiridor
SOCORRO: SQL Server "Desliga" Sozinho

Pergunta
-
Pessoal,
O meu SQL está à algum tempo, parando a sua execução sozinha, e agora que consegui notar q ele me dá este erro:
SQL Server is aborting. Fatal exception c0000005 caught.
a versão do meu SQL é 8.00.2187
Alguém sabe o que eu posso tentar fazer
Jefferson Gobi
terça-feira, 23 de janeiro de 2007 13:10
Todas as Respostas
-
veja no event viewer o que esta logando e tambem no errorlog do sql server poste aqui por favor.
Abs;
terça-feira, 23 de janeiro de 2007 13:43 -
Vou colocar na sequencia dos acontecidos, antes daquela mensagem
- Stack Signature for the dump is 0xA5FF0B62
- Using 'dbghelp.dll' version '4.0.5'
*Stack Dump being sent to C:\Arquivos de programas\Microsoft SQL Server\MSSQL\log\SQLDump1490.txt- Error: 0, Severity: 19, State: 0
- SqlDumpExceptionHandler: Process 59 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 01/23/07 10:05:13 spid 59
*
* Exception Address = 00632E6E (SQLExit + 00028341 Line 0+00000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address C4F6E15F
* S E T _ I n t e 19 00 53 00 45 00 54 00 5f 00 49 00 6e 00 74 00 65 00
* g r a _ C o n t r 67 00 72 00 61 00 5f 00 43 00 6f 00 6e 00 74 00 72 00
* o l L o c P o s 6f 00 6c 00 4c 00 6f 00 63 00 50 00 6f 00 73 00 00 00
* @ I d e n t i f i 0e 40 00 49 00 64 00 65 00 6e 00 74 00 69 00 66 00 69
* c a d o r ç Ð 00 63 00 61 00 64 00 6f 00 72 00 00 e7 14 00 09 04 d0
* 3 0 9 5 5 7 6 00 00 0e 00 33 00 30 00 39 00 35 00 35 00 37 00 36 00
* @ L a t m D‹lçû 04 40 00 4c 00 61 00 74 00 00 6d 08 08 44 8b 6c e7 fb
* 2À @ L o n m \ 09 32 c0 04 40 00 4c 00 6f 00 6e 00 00 6d 08 08 5c 8f
* Âõ(¢HÀ @ E n d e r c2 f5 28 a2 48 c0 09 40 00 45 00 6e 00 64 00 65 00 72
* e c o c< Ð 00 65 00 63 00 6f 00 00 63 3c 00 00 00 09 04 d0 00 00
* < 1 . 7 2 K m 3c 00 00 00 31 00 2e 00 37 00 32 00 4b 00 6d 00 20 00
* N d e P O S T 4e 00 20 00 64 00 65 00 20 00 50 00 4f 00 53 00 54 00
* O G O I T U B A 4f 00 20 00 47 00 4f 00 49 00 54 00 55 00 42 00 41 00
* - G O @ V e l 20 00 2d 00 20 00 47 00 4f 00 0b 40 00 56 00 65 00 6c
* o c i d a d e m 00 6f 00 63 00 69 00 64 00 61 00 64 00 65 00 00 6d 08
* O@ @ D a t 08 00 00 00 00 00 80 4f 40 05 40 00 44 00 61 00 74 00
* a o ¿ ŒÜ¥ 61 00 00 6f 08 08 bf 98 00 00 8c dc a5 00
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00CBEFFF 008bf000
* ntdll 7C910000 7C9D3FFF 000c4000
* kernel32 7C800000 7C90BFFF 0010c000
* ADVAPI32 77D90000 77E3DFFF 000ae000
* RPCRT4 77C40000 77CDEFFF 0009f000
* MSVCP71 7C3A0000 7C41AFFF 0007b000
* MSVCR71 7C340000 7C395FFF 00056000
* opends60 41060000 41065FFF 00006000
* SHELL32 7C9E0000 7D1EAFFF 0080b000
* msvcrt 77B90000 77BE9FFF 0005a000
* GDI32 77BF0000 77C37FFF 00048000
* USER32 77F40000 77FD1FFF 00092000
* SHLWAPI 77EE0000 77F31FFF 00052000
* sqlsort 42AE0000 42B6FFFF 00090000
* ums 41070000 4107CFFF 0000d000
* ShimEng 71940000 71961FFF 00022000
* apphelp 75D70000 75D96FFF 00027000
* AcGenral 71490000 7165CFFF 001cd000
* WINMM 769C0000 769EDFFF 0002e000
* ole32 77510000 77643FFF 00134000
* OLEAUT32 77CF0000 77D7BFFF 0008c000
* MSACM32 77B60000 77B73FFF 00014000
* VERSION 77B80000 77B87FFF 00008000
* USERENV 76840000 76904FFF 000c5000
* UxTheme 719C0000 719F5FFF 00036000
* IMM32 761B0000 761CCFFF 0001d000
* comctl32 77360000 77462FFF 00103000
* sqlevn70 41080000 4108AFFF 0000b000
* NETAPI32 02CF0000 02D47FFF 00058000
* AUTHZ 02D50000 02D63FFF 00014000
* COMRES 02F00000 0308CFFF 0018d000
* XOLEHLP 03090000 03095FFF 00006000
* MSDTCPRX 030A0000 03117FFF 00078000
* msvcp60 03120000 03180FFF 00061000
* MTXCLU 03190000 031A8FFF 00019000
* WSOCK32 031B0000 031B9FFF 0000a000
* WS2_32 031C0000 031D6FFF 00017000
* WS2HELP 031E0000 031E7FFF 00008000
* CLUSAPI 03230000 03241FFF 00012000
* RESUTILS 03250000 03262FFF 00013000
* secur32 033F0000 03402FFF 00013000
* mswsock 03420000 03461FFF 00042000
* DNSAPI 03470000 0349EFFF 0002f000
* winrnr 034E0000 034E6FFF 00007000
* WLDAP32 034F0000 0351EFFF 0002f000
* rasadhlp 03540000 03547FFF 00008000
* SSNETLIB 00EB0000 00EC5FFF 00016000
* NTMARTA 03D10000 03D31FFF 00022000
* SAMLIB 00F10000 00F1EFFF 0000f000
* security 04430000 04433FFF 00004000
* crypt32 04440000 044D4FFF 00095000
* MSASN1 044E0000 044F1FFF 00012000
* schannel 04500000 04526FFF 00027000
* rsaenh 04040000 0406EFFF 0002f000
* PSAPI 04070000 0407AFFF 0000b000
* dssenh 04080000 040A3FFF 00024000
* hnetcfg 04330000 04388FFF 00059000
* wshtcpip 04180000 04187FFF 00008000
* SSmsLPCn 04190000 04197FFF 00008000
* SSnmPN70 041A0000 041A6FFF 00007000
* ntdsapi 04390000 043A4FFF 00015000
* SQLFTQRY 04230000 04255FFF 00026000
* xpsp2res 10000000 102CFFFF 002d0000
* CLBCatQ 04260000 042E2FFF 00083000
* sqloledb 04A90000 04B10FFF 00081000
* MSDART 042F0000 04309FFF 0001a000
* MSDATL3 04310000 04324FFF 00015000
* oledb32 04D20000 04D98FFF 00079000
* OLEDB32R 04DA0000 04DB1FFF 00012000
* msv1_0 04590000 045B6FFF 00027000
* iphlpapi 045C0000 045D9FFF 0001a000
* xpsqlbot 04580000 04585FFF 00006000
* xpstar 05170000 051BCFFF 0004d000
* SQLRESLD 051C0000 051CBFFF 0000c000
* SQLSVC 051D0000 051EAFFF 0001b000
* ODBC32 051F0000 0522CFFF 0003d000
* COMCTL32 05230000 052C6FFF 00097000
* comdlg32 052D0000 05318FFF 00049000
* odbcbcp 05320000 05325FFF 00006000
* W95SCM 05330000 0533CFFF 0000d000
* SQLUNIRL 05340000 0536CFFF 0002d000
* WINSPOOL 05370000 05396FFF 00027000
* SHFOLDER 053A0000 053A8FFF 00009000
* odbcint 05500000 05517FFF 00018000
* NDDEAPI 05630000 05636FFF 00007000
* SQLSVC 05640000 05645FFF 00006000
* xpstar 05650000 05658FFF 00009000
* dbghelp 05C80000 05D7FFFF 00100000
*
* Edi: 52C77E58: 00200045 004F0053 005A0055 00430041 004C0044 00330035
* Esi: 00000000:
* Eax: 00000004:
* Ebx: 52D9A0C0: 52D9A5B8 00000000 00000002 00040308 52D9A038 00000008
* Ecx: 004F0053: C4F6E0DF E68B0F05 8B0015F8 FFCF8B07 45894050 FC45DBFC
* Edx: C4F6E0DF:
* Eip: 00632E6E: 008092FF C0850000 68501A75 00000677 CAD3A468 C1546800
* Ebp: 04FDF388: 04FDFA6C 00632357 00000003 52D9A0C0 00000000 00B3ED78
* SegCs: 0000001B:
* EFlags: 00010206: 00690057 0064006E 0077006F 005F0073 0054004E 00500000
* Esp: 04FDF364: 00000001 FFFFFFFF FFFFFFFF 00000000 00A9C15B 00000000
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 00632E6E Module(sqlservr+00232E6E) (SQLExit+00028341)
* 00632357 Module(sqlservr+00232357) (SQLExit+0002782A)
* 0043F911 Module(sqlservr+0003F911)
* 00427011 Module(sqlservr+00027011)
* 41071B73 Module(ums+00001B73) (ProcessWorkRequests+000002D9)
* 410727A7 Module(ums+000027A7) (ThreadStartRoutine+00000098)
* 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA)
* 7C82608B Module(kernel32+0002608B) (GetModuleFileNameA+000000EB)
* -------------------------------------------------------------------------------- Stack Signature for the dump is 0xADC8CC62
- SQL Server is aborting. Fatal exception c0000005 caught.
terça-feira, 23 de janeiro de 2007 13:47 -
service pack do sql e do windows ( quais as versoes tambem )
Abs;
terça-feira, 23 de janeiro de 2007 13:54 -
SQL Server 2000
SP4 e a versão do meu SQL é 8.00.2187
terça-feira, 23 de janeiro de 2007 13:57 -
Qual comando é executado quando ocorre o erro ?... vc tem como monitorar isso ?terça-feira, 23 de janeiro de 2007 15:04
-
Note, que o erro deu durante a execução de uma SP, mas já tive em várias outras SPs.terça-feira, 23 de janeiro de 2007 16:28
-
Jefferson
Veja se o Protocolo VIA esta enabled, caso esteja mantenha o disabled.
ATT Jonathan Santosquinta-feira, 22 de outubro de 2009 20:40