none
企业SQL数据库非法宕机,SQL服务被停止 RRS feed

  • 问题

  • 今天早上遇到用户反映,无法访问数据库,检查发现SQL服务全部关闭,日志里查看发现在昨天晚上0点出现。

     

    在系统日志里面发现:


    由于出现异常 c0000005,SQL Server 正在终止。此错误可能是由未处理的 Win32 或 C++ 异常造成的,也可能是因在处理异常过程中遇到的违规访问引起的。请查看 SQL 错误日志,获取任何相关的堆栈转储或消息。此异常会强制 SQL Server 关闭。要从此错误中恢复,请重新启动服务器(除非已将 SQLAgent 配置为自动重新启动)。

     

     

    SQL日志信息:

    12/09/2011 00:01:12,服务器,未知,The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Administrator should deregister this SPN manually to avoid client authentication errors.
    12/09/2011 00:01:12,spid53,未知,SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
    12/09/2011 00:01:12,spid53,未知,SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception<c/> 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<c/> restart the server (unless SQLAgent is configured to auto restart).
    12/09/2011 00:01:12,spid53,未知,错误: 17311,严重性: 16,状态: 1。
    12/09/2011 00:01:12,spid53,未知,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
    12/09/2011 00:01:11,spid53,未知,Stack Signature for the dump is 0xEB25F5AA
    12/09/2011 00:01:11,spid53,未知,78132A36 Module(MSVCR80+00002A36)
    12/09/2011 00:01:11,spid53,未知,781329AA Module(MSVCR80+000029AA)
    12/09/2011 00:01:11,spid53,未知,010D83F0 Module(sqlservr+000D83F0)
    12/09/2011 00:01:11,spid53,未知,010D746E Module(sqlservr+000D746E)
    12/09/2011 00:01:11,spid53,未知,010D7B71 Module(sqlservr+000D7B71)
    12/09/2011 00:01:11,spid53,未知,010D764A Module(sqlservr+000D764A)
    12/09/2011 00:01:11,spid53,未知,010086E7 Module(sqlservr+000086E7)
    12/09/2011 00:01:11,spid53,未知,010089C5 Module(sqlservr+000089C5)
    12/09/2011 00:01:11,spid53,未知,0100889F Module(sqlservr+0000889F)
    12/09/2011 00:01:11,spid53,未知,01041C35 Module(sqlservr+00041C35)
    12/09/2011 00:01:11,spid53,未知,010B09F0 Module(sqlservr+000B09F0)
    12/09/2011 00:01:11,spid53,未知,0100850E Module(sqlservr+0000850E)
    12/09/2011 00:01:11,spid53,未知,010905B2 Module(sqlservr+000905B2)
    12/09/2011 00:01:11,spid53,未知,01090523 Module(sqlservr+00090523)
    12/09/2011 00:01:11,spid53,未知,01583844 Module(sqlservr+00583844)
    12/09/2011 00:01:11,spid53,未知,* Short Stack Dump
    12/09/2011 00:01:11,spid53,未知,* -------------------------------------------------------------------------------
    12/09/2011 00:01:11,spid53,未知,* *******************************************************************************
    12/09/2011 00:01:11,spid53,未知,*      SegSs: 00000023:
    12/09/2011 00:01:11,spid53,未知,*        Esp: 669CF9D0:  0DDB0CB4  00000035  00730073  0145D745  00000000  0DDB0B10
    12/09/2011 00:01:11,spid53,未知,*     EFlags: 00010202:  005C006E  004E0000  004D0055  00450042  005F0052  0046004F
    12/09/2011 00:01:11,spid53,未知,*      SegCs: 0000001B:
    12/09/2011 00:01:11,spid53,未知,*        Ebp: 669CF9E8:  669CFA00  01090523  00000000  00000000  00000001  669CF992
    12/09/2011 00:01:11,spid53,未知,*        Eip: 01583844:  FF48508B  184F8BD2  F702E9C1  01C1F6D1  C0830F75  FFCA8324
    12/09/2011 00:01:11,spid53,未知,*        Edx: 00000040:
    12/09/2011 00:01:11,spid53,未知,*        Ecx: 006E006F:  00000000  00000000  00000000  00000000  00000000  00000000
    12/09/2011 00:01:11,spid53,未知,*        Ebx: 00000035:
    12/09/2011 00:01:11,spid53,未知,*        Eax: 00000000:
    12/09/2011 00:01:11,spid53,未知,*        Esi: 0DDB0CB4:  159DC0A8  159DC0A8  00000000  00000000  000AA9FC  00000001
    12/09/2011 00:01:11,spid53,未知,*        Edi: 159DC0A8:  00000000  00000000  00690074  006E006F  003D0020  00270020
    12/09/2011 00:01:11,spid53,未知,*
    12/09/2011 00:01:11,spid53,未知,* dbghelp                        6B6D0000  6B7E7FFF  00118000
    12/09/2011 00:01:11,spid53,未知,* sqlevn70                       68FB0000  69140FFF  00191000
    12/09/2011 00:01:11,spid53,未知,* sqlevn70                       68D00000  68E90FFF  00191000
    12/09/2011 00:01:11,spid53,未知,* sqlevn70                       68B20000  68CFCFFF  001dd000
    12/09/2011 00:01:11,spid53,未知,* sqlevn70                       68940000  68B11FFF  001d2000
    12/09/2011 00:01:11,spid53,未知,* sqlevn70                       687A0000  68930FFF  00191000
    12/09/2011 00:01:11,spid53,未知,* sqlevn70                       685B0000  68797FFF  001e8000
    12/09/2011 00:01:11,spid53,未知,* sqlevn70                       64BF0000  64DD8FFF  001e9000
    12/09/2011 00:01:11,spid53,未知,* sqlvdi                         62B60000  62B80FFF  00021000
    12/09/2011 00:01:11,spid53,未知,* xplog70                        65880000  65882FFF  00003000
    12/09/2011 00:01:11,spid53,未知,* xplog70                        65860000  6586BFFF  0000c000
    12/09/2011 00:01:11,spid53,未知,* xpstar90                       65830000  65855FFF  00026000
    12/09/2011 00:01:11,spid53,未知,* SQLSVC90                       65820000  65822FFF  00003000
    12/09/2011 00:01:11,spid53,未知,* odbcint                        65800000  65811FFF  00012000
    12/09/2011 00:01:11,spid53,未知,* ATL80                          7C630000  7C64AFFF  0001b000
    12/09/2011 00:01:11,spid53,未知,* SqlResourceLoader              65520000  65525FFF  00006000
    12/09/2011 00:01:11,spid53,未知,* SQLSVC90                       654F0000  65509FFF  0001a000
    12/09/2011 00:01:11,spid53,未知,* BatchParser90                  654C0000  654DDFFF  0001e000
    12/09/2011 00:01:11,spid53,未知,* ODBC32                         65480000  654BCFFF  0003d000
    12/09/2011 00:01:11,spid53,未知,* SQLSCM90                       65460000  65468FFF  00009000
    12/09/2011 00:01:11,spid53,未知,* xpstar90                       65400000  65444FFF  00045000
    12/09/2011 00:01:11,spid53,未知,* xpsqlbot                       652E0000  652E5FFF  00006000
    12/09/2011 00:01:11,spid53,未知,* msftepxy                       64950000  64964FFF  00015000
    12/09/2011 00:01:11,spid53,未知,* SQLNCLIR                       00830000  00862FFF  00033000
    12/09/2011 00:01:11,spid53,未知,* comdlg32                       761A0000  761E6FFF  00047000
    12/09/2011 00:01:11,spid53,未知,* COMCTL32                       77370000  77406FFF  00097000
    12/09/2011 00:01:11,spid53,未知,* sqlncli                        64630000  6484DFFF  0021e000
    12/09/2011 00:01:11,spid53,未知,* CLBCatQ                        77680000  77702FFF  00083000
    12/09/2011 00:01:11,spid53,未知,* xpsp2res                       640E0000  64628FFF  00549000
    12/09/2011 00:01:11,spid53,未知,* ntdsapi                        76630000  76643FFF  00014000
    12/09/2011 00:01:11,spid53,未知,* SAMLIB                         7E020000  7E02EFFF  0000f000
    12/09/2011 00:01:11,spid53,未知,* NTMARTA                        777E0000  777FFFFF  00020000
    12/09/2011 00:01:11,spid53,未知,* wshtcpip                       71A40000  71A47FFF  00008000
    12/09/2011 00:01:11,spid53,未知,* hnetcfg                        69660000  696B6FFF  00057000
    12/09/2011 00:01:11,spid53,未知,* dssenh                         68100000  68126FFF  00027000
    12/09/2011 00:01:11,spid53,未知,* imagehlp                       76B70000  76B97FFF  00028000
    12/09/2011 00:01:11,spid53,未知,* WINTRUST                       76B10000  76B3AFFF  0002b000
    12/09/2011 00:01:11,spid53,未知,* dbghelp                        63C10000  63D27FFF  00118000
    12/09/2011 00:01:11,spid53,未知,* msfte                          639B0000  63C07FFF  00258000
    12/09/2011 00:01:11,spid53,未知,* security                       71E90000  71E93FFF  00004000
    12/09/2011 00:01:11,spid53,未知,* rasadhlp                       76EE0000  76EE4FFF  00005000
    12/09/2011 00:01:11,spid53,未知,* WLDAP32                        76E70000  76E9DFFF  0002e000
    12/09/2011 00:01:11,spid53,未知,* winrnr                         76ED0000  76ED6FFF  00007000
    12/09/2011 00:01:11,spid53,未知,* DNSAPI                         76E30000  76E5AFFF  0002b000
    12/09/2011 00:01:11,spid53,未知,* RESUTILS                       74E30000  74E42FFF  00013000
    12/09/2011 00:01:11,spid53,未知,* CLUSAPI                        74D20000  74D31FFF  00012000
    12/09/2011 00:01:11,spid53,未知,* WSOCK32                        71B10000  71B1AFFF  0000b000
    12/09/2011 00:01:11,spid53,未知,* VERSION                        77B60000  77B67FFF  00008000
    12/09/2011 00:01:11,spid53,未知,* MTXCLU                         74E80000  74E98FFF  00019000
    12/09/2011 00:01:11,spid53,未知,* msvcp60                        62CF0000  62D54FFF  00065000
    12/09/2011 00:01:11,spid53,未知,* OLEAUT32                       775F0000  7767AFFF  0008b000
    12/09/2011 00:01:11,spid53,未知,* MSDTCPRX                       62C70000  62CE8FFF  00079000
    12/09/2011 00:01:11,spid53,未知,* XOLEHLP                        62C60000  62C65FFF  00006000
    12/09/2011 00:01:11,spid53,未知,* COMRES                         76F70000  770C9FFF  0015a000
    12/09/2011 00:01:11,spid53,未知,* schannel                       76690000  766B6FFF  00027000
    12/09/2011 00:01:11,spid53,未知,* cryptdll                       76620000  7662BFFF  0000c000
    12/09/2011 00:01:11,spid53,未知,* kerberos                       71C00000  71C56FFF  00057000
    12/09/2011 00:01:11,spid53,未知,* iphlpapi                       76C50000  76C68FFF  00019000
    12/09/2011 00:01:11,spid53,未知,* msv1_0                         76BF0000  76C16FFF  00027000
    12/09/2011 00:01:11,spid53,未知,* ole32                          774B0000  775E8FFF  00139000
    12/09/2011 00:01:11,spid53,未知,* MSCOREE                        62810000  62854FFF  00045000
    12/09/2011 00:01:11,spid53,未知,* AUTHZ                          76BA0000  76BB3FFF  00014000
    12/09/2011 00:01:11,spid53,未知,* rsaenh                         68000000  68034FFF  00035000
    12/09/2011 00:01:11,spid53,未知,* SQLOS                          344D0000  344D4FFF  00005000
    12/09/2011 00:01:11,spid53,未知,* sqlevn70                       00870000  00A00FFF  00191000
    12/09/2011 00:01:11,spid53,未知,* sqlevn70                       4F610000  4F7A0FFF  00191000
    12/09/2011 00:01:11,spid53,未知,* instapi                        48060000  48069FFF  0000a000
    12/09/2011 00:01:11,spid53,未知,* psapi                          76AB0000  76ABAFFF  0000b000
    12/09/2011 00:01:11,spid53,未知,* comctl32                       77CD0000  77DD2FFF  00103000
    12/09/2011 00:01:11,spid53,未知,* USP10                          74AE0000  74B44FFF  00065000
    12/09/2011 00:01:11,spid53,未知,* LPK                            7F000000  7F008FFF  00009000
    12/09/2011 00:01:11,spid53,未知,* IMM32                          76180000  7619CFFF  0001d000
    12/09/2011 00:01:11,spid53,未知,* SHLWAPI                        77EB0000  77F01FFF  00052000
    12/09/2011 00:01:11,spid53,未知,* SHELL32                        7CA10000  7D1EAFFF  007db000
    12/09/2011 00:01:11,spid53,未知,* NETAPI32                       71BA0000  71BF6FFF  00057000
    12/09/2011 00:01:11,spid53,未知,* opends60                       333E0000  333E6FFF  00007000
    12/09/2011 00:01:11,spid53,未知,* USERENV                        75870000  7592CFFF  000bd000
    12/09/2011 00:01:11,spid53,未知,* WS2HELP                        71B50000  71B57FFF  00008000
    12/09/2011 00:01:11,spid53,未知,* WS2_32                         71B60000  71B76FFF  00017000
    12/09/2011 00:01:11,spid53,未知,* MSWSOCK                        71A80000  71ABFFFF  00040000
    12/09/2011 00:01:11,spid53,未知,* MSASN1                         76080000  76091FFF  00012000
    12/09/2011 00:01:11,spid53,未知,* CRYPT32                        760A0000  76130FFF  00091000
    12/09/2011 00:01:11,spid53,未知,* GDI32                          77BD0000  77C17FFF  00048000
    12/09/2011 00:01:11,spid53,未知,* USER32                         77E10000  77E9FFFF  00090000
    12/09/2011 00:01:11,spid53,未知,* Secur32                        76EB0000  76EC2FFF  00013000
    12/09/2011 00:01:11,spid53,未知,* RPCRT4                         77C20000  77CBEFFF  0009f000
    12/09/2011 00:01:11,spid53,未知,* ADVAPI32                       77F30000  77FDAFFF  000ab000
    12/09/2011 00:01:11,spid53,未知,* MSVCP80                        7C420000  7C4A6FFF  00087000
    12/09/2011 00:01:11,spid53,未知,* msvcrt                         77B70000  77BC9FFF  0005a000
    12/09/2011 00:01:11,spid53,未知,* MSVCR80                        78130000  781CAFFF  0009b000
    12/09/2011 00:01:11,spid53,未知,* kernel32                       7C800000  7C92AFFF  0012b000
    12/09/2011 00:01:11,spid53,未知,* ntdll                          7C930000  7C9FFFFF  000d0000
    12/09/2011 00:01:11,spid53,未知,* sqlservr                       01000000  02BA7FFF  01ba8000
    12/09/2011 00:01:11,spid53,未知,*  MODULE                          BASE      END       SIZE
    12/09/2011 00:01:11,spid53,未知,*
    12/09/2011 00:01:11,spid53,未知,*
    12/09/2011 00:01:11,spid53,未知,*  m                  6d 01 00 00
    12/09/2011 00:01:11,spid53,未知,*  S     &        &   53 00 00 00 00 00 26 04 04 01 00 00 00 00 00 26 04 04
    12/09/2011 00:01:11,spid53,未知,*  E D _ R E C O R D  45 00 44 00 5f 00 52 00 45 00 43 00 4f 00 52 00 44 00
    12/09/2011 00:01:11,spid53,未知,*  I M E _ E X P I R  49 00 4d 00 45 00 5f 00 45 00 58 00 50 00 49 00 52 00
    12/09/2011 00:01:11,spid53,未知,*  _ D E L E T E _ T  5f 00 44 00 45 00 4c 00 45 00 54 00 45 00 5f 00 54 00
    12/09/2011 00:01:11,spid53,未知,*  $ C M _ M S S Q L  24 00 43 00 4d 00 5f 00 4d 00 53 00 53 00 51 00 4c 00
    12/09/2011 00:01:11,spid53,未知,* Input Buffer 94 bytes -
    12/09/2011 00:01:11,spid53,未知,*   Access Violation occurred reading address 00000048
    12/09/2011 00:01:11,spid53,未知,*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
    12/09/2011 00:01:11,spid53,未知,*   Exception Address = 01583844 Module(sqlservr+00583844)
    12/09/2011 00:01:11,spid53,未知,*
    12/09/2011 00:01:11,spid53,未知,*
    12/09/2011 00:01:11,spid53,未知,*   12/09/11 00:01:11 spid 53
    12/09/2011 00:01:11,spid53,未知,* BEGIN STACK DUMP:
    12/09/2011 00:01:11,spid53,未知,*
    12/09/2011 00:01:11,spid53,未知,* *******************************************************************************

    2011年12月9日 1:53

全部回复

  • 12/09/2011 00:01:11,spid53,未知,Using 'dbghelp.dll' version '4.0.5'
    12/09/2011 00:01:11,spid53,未知,SQL Server Assertion: File: <"xact.cpp"><c/> line = 2788 Failed Assertion = '!m_updNestedXactCnt' Trying to use the transaction while there are 1 parallel nested xacts outstanding. This error may be timing-related. If the error persists after rerunning the statement<c/> use DBCC CHECKDB to check the database for structural integrity<c/> or restart the server to ensure in-memory data structures are not corrupted.
    12/09/2011 00:01:11,spid53,未知,错误: 17065,严重性: 16,状态: 1。
    12/09/2011 00:01:11,spid53,未知,External dump process return code 0x20000001.<nl/>External dump process returned no errors.

    12/09/2011 00:01:10,spid53,未知,SQL Server Assertion: File: <"xact.cpp"><c/> line = 2630 Failed Assertion = '!m_updNestedXactCnt' Trying to use the transaction while there are 1 parallel nested xacts outstanding. This error may be timing-related. If the error persists after rerunning the statement<c/> use DBCC CHECKDB to check the database for structural integrity<c/> or restart the server to ensure in-memory data structures are not corrupted.
    12/09/2011 00:01:10,spid53,未知,错误: 17065,严重性: 16,状态: 1。
    12/09/2011 00:01:10,spid53,未知,External dump process return code 0x20000001.<nl/>External dump process returned no errors.

    12/09/2011 00:01:01,spid52,未知,Internal Error: Text manager cannot continue with current statement. Run DBCC CHECKTABLE.
    12/09/2011 00:01:01,spid52,未知,错误: 7102,严重性: 20,状态: 99。
    12/09/2011 00:00:56,spid13s,未知,This instance of SQL Server has been using a process ID of 6120 since 2011-12-5 9:19:16 (local) 2011-12-5 1:19:16 (UTC). This is an informational message only; no user action is required.
    12/08/2011 23:01:02,spid51,未知,Internal Error: Text manager cannot continue with current statement. Run DBCC CHECKTABLE.

    2011年12月9日 1:55
  • 先做一次  DBCC CHECKDB

    检查一下。

     

     


    family as water
    2011年12月9日 1:59
  • 有困难,找警察,比较靠谱。呵

     

    应该留下运行环境,比如OS、DBMS版本、补丁什么的


    Try SQL Server 2008 QQ:315054403 dgdba@hotmail.com
    2011年12月9日 2:07
  • 已经检查过了,么有什么错误显示

    CHECKDB 在数据库 'mssqlsystemresource' 中发现 0 个分配错误和 0 个一致性错误。
    DBCC 执行完毕。如果 DBCC 输出了错误信息,请与系统管理员联系。

    2011年12月9日 2:29
  • os:windows server 2003

     

    DBMS:SQL 2005 SP1

    2011年12月9日 2:34
  • Stack dump usually means internal error, should install sql2k5 sp4 first.
    2011年12月9日 2:38
  • 这种错误可以检查一下是否是加载的extended stored procedure造成的。或者直接联系微软的客户支持比较靠谱。

    2011年12月9日 3:50
  • 联系下微软技术支持吧!
    胡冰
    • 已编辑 胡冰 2011年12月9日 7:38 写错字了!
    2011年12月9日 7:38