locked
SOCORRO: SQL Server "Desliga" Sozinho RRS feed

  • 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 Santos
    quinta-feira, 22 de outubro de 2009 20:40