Меню

Ошибка 17311 серьезность 16 состояние 1

  • Remove From My Forums

  • Вопрос

  • Good day,

    Last week, I started receiving this error inconjunction with an SSIS package which executes at a particular time.  Any help would be appreciated.  Here are the details

    Environment:  Virtualized Server
    Sql Version:  Microsoft SQL Server 2005 — 9.00.4053.00 (Intel X86)(Build 3790: Service Pack 2)

    SSIS Package:  Copies a file based database from server A to SQL Server for importing into SQL Server database.
    SSIS Executed:  Every two hours
    Other Components:  ACCDB which contains links to the file-based database, using Topspeed Drivers; SQL Server contains a linked object to the ACCDB.

    Symptoms:  Throughout the day, this process runs.  When it is executed at 6:00 pm, the server crashes.  I attempted to change the time that it runs in case some other process was causing resource to not be availble, and looked at the AV scan
    settings and schedule.  Nothing has helped.  This issue has been occurring for the past week.  I’m not sure how to interpret the information in the error log or what to try next.  Your input is appreciated. 

    The error log is below:

    2012-04-13 18:45:50.53 Server      Error: 17311, Severity: 16, State: 1.
    2012-04-13 18:45:50.53 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).

    2012-04-13 18:45:50.68 Server      Using ‘dbghelp.dll’ version ‘4.0.5’
    2012-04-13 18:45:50.72 Server      **Dump thread — spid = 0, PSS = 0x00000000, EC = 0x00000000
    2012-04-13 18:45:50.72 Server      ***Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0005.txt
    2012-04-13 18:45:50.72 Server      * *******************************************************************************
    2012-04-13 18:45:50.72 Server      *
    2012-04-13 18:45:50.72 Server      * BEGIN STACK DUMP:
    2012-04-13 18:45:50.72 Server      *   04/13/12 18:45:50 spid 0
    2012-04-13 18:45:50.72 Server      *
    2012-04-13 18:45:50.72 Server      * ex_handle_except encountered exception C0000005 — Server terminating
    2012-04-13 18:45:50.72 Server      *
    2012-04-13 18:45:50.72 Server      *
    2012-04-13 18:45:50.72 Server      *  MODULE                          BASE     
    END       SIZE
    2012-04-13 18:45:50.72 Server      * sqlservr                       01000000  02C1FFFF  01c20000
    2012-04-13 18:45:50.72 Server      * ntdll                          7C800000  7C8C2FFF  000c3000
    2012-04-13 18:45:50.72 Server      * kernel32                       77E40000  77F41FFF  00102000
    2012-04-13 18:45:50.72 Server      * MSVCR80                        78130000  781CAFFF  0009b000
    2012-04-13 18:45:50.72 Server      * msvcrt                         77BA0000  77BF9FFF  0005a000
    2012-04-13 18:45:50.72 Server      * MSVCP80                        7C420000  7C4A6FFF  00087000
    2012-04-13 18:45:50.72 Server      * ADVAPI32                       7D1E0000  7D27BFFF  0009c000
    2012-04-13 18:45:50.72 Server      * RPCRT4                         77C50000  77CEFFFF  000a0000
    2012-04-13 18:45:50.72 Server      * Secur32                        76F50000  76F62FFF  00013000
    2012-04-13 18:45:50.72 Server      * sqlos                          344D0000  344D4FFF  00005000
    2012-04-13 18:45:50.72 Server      * USERENV                        76920000  769E1FFF  000c2000
    2012-04-13 18:45:50.72 Server      * USER32                         77380000  77410FFF  00091000
    2012-04-13 18:45:50.72 Server      * GDI32                          77C00000  77C48FFF  00049000
    2012-04-13 18:45:50.72 Server      * WINMM                          76AA0000  76ACCFFF  0002d000
    2012-04-13 18:45:50.72 Server      * opends60                       333E0000  333E6FFF  00007000
    2012-04-13 18:45:50.72 Server      * NETAPI32                       71C40000  71C96FFF  00057000
    2012-04-13 18:45:50.72 Server      * psapi                          76B70000  76B7AFFF  0000b000
    2012-04-13 18:45:50.72 Server      * instapi                        48060000  48069FFF  0000a000
    2012-04-13 18:45:50.72 Server      * sqlevn70                       4F610000  4F7B8FFF  001a9000
    2012-04-13 18:45:50.72 Server      * NTMARTA                        77E00000  77E20FFF  00021000
    2012-04-13 18:45:50.72 Server      * WLDAP32                        76F10000  76F3DFFF  0002e000
    2012-04-13 18:45:50.72 Server      * SAMLIB                         7E020000  7E02EFFF  0000f000
    2012-04-13 18:45:50.73 Server      * ole32                          77670000  777A8FFF  00139000
    2012-04-13 18:45:50.73 Server      * rsaenh                         68000000  68034FFF  00035000
    2012-04-13 18:45:50.73 Server      * AUTHZ                          76C40000  76C53FFF  00014000
    2012-04-13 18:45:50.73 Server      * MSCOREE                        33DF0000  33E39FFF  0004a000
    2012-04-13 18:45:50.73 Server      * msv1_0                         76C90000  76CB6FFF  00027000
    2012-04-13 18:45:50.73 Server      * cryptdll                       34050000  3405BFFF  0000c000
    2012-04-13 18:45:50.73 Server      * WS2_32                         71C00000  71C16FFF  00017000
    2012-04-13 18:45:50.73 Server      * WS2HELP                        71BF0000  71BF7FFF  00008000
    2012-04-13 18:45:50.73 Server      * iphlpapi                       76CF0000  76D09FFF  0001a000
    2012-04-13 18:45:50.73 Server      * kerberos                       340B0000  34108FFF  00059000
    2012-04-13 18:45:50.73 Server      * MSASN1                         34110000  34121FFF  00012000
    2012-04-13 18:45:50.73 Server      * schannel                       34140000  34168FFF  00029000
    2012-04-13 18:45:50.73 Server      * CRYPT32                        34170000  34202FFF  00093000
    2012-04-13 18:45:50.73 Server      * COMRES                         77010000  770D5FFF  000c6000
    2012-04-13 18:45:50.73 Server      * XOLEHLP                        34250000  34255FFF  00006000
    2012-04-13 18:45:50.73 Server      * MSDTCPRX                       34260000  342D8FFF  00079000
    2012-04-13 18:45:50.73 Server      * OLEAUT32                       7D0E0000  7D16AFFF  0008b000
    2012-04-13 18:45:50.73 Server      * msvcp60                        342E0000  34344FFF  00065000
    2012-04-13 18:45:50.73 Server      * MTXCLU                         34350000  34368FFF  00019000
    2012-04-13 18:45:50.73 Server      * VERSION                        77B90000  77B97FFF  00008000
    2012-04-13 18:45:50.73 Server      * WSOCK32                        71BB0000  71BB8FFF  00009000
    2012-04-13 18:45:50.73 Server      * CLUSAPI                        34370000  34381FFF  00012000
    2012-04-13 18:45:50.73 Server      * RESUTILS                       34390000  343A2FFF  00013000
    2012-04-13 18:45:50.73 Server      * mswsock                        71B20000  71B60FFF  00041000
    2012-04-13 18:45:50.73 Server      * DNSAPI                         76ED0000  76EF9FFF  0002a000
    2012-04-13 18:45:50.73 Server      * winrnr                         76F70000  76F76FFF  00007000
    2012-04-13 18:45:50.73 Server      * rasadhlp                       76F80000  76F84FFF  00005000
    2012-04-13 18:45:50.73 Server      * security                       62740000  62743FFF  00004000
    2012-04-13 18:45:50.73 Server      * msfte                          62E10000  63068FFF  00259000
    2012-04-13 18:45:50.73 Server      * dbghelp                        63080000  63194FFF  00115000
    2012-04-13 18:45:50.73 Server      * WINTRUST                       76BB0000  76BDBFFF  0002c000
    2012-04-13 18:45:50.73 Server      * imagehlp                       76C10000  76C37FFF  00028000
    2012-04-13 18:45:50.73 Server      * dssenh                         68100000  68126FFF  00027000
    2012-04-13 18:45:50.73 Server      * hnetcfg                        63460000  634B9FFF  0005a000
    2012-04-13 18:45:50.73 Server      * wshtcpip                       71AE0000  71AE7FFF  00008000
    2012-04-13 18:45:50.73 Server      * ntdsapi                        63580000  63593FFF  00014000
    2012-04-13 18:45:50.73 Server      * xpsp2res                       635A0000  63864FFF  002c5000
    2012-04-13 18:45:50.73 Server      * CLBCatQ                        777B0000  77832FFF  00083000
    2012-04-13 18:45:50.73 Server      * sqlncli                        63870000  63A96FFF  00227000
    2012-04-13 18:45:50.73 Server      * COMCTL32                       77530000  775C6FFF  00097000
    2012-04-13 18:45:50.73 Server      * comdlg32                       00770000  007B8FFF  00049000
    2012-04-13 18:45:50.73 Server      * SHLWAPI                        7D180000  7D1D1FFF  00052000
    2012-04-13 18:45:50.73 Server      * SHELL32                        7C8D0000  7D0CEFFF  007ff000
    2012-04-13 18:45:50.73 Server      * comctl32                       77420000  77522FFF  00103000
    2012-04-13 18:45:50.73 Server      * SQLNCLIR                       63AD0000  63B02FFF  00033000
    2012-04-13 18:45:50.73 Server      * msftepxy                       63C90000  63CA4FFF  00015000
    2012-04-13 18:45:50.73 Server      * xpsqlbot                       64120000  64125FFF  00006000
    2012-04-13 18:45:50.73 Server      * xpstar90                       64140000  6418AFFF  0004b000
    2012-04-13 18:45:50.73 Server      * SQLSCM90                       641A0000  641A8FFF  00009000
    2012-04-13 18:45:50.73 Server      * ODBC32                         641E0000  6421DFFF  0003e000
    2012-04-13 18:45:50.73 Server      * BatchParser90                  64220000  6423EFFF  0001f000
    2012-04-13 18:45:50.73 Server      * ATL80                          7C630000  7C64AFFF  0001b000
    2012-04-13 18:45:50.73 Server      * odbcint                        64290000  642A6FFF  00017000
    2012-04-13 18:45:50.73 Server      * xpstar90                       64440000  64465FFF  00026000
    2012-04-13 18:45:50.73 Server      * xplog70                        64470000  6447BFFF  0000c000
    2012-04-13 18:45:50.73 Server      * xplog70                        64490000  64492FFF  00003000
    2012-04-13 18:45:50.73 Server      * oledb32                        64730000  647A8FFF  00079000
    2012-04-13 18:45:50.73 Server      * MSDART                         63C20000  63C39FFF  0001a000
    2012-04-13 18:45:50.73 Server      * OLEDB32R                       64AF0000  64B00FFF  00011000
    2012-04-13 18:45:50.73 Server      * comsvcs                        64B10000  64C54FFF  00145000
    2012-04-13 18:45:50.73 Server      * ACEOLEDB                       64C60000  64CBEFFF  0005f000
    2012-04-13 18:45:50.73 Server      * MSVCR90                        64CC0000  64D62FFF  000a3000
    2012-04-13 18:45:50.73 Server      * mso                            64D80000  65F5FFFF 
    011e0000
    2012-04-13 18:45:50.73 Server      * msi                            65F70000  6622DFFF 
    002be000
    2012-04-13 18:45:50.73 Server      * ACECORE                        663B0000  665C9FFF  0021a000
    2012-04-13 18:45:50.73 Server      * MSVCP90                        665E0000  6666DFFF  0008e000
    2012-04-13 18:45:50.73 Server      * ACEWSTR                        66AD0000  66BA1FFF  000d2000
    2012-04-13 18:45:50.73 Server      * MSORES                         68130000  6C659FFF  0452a000
    2012-04-13 18:45:50.73 Server      * MSOINTL                        66BD0000  66E31FFF  00262000
    2012-04-13 18:45:50.73 Server      * ACEES                          67370000  67419FFF  000aa000
    2012-04-13 18:45:50.73 Server      * VBAJET32                       67430000  6743DFFF  0000e000
    2012-04-13 18:45:50.73 Server      * expsrv                         67450000  674C0FFF  00071000
    2012-04-13 18:45:50.73 Server      * sqlvdi                         67030000  67051FFF  00022000
    2012-04-13 18:45:50.73 Server      * office                         70660000  70A6EFFF  0040f000
    2012-04-13 18:45:50.73 Server      * UxTheme                        71B70000  71BA5FFF  00036000
    2012-04-13 18:45:50.73 Server      * dbghelp                        70B70000  70C84FFF  00115000
    2012-04-13 18:45:50.73 Server      *
    2012-04-13 18:45:50.73 Server      *        Edi: 67FBE8E4:  001B7068  00000000  00000000  00000000  00000000  00000000 

    2012-04-13 18:45:50.73 Server      *        Esi: 00000000: 

    2012-04-13 18:45:50.73 Server      *        Eax: 67FBE7C8:  000042AC  00000000  00000000  77E4BEF7  00000000  00000002 

    2012-04-13 18:45:50.73 Server      *        Ebx: 0000003F: 

    2012-04-13 18:45:50.73 Server      *        Ecx: 67FBEE38:  00000000  00010007  00000000  0090008E  001B706C  00000000 

    2012-04-13 18:45:50.73 Server      *        Edx: 0000003D: 

    2012-04-13 18:45:50.73 Server      *        Eip: 77E4BEF7:  10C2C95E  01093D00  840FC000  00000095  F29DE950  9090FFFF 

    2012-04-13 18:45:50.73 Server      *        Ebp: 67FBE818:  67FBE85C  021AE24C  000042AC  00000000  00000000  00000000 

    2012-04-13 18:45:50.73 Server      *      SegCs: 7813001B:  00000000  00000000  00000000  00000000  00000000  00000000 

    2012-04-13 18:45:50.73 Server      *     EFlags: 00000246: 

    2012-04-13 18:45:50.73 Server      *        Esp: 67FBE7C4:  00000000  000042AC  00000000  00000000  77E4BEF7  00000000 

    2012-04-13 18:45:50.73 Server      *      SegSs: 78130023:  00000000  00000000  00000000  00000000  00000000  00000000 

    2012-04-13 18:45:50.74 Server      * *******************************************************************************
    2012-04-13 18:45:50.74 Server      * ——————————————————————————-
    2012-04-13 18:45:50.74 Server      * Short Stack Dump
    2012-04-13 18:45:50.75 Server      77E4BEF7 Module(kernel32+0000BEF7)
    2012-04-13 18:45:50.75 Server      021AE24C Module(sqlservr+011AE24C)
    2012-04-13 18:45:50.75 Server      021B2160 Module(sqlservr+011B2160)
    2012-04-13 18:45:50.75 Server      021B1D0D Module(sqlservr+011B1D0D)
    2012-04-13 18:45:50.75 Server      02422369 Module(sqlservr+01422369)
    2012-04-13 18:45:50.75 Server      77E761B7 Module(kernel32+000361B7)
    2012-04-13 18:45:50.75 Server      77E792A3 Module(kernel32+000392A3)
    2012-04-13 18:45:50.77 Server      Stack Signature for the dump is 0x1A38D65C
    2012-04-13 18:45:53.94 Server      External dump process return code 0x20000001.
    External dump process returned no errors.

    Thank you.

Ответы

  • Hi GFrank,

    A similar error is reported in
    this KB article, with the fix initially released in Cumulative Update 9 for SQL Server 2005 Service Pack 3. I would recommend you apply the latest Service Pack via
    SQL Server 2005 to avoid known issues.

    Stephanie Lv

    TechNet Community Support

    • Помечено в качестве ответа

      24 апреля 2012 г. 8:36

Источник
  • Remove From My Forums

  • Question

  • Good day,

    Last week, I started receiving this error inconjunction with an SSIS package which executes at a particular time.  Any help would be appreciated.  Here are the details

    Environment:  Virtualized Server
    Sql Version:  Microsoft SQL Server 2005 — 9.00.4053.00 (Intel X86)(Build 3790: Service Pack 2)

    SSIS Package:  Copies a file based database from server A to SQL Server for importing into SQL Server database.
    SSIS Executed:  Every two hours
    Other Components:  ACCDB which contains links to the file-based database, using Topspeed Drivers; SQL Server contains a linked object to the ACCDB.

    Symptoms:  Throughout the day, this process runs.  When it is executed at 6:00 pm, the server crashes.  I attempted to change the time that it runs in case some other process was causing resource to not be availble, and looked at the AV scan
    settings and schedule.  Nothing has helped.  This issue has been occurring for the past week.  I’m not sure how to interpret the information in the error log or what to try next.  Your input is appreciated. 

    The error log is below:

    2012-04-13 18:45:50.53 Server      Error: 17311, Severity: 16, State: 1.
    2012-04-13 18:45:50.53 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).

    2012-04-13 18:45:50.68 Server      Using ‘dbghelp.dll’ version ‘4.0.5’
    2012-04-13 18:45:50.72 Server      **Dump thread — spid = 0, PSS = 0x00000000, EC = 0x00000000
    2012-04-13 18:45:50.72 Server      ***Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0005.txt
    2012-04-13 18:45:50.72 Server      * *******************************************************************************
    2012-04-13 18:45:50.72 Server      *
    2012-04-13 18:45:50.72 Server      * BEGIN STACK DUMP:
    2012-04-13 18:45:50.72 Server      *   04/13/12 18:45:50 spid 0
    2012-04-13 18:45:50.72 Server      *
    2012-04-13 18:45:50.72 Server      * ex_handle_except encountered exception C0000005 — Server terminating
    2012-04-13 18:45:50.72 Server      *
    2012-04-13 18:45:50.72 Server      *
    2012-04-13 18:45:50.72 Server      *  MODULE                          BASE     
    END       SIZE
    2012-04-13 18:45:50.72 Server      * sqlservr                       01000000  02C1FFFF  01c20000
    2012-04-13 18:45:50.72 Server      * ntdll                          7C800000  7C8C2FFF  000c3000
    2012-04-13 18:45:50.72 Server      * kernel32                       77E40000  77F41FFF  00102000
    2012-04-13 18:45:50.72 Server      * MSVCR80                        78130000  781CAFFF  0009b000
    2012-04-13 18:45:50.72 Server      * msvcrt                         77BA0000  77BF9FFF  0005a000
    2012-04-13 18:45:50.72 Server      * MSVCP80                        7C420000  7C4A6FFF  00087000
    2012-04-13 18:45:50.72 Server      * ADVAPI32                       7D1E0000  7D27BFFF  0009c000
    2012-04-13 18:45:50.72 Server      * RPCRT4                         77C50000  77CEFFFF  000a0000
    2012-04-13 18:45:50.72 Server      * Secur32                        76F50000  76F62FFF  00013000
    2012-04-13 18:45:50.72 Server      * sqlos                          344D0000  344D4FFF  00005000
    2012-04-13 18:45:50.72 Server      * USERENV                        76920000  769E1FFF  000c2000
    2012-04-13 18:45:50.72 Server      * USER32                         77380000  77410FFF  00091000
    2012-04-13 18:45:50.72 Server      * GDI32                          77C00000  77C48FFF  00049000
    2012-04-13 18:45:50.72 Server      * WINMM                          76AA0000  76ACCFFF  0002d000
    2012-04-13 18:45:50.72 Server      * opends60                       333E0000  333E6FFF  00007000
    2012-04-13 18:45:50.72 Server      * NETAPI32                       71C40000  71C96FFF  00057000
    2012-04-13 18:45:50.72 Server      * psapi                          76B70000  76B7AFFF  0000b000
    2012-04-13 18:45:50.72 Server      * instapi                        48060000  48069FFF  0000a000
    2012-04-13 18:45:50.72 Server      * sqlevn70                       4F610000  4F7B8FFF  001a9000
    2012-04-13 18:45:50.72 Server      * NTMARTA                        77E00000  77E20FFF  00021000
    2012-04-13 18:45:50.72 Server      * WLDAP32                        76F10000  76F3DFFF  0002e000
    2012-04-13 18:45:50.72 Server      * SAMLIB                         7E020000  7E02EFFF  0000f000
    2012-04-13 18:45:50.73 Server      * ole32                          77670000  777A8FFF  00139000
    2012-04-13 18:45:50.73 Server      * rsaenh                         68000000  68034FFF  00035000
    2012-04-13 18:45:50.73 Server      * AUTHZ                          76C40000  76C53FFF  00014000
    2012-04-13 18:45:50.73 Server      * MSCOREE                        33DF0000  33E39FFF  0004a000
    2012-04-13 18:45:50.73 Server      * msv1_0                         76C90000  76CB6FFF  00027000
    2012-04-13 18:45:50.73 Server      * cryptdll                       34050000  3405BFFF  0000c000
    2012-04-13 18:45:50.73 Server      * WS2_32                         71C00000  71C16FFF  00017000
    2012-04-13 18:45:50.73 Server      * WS2HELP                        71BF0000  71BF7FFF  00008000
    2012-04-13 18:45:50.73 Server      * iphlpapi                       76CF0000  76D09FFF  0001a000
    2012-04-13 18:45:50.73 Server      * kerberos                       340B0000  34108FFF  00059000
    2012-04-13 18:45:50.73 Server      * MSASN1                         34110000  34121FFF  00012000
    2012-04-13 18:45:50.73 Server      * schannel                       34140000  34168FFF  00029000
    2012-04-13 18:45:50.73 Server      * CRYPT32                        34170000  34202FFF  00093000
    2012-04-13 18:45:50.73 Server      * COMRES                         77010000  770D5FFF  000c6000
    2012-04-13 18:45:50.73 Server      * XOLEHLP                        34250000  34255FFF  00006000
    2012-04-13 18:45:50.73 Server      * MSDTCPRX                       34260000  342D8FFF  00079000
    2012-04-13 18:45:50.73 Server      * OLEAUT32                       7D0E0000  7D16AFFF  0008b000
    2012-04-13 18:45:50.73 Server      * msvcp60                        342E0000  34344FFF  00065000
    2012-04-13 18:45:50.73 Server      * MTXCLU                         34350000  34368FFF  00019000
    2012-04-13 18:45:50.73 Server      * VERSION                        77B90000  77B97FFF  00008000
    2012-04-13 18:45:50.73 Server      * WSOCK32                        71BB0000  71BB8FFF  00009000
    2012-04-13 18:45:50.73 Server      * CLUSAPI                        34370000  34381FFF  00012000
    2012-04-13 18:45:50.73 Server      * RESUTILS                       34390000  343A2FFF  00013000
    2012-04-13 18:45:50.73 Server      * mswsock                        71B20000  71B60FFF  00041000
    2012-04-13 18:45:50.73 Server      * DNSAPI                         76ED0000  76EF9FFF  0002a000
    2012-04-13 18:45:50.73 Server      * winrnr                         76F70000  76F76FFF  00007000
    2012-04-13 18:45:50.73 Server      * rasadhlp                       76F80000  76F84FFF  00005000
    2012-04-13 18:45:50.73 Server      * security                       62740000  62743FFF  00004000
    2012-04-13 18:45:50.73 Server      * msfte                          62E10000  63068FFF  00259000
    2012-04-13 18:45:50.73 Server      * dbghelp                        63080000  63194FFF  00115000
    2012-04-13 18:45:50.73 Server      * WINTRUST                       76BB0000  76BDBFFF  0002c000
    2012-04-13 18:45:50.73 Server      * imagehlp                       76C10000  76C37FFF  00028000
    2012-04-13 18:45:50.73 Server      * dssenh                         68100000  68126FFF  00027000
    2012-04-13 18:45:50.73 Server      * hnetcfg                        63460000  634B9FFF  0005a000
    2012-04-13 18:45:50.73 Server      * wshtcpip                       71AE0000  71AE7FFF  00008000
    2012-04-13 18:45:50.73 Server      * ntdsapi                        63580000  63593FFF  00014000
    2012-04-13 18:45:50.73 Server      * xpsp2res                       635A0000  63864FFF  002c5000
    2012-04-13 18:45:50.73 Server      * CLBCatQ                        777B0000  77832FFF  00083000
    2012-04-13 18:45:50.73 Server      * sqlncli                        63870000  63A96FFF  00227000
    2012-04-13 18:45:50.73 Server      * COMCTL32                       77530000  775C6FFF  00097000
    2012-04-13 18:45:50.73 Server      * comdlg32                       00770000  007B8FFF  00049000
    2012-04-13 18:45:50.73 Server      * SHLWAPI                        7D180000  7D1D1FFF  00052000
    2012-04-13 18:45:50.73 Server      * SHELL32                        7C8D0000  7D0CEFFF  007ff000
    2012-04-13 18:45:50.73 Server      * comctl32                       77420000  77522FFF  00103000
    2012-04-13 18:45:50.73 Server      * SQLNCLIR                       63AD0000  63B02FFF  00033000
    2012-04-13 18:45:50.73 Server      * msftepxy                       63C90000  63CA4FFF  00015000
    2012-04-13 18:45:50.73 Server      * xpsqlbot                       64120000  64125FFF  00006000
    2012-04-13 18:45:50.73 Server      * xpstar90                       64140000  6418AFFF  0004b000
    2012-04-13 18:45:50.73 Server      * SQLSCM90                       641A0000  641A8FFF  00009000
    2012-04-13 18:45:50.73 Server      * ODBC32                         641E0000  6421DFFF  0003e000
    2012-04-13 18:45:50.73 Server      * BatchParser90                  64220000  6423EFFF  0001f000
    2012-04-13 18:45:50.73 Server      * ATL80                          7C630000  7C64AFFF  0001b000
    2012-04-13 18:45:50.73 Server      * odbcint                        64290000  642A6FFF  00017000
    2012-04-13 18:45:50.73 Server      * xpstar90                       64440000  64465FFF  00026000
    2012-04-13 18:45:50.73 Server      * xplog70                        64470000  6447BFFF  0000c000
    2012-04-13 18:45:50.73 Server      * xplog70                        64490000  64492FFF  00003000
    2012-04-13 18:45:50.73 Server      * oledb32                        64730000  647A8FFF  00079000
    2012-04-13 18:45:50.73 Server      * MSDART                         63C20000  63C39FFF  0001a000
    2012-04-13 18:45:50.73 Server      * OLEDB32R                       64AF0000  64B00FFF  00011000
    2012-04-13 18:45:50.73 Server      * comsvcs                        64B10000  64C54FFF  00145000
    2012-04-13 18:45:50.73 Server      * ACEOLEDB                       64C60000  64CBEFFF  0005f000
    2012-04-13 18:45:50.73 Server      * MSVCR90                        64CC0000  64D62FFF  000a3000
    2012-04-13 18:45:50.73 Server      * mso                            64D80000  65F5FFFF 
    011e0000
    2012-04-13 18:45:50.73 Server      * msi                            65F70000  6622DFFF 
    002be000
    2012-04-13 18:45:50.73 Server      * ACECORE                        663B0000  665C9FFF  0021a000
    2012-04-13 18:45:50.73 Server      * MSVCP90                        665E0000  6666DFFF  0008e000
    2012-04-13 18:45:50.73 Server      * ACEWSTR                        66AD0000  66BA1FFF  000d2000
    2012-04-13 18:45:50.73 Server      * MSORES                         68130000  6C659FFF  0452a000
    2012-04-13 18:45:50.73 Server      * MSOINTL                        66BD0000  66E31FFF  00262000
    2012-04-13 18:45:50.73 Server      * ACEES                          67370000  67419FFF  000aa000
    2012-04-13 18:45:50.73 Server      * VBAJET32                       67430000  6743DFFF  0000e000
    2012-04-13 18:45:50.73 Server      * expsrv                         67450000  674C0FFF  00071000
    2012-04-13 18:45:50.73 Server      * sqlvdi                         67030000  67051FFF  00022000
    2012-04-13 18:45:50.73 Server      * office                         70660000  70A6EFFF  0040f000
    2012-04-13 18:45:50.73 Server      * UxTheme                        71B70000  71BA5FFF  00036000
    2012-04-13 18:45:50.73 Server      * dbghelp                        70B70000  70C84FFF  00115000
    2012-04-13 18:45:50.73 Server      *
    2012-04-13 18:45:50.73 Server      *        Edi: 67FBE8E4:  001B7068  00000000  00000000  00000000  00000000  00000000 

    2012-04-13 18:45:50.73 Server      *        Esi: 00000000: 

    2012-04-13 18:45:50.73 Server      *        Eax: 67FBE7C8:  000042AC  00000000  00000000  77E4BEF7  00000000  00000002 

    2012-04-13 18:45:50.73 Server      *        Ebx: 0000003F: 

    2012-04-13 18:45:50.73 Server      *        Ecx: 67FBEE38:  00000000  00010007  00000000  0090008E  001B706C  00000000 

    2012-04-13 18:45:50.73 Server      *        Edx: 0000003D: 

    2012-04-13 18:45:50.73 Server      *        Eip: 77E4BEF7:  10C2C95E  01093D00  840FC000  00000095  F29DE950  9090FFFF 

    2012-04-13 18:45:50.73 Server      *        Ebp: 67FBE818:  67FBE85C  021AE24C  000042AC  00000000  00000000  00000000 

    2012-04-13 18:45:50.73 Server      *      SegCs: 7813001B:  00000000  00000000  00000000  00000000  00000000  00000000 

    2012-04-13 18:45:50.73 Server      *     EFlags: 00000246: 

    2012-04-13 18:45:50.73 Server      *        Esp: 67FBE7C4:  00000000  000042AC  00000000  00000000  77E4BEF7  00000000 

    2012-04-13 18:45:50.73 Server      *      SegSs: 78130023:  00000000  00000000  00000000  00000000  00000000  00000000 

    2012-04-13 18:45:50.74 Server      * *******************************************************************************
    2012-04-13 18:45:50.74 Server      * ——————————————————————————-
    2012-04-13 18:45:50.74 Server      * Short Stack Dump
    2012-04-13 18:45:50.75 Server      77E4BEF7 Module(kernel32+0000BEF7)
    2012-04-13 18:45:50.75 Server      021AE24C Module(sqlservr+011AE24C)
    2012-04-13 18:45:50.75 Server      021B2160 Module(sqlservr+011B2160)
    2012-04-13 18:45:50.75 Server      021B1D0D Module(sqlservr+011B1D0D)
    2012-04-13 18:45:50.75 Server      02422369 Module(sqlservr+01422369)
    2012-04-13 18:45:50.75 Server      77E761B7 Module(kernel32+000361B7)
    2012-04-13 18:45:50.75 Server      77E792A3 Module(kernel32+000392A3)
    2012-04-13 18:45:50.77 Server      Stack Signature for the dump is 0x1A38D65C
    2012-04-13 18:45:53.94 Server      External dump process return code 0x20000001.
    External dump process returned no errors.

    Thank you.

Answers

  • Hi GFrank,

    A similar error is reported in
    this KB article, with the fix initially released in Cumulative Update 9 for SQL Server 2005 Service Pack 3. I would recommend you apply the latest Service Pack via
    SQL Server 2005 to avoid known issues.

    Stephanie Lv

    TechNet Community Support

    • Marked as answer by

      Tuesday, April 24, 2012 8:36 AM

Источник
  • Remove From My Forums

  • Question

  • Good day,

    Last week, I started receiving this error inconjunction with an SSIS package which executes at a particular time.  Any help would be appreciated.  Here are the details

    Environment:  Virtualized Server
    Sql Version:  Microsoft SQL Server 2005 — 9.00.4053.00 (Intel X86)(Build 3790: Service Pack 2)

    SSIS Package:  Copies a file based database from server A to SQL Server for importing into SQL Server database.
    SSIS Executed:  Every two hours
    Other Components:  ACCDB which contains links to the file-based database, using Topspeed Drivers; SQL Server contains a linked object to the ACCDB.

    Symptoms:  Throughout the day, this process runs.  When it is executed at 6:00 pm, the server crashes.  I attempted to change the time that it runs in case some other process was causing resource to not be availble, and looked at the AV scan
    settings and schedule.  Nothing has helped.  This issue has been occurring for the past week.  I’m not sure how to interpret the information in the error log or what to try next.  Your input is appreciated. 

    The error log is below:

    2012-04-13 18:45:50.53 Server      Error: 17311, Severity: 16, State: 1.
    2012-04-13 18:45:50.53 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).

    2012-04-13 18:45:50.68 Server      Using ‘dbghelp.dll’ version ‘4.0.5’
    2012-04-13 18:45:50.72 Server      **Dump thread — spid = 0, PSS = 0x00000000, EC = 0x00000000
    2012-04-13 18:45:50.72 Server      ***Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0005.txt
    2012-04-13 18:45:50.72 Server      * *******************************************************************************
    2012-04-13 18:45:50.72 Server      *
    2012-04-13 18:45:50.72 Server      * BEGIN STACK DUMP:
    2012-04-13 18:45:50.72 Server      *   04/13/12 18:45:50 spid 0
    2012-04-13 18:45:50.72 Server      *
    2012-04-13 18:45:50.72 Server      * ex_handle_except encountered exception C0000005 — Server terminating
    2012-04-13 18:45:50.72 Server      *
    2012-04-13 18:45:50.72 Server      *
    2012-04-13 18:45:50.72 Server      *  MODULE                          BASE     
    END       SIZE
    2012-04-13 18:45:50.72 Server      * sqlservr                       01000000  02C1FFFF  01c20000
    2012-04-13 18:45:50.72 Server      * ntdll                          7C800000  7C8C2FFF  000c3000
    2012-04-13 18:45:50.72 Server      * kernel32                       77E40000  77F41FFF  00102000
    2012-04-13 18:45:50.72 Server      * MSVCR80                        78130000  781CAFFF  0009b000
    2012-04-13 18:45:50.72 Server      * msvcrt                         77BA0000  77BF9FFF  0005a000
    2012-04-13 18:45:50.72 Server      * MSVCP80                        7C420000  7C4A6FFF  00087000
    2012-04-13 18:45:50.72 Server      * ADVAPI32                       7D1E0000  7D27BFFF  0009c000
    2012-04-13 18:45:50.72 Server      * RPCRT4                         77C50000  77CEFFFF  000a0000
    2012-04-13 18:45:50.72 Server      * Secur32                        76F50000  76F62FFF  00013000
    2012-04-13 18:45:50.72 Server      * sqlos                          344D0000  344D4FFF  00005000
    2012-04-13 18:45:50.72 Server      * USERENV                        76920000  769E1FFF  000c2000
    2012-04-13 18:45:50.72 Server      * USER32                         77380000  77410FFF  00091000
    2012-04-13 18:45:50.72 Server      * GDI32                          77C00000  77C48FFF  00049000
    2012-04-13 18:45:50.72 Server      * WINMM                          76AA0000  76ACCFFF  0002d000
    2012-04-13 18:45:50.72 Server      * opends60                       333E0000  333E6FFF  00007000
    2012-04-13 18:45:50.72 Server      * NETAPI32                       71C40000  71C96FFF  00057000
    2012-04-13 18:45:50.72 Server      * psapi                          76B70000  76B7AFFF  0000b000
    2012-04-13 18:45:50.72 Server      * instapi                        48060000  48069FFF  0000a000
    2012-04-13 18:45:50.72 Server      * sqlevn70                       4F610000  4F7B8FFF  001a9000
    2012-04-13 18:45:50.72 Server      * NTMARTA                        77E00000  77E20FFF  00021000
    2012-04-13 18:45:50.72 Server      * WLDAP32                        76F10000  76F3DFFF  0002e000
    2012-04-13 18:45:50.72 Server      * SAMLIB                         7E020000  7E02EFFF  0000f000
    2012-04-13 18:45:50.73 Server      * ole32                          77670000  777A8FFF  00139000
    2012-04-13 18:45:50.73 Server      * rsaenh                         68000000  68034FFF  00035000
    2012-04-13 18:45:50.73 Server      * AUTHZ                          76C40000  76C53FFF  00014000
    2012-04-13 18:45:50.73 Server      * MSCOREE                        33DF0000  33E39FFF  0004a000
    2012-04-13 18:45:50.73 Server      * msv1_0                         76C90000  76CB6FFF  00027000
    2012-04-13 18:45:50.73 Server      * cryptdll                       34050000  3405BFFF  0000c000
    2012-04-13 18:45:50.73 Server      * WS2_32                         71C00000  71C16FFF  00017000
    2012-04-13 18:45:50.73 Server      * WS2HELP                        71BF0000  71BF7FFF  00008000
    2012-04-13 18:45:50.73 Server      * iphlpapi                       76CF0000  76D09FFF  0001a000
    2012-04-13 18:45:50.73 Server      * kerberos                       340B0000  34108FFF  00059000
    2012-04-13 18:45:50.73 Server      * MSASN1                         34110000  34121FFF  00012000
    2012-04-13 18:45:50.73 Server      * schannel                       34140000  34168FFF  00029000
    2012-04-13 18:45:50.73 Server      * CRYPT32                        34170000  34202FFF  00093000
    2012-04-13 18:45:50.73 Server      * COMRES                         77010000  770D5FFF  000c6000
    2012-04-13 18:45:50.73 Server      * XOLEHLP                        34250000  34255FFF  00006000
    2012-04-13 18:45:50.73 Server      * MSDTCPRX                       34260000  342D8FFF  00079000
    2012-04-13 18:45:50.73 Server      * OLEAUT32                       7D0E0000  7D16AFFF  0008b000
    2012-04-13 18:45:50.73 Server      * msvcp60                        342E0000  34344FFF  00065000
    2012-04-13 18:45:50.73 Server      * MTXCLU                         34350000  34368FFF  00019000
    2012-04-13 18:45:50.73 Server      * VERSION                        77B90000  77B97FFF  00008000
    2012-04-13 18:45:50.73 Server      * WSOCK32                        71BB0000  71BB8FFF  00009000
    2012-04-13 18:45:50.73 Server      * CLUSAPI                        34370000  34381FFF  00012000
    2012-04-13 18:45:50.73 Server      * RESUTILS                       34390000  343A2FFF  00013000
    2012-04-13 18:45:50.73 Server      * mswsock                        71B20000  71B60FFF  00041000
    2012-04-13 18:45:50.73 Server      * DNSAPI                         76ED0000  76EF9FFF  0002a000
    2012-04-13 18:45:50.73 Server      * winrnr                         76F70000  76F76FFF  00007000
    2012-04-13 18:45:50.73 Server      * rasadhlp                       76F80000  76F84FFF  00005000
    2012-04-13 18:45:50.73 Server      * security                       62740000  62743FFF  00004000
    2012-04-13 18:45:50.73 Server      * msfte                          62E10000  63068FFF  00259000
    2012-04-13 18:45:50.73 Server      * dbghelp                        63080000  63194FFF  00115000
    2012-04-13 18:45:50.73 Server      * WINTRUST                       76BB0000  76BDBFFF  0002c000
    2012-04-13 18:45:50.73 Server      * imagehlp                       76C10000  76C37FFF  00028000
    2012-04-13 18:45:50.73 Server      * dssenh                         68100000  68126FFF  00027000
    2012-04-13 18:45:50.73 Server      * hnetcfg                        63460000  634B9FFF  0005a000
    2012-04-13 18:45:50.73 Server      * wshtcpip                       71AE0000  71AE7FFF  00008000
    2012-04-13 18:45:50.73 Server      * ntdsapi                        63580000  63593FFF  00014000
    2012-04-13 18:45:50.73 Server      * xpsp2res                       635A0000  63864FFF  002c5000
    2012-04-13 18:45:50.73 Server      * CLBCatQ                        777B0000  77832FFF  00083000
    2012-04-13 18:45:50.73 Server      * sqlncli                        63870000  63A96FFF  00227000
    2012-04-13 18:45:50.73 Server      * COMCTL32                       77530000  775C6FFF  00097000
    2012-04-13 18:45:50.73 Server      * comdlg32                       00770000  007B8FFF  00049000
    2012-04-13 18:45:50.73 Server      * SHLWAPI                        7D180000  7D1D1FFF  00052000
    2012-04-13 18:45:50.73 Server      * SHELL32                        7C8D0000  7D0CEFFF  007ff000
    2012-04-13 18:45:50.73 Server      * comctl32                       77420000  77522FFF  00103000
    2012-04-13 18:45:50.73 Server      * SQLNCLIR                       63AD0000  63B02FFF  00033000
    2012-04-13 18:45:50.73 Server      * msftepxy                       63C90000  63CA4FFF  00015000
    2012-04-13 18:45:50.73 Server      * xpsqlbot                       64120000  64125FFF  00006000
    2012-04-13 18:45:50.73 Server      * xpstar90                       64140000  6418AFFF  0004b000
    2012-04-13 18:45:50.73 Server      * SQLSCM90                       641A0000  641A8FFF  00009000
    2012-04-13 18:45:50.73 Server      * ODBC32                         641E0000  6421DFFF  0003e000
    2012-04-13 18:45:50.73 Server      * BatchParser90                  64220000  6423EFFF  0001f000
    2012-04-13 18:45:50.73 Server      * ATL80                          7C630000  7C64AFFF  0001b000
    2012-04-13 18:45:50.73 Server      * odbcint                        64290000  642A6FFF  00017000
    2012-04-13 18:45:50.73 Server      * xpstar90                       64440000  64465FFF  00026000
    2012-04-13 18:45:50.73 Server      * xplog70                        64470000  6447BFFF  0000c000
    2012-04-13 18:45:50.73 Server      * xplog70                        64490000  64492FFF  00003000
    2012-04-13 18:45:50.73 Server      * oledb32                        64730000  647A8FFF  00079000
    2012-04-13 18:45:50.73 Server      * MSDART                         63C20000  63C39FFF  0001a000
    2012-04-13 18:45:50.73 Server      * OLEDB32R                       64AF0000  64B00FFF  00011000
    2012-04-13 18:45:50.73 Server      * comsvcs                        64B10000  64C54FFF  00145000
    2012-04-13 18:45:50.73 Server      * ACEOLEDB                       64C60000  64CBEFFF  0005f000
    2012-04-13 18:45:50.73 Server      * MSVCR90                        64CC0000  64D62FFF  000a3000
    2012-04-13 18:45:50.73 Server      * mso                            64D80000  65F5FFFF 
    011e0000
    2012-04-13 18:45:50.73 Server      * msi                            65F70000  6622DFFF 
    002be000
    2012-04-13 18:45:50.73 Server      * ACECORE                        663B0000  665C9FFF  0021a000
    2012-04-13 18:45:50.73 Server      * MSVCP90                        665E0000  6666DFFF  0008e000
    2012-04-13 18:45:50.73 Server      * ACEWSTR                        66AD0000  66BA1FFF  000d2000
    2012-04-13 18:45:50.73 Server      * MSORES                         68130000  6C659FFF  0452a000
    2012-04-13 18:45:50.73 Server      * MSOINTL                        66BD0000  66E31FFF  00262000
    2012-04-13 18:45:50.73 Server      * ACEES                          67370000  67419FFF  000aa000
    2012-04-13 18:45:50.73 Server      * VBAJET32                       67430000  6743DFFF  0000e000
    2012-04-13 18:45:50.73 Server      * expsrv                         67450000  674C0FFF  00071000
    2012-04-13 18:45:50.73 Server      * sqlvdi                         67030000  67051FFF  00022000
    2012-04-13 18:45:50.73 Server      * office                         70660000  70A6EFFF  0040f000
    2012-04-13 18:45:50.73 Server      * UxTheme                        71B70000  71BA5FFF  00036000
    2012-04-13 18:45:50.73 Server      * dbghelp                        70B70000  70C84FFF  00115000
    2012-04-13 18:45:50.73 Server      *
    2012-04-13 18:45:50.73 Server      *        Edi: 67FBE8E4:  001B7068  00000000  00000000  00000000  00000000  00000000 

    2012-04-13 18:45:50.73 Server      *        Esi: 00000000: 

    2012-04-13 18:45:50.73 Server      *        Eax: 67FBE7C8:  000042AC  00000000  00000000  77E4BEF7  00000000  00000002 

    2012-04-13 18:45:50.73 Server      *        Ebx: 0000003F: 

    2012-04-13 18:45:50.73 Server      *        Ecx: 67FBEE38:  00000000  00010007  00000000  0090008E  001B706C  00000000 

    2012-04-13 18:45:50.73 Server      *        Edx: 0000003D: 

    2012-04-13 18:45:50.73 Server      *        Eip: 77E4BEF7:  10C2C95E  01093D00  840FC000  00000095  F29DE950  9090FFFF 

    2012-04-13 18:45:50.73 Server      *        Ebp: 67FBE818:  67FBE85C  021AE24C  000042AC  00000000  00000000  00000000 

    2012-04-13 18:45:50.73 Server      *      SegCs: 7813001B:  00000000  00000000  00000000  00000000  00000000  00000000 

    2012-04-13 18:45:50.73 Server      *     EFlags: 00000246: 

    2012-04-13 18:45:50.73 Server      *        Esp: 67FBE7C4:  00000000  000042AC  00000000  00000000  77E4BEF7  00000000 

    2012-04-13 18:45:50.73 Server      *      SegSs: 78130023:  00000000  00000000  00000000  00000000  00000000  00000000 

    2012-04-13 18:45:50.74 Server      * *******************************************************************************
    2012-04-13 18:45:50.74 Server      * ——————————————————————————-
    2012-04-13 18:45:50.74 Server      * Short Stack Dump
    2012-04-13 18:45:50.75 Server      77E4BEF7 Module(kernel32+0000BEF7)
    2012-04-13 18:45:50.75 Server      021AE24C Module(sqlservr+011AE24C)
    2012-04-13 18:45:50.75 Server      021B2160 Module(sqlservr+011B2160)
    2012-04-13 18:45:50.75 Server      021B1D0D Module(sqlservr+011B1D0D)
    2012-04-13 18:45:50.75 Server      02422369 Module(sqlservr+01422369)
    2012-04-13 18:45:50.75 Server      77E761B7 Module(kernel32+000361B7)
    2012-04-13 18:45:50.75 Server      77E792A3 Module(kernel32+000392A3)
    2012-04-13 18:45:50.77 Server      Stack Signature for the dump is 0x1A38D65C
    2012-04-13 18:45:53.94 Server      External dump process return code 0x20000001.
    External dump process returned no errors.

    Thank you.

Answers

  • Hi GFrank,

    A similar error is reported in
    this KB article, with the fix initially released in Cumulative Update 9 for SQL Server 2005 Service Pack 3. I would recommend you apply the latest Service Pack via
    SQL Server 2005 to avoid known issues.

    Stephanie Lv

    TechNet Community Support

    • Marked as answer by

      Tuesday, April 24, 2012 8:36 AM

Источник
  • Remove From My Forums

  • Question

  • Problem Description:

    SQL Server is terminating abruptly

    Environment Details:

    Windows Server 2008 R2 with Service Pack-1

    SQL Server 2008 R2
    with Service Pack-1

    Its a Active/Passive Cluster

    Error Message is :

    Error: 17311, Severity: 16, State: 1.
    2013-07-19 18:12:44.65 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).

Источник
  • Remove From My Forums

  • Question

  • Problem Description:

    SQL Server is terminating abruptly

    Environment Details:

    Windows Server 2008 R2 with Service Pack-1

    SQL Server 2008 R2
    with Service Pack-1

    Its a Active/Passive Cluster

    Error Message is :

    Error: 17311, Severity: 16, State: 1.
    2013-07-19 18:12:44.65 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).

Источник
  • Remove From My Forums

  • Question

  • Problem Description:

    SQL Server is terminating abruptly

    Environment Details:

    Windows Server 2008 R2 with Service Pack-1

    SQL Server 2008 R2
    with Service Pack-1

    Its a Active/Passive Cluster

    Error Message is :

    Error: 17311, Severity: 16, State: 1.
    2013-07-19 18:12:44.65 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).

Источник

January 22 2018, 17:12

Жила-была мумия одного SQL Server 2014(12.0.5557.0). Бежала мимо уборщица, шваброй махнула сервер упал и как давай по-полу валяться.

Проблема
После аппаратного сбоя старует и падает служба MS SQL Server.

Диагностика
В журналах сервера странное: CHECKDB прошел без ошибок для всех баз, но служба стартовать не хочет.

«000-00-00 00:00:00.00 spid8s      Recovery is complete. This is an informational message only. No user action is required.

2000-00-00 00:00:00.00 Server      SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.

2000-00-00 00:00:00.00 spid37s     Service Broker manager has shut down.

2000-00-00 00:00:00.00 spid8s      .NET Framework runtime has been stopped.

2000-00-00 00:00:00.00 spid8s      SQL Server shutdown has been initiated

2000-00-00 00:00:00.00 spid8s      SQL Trace was stopped due to server shutdown. Trace ID = ‘1’. This is an informational message only; no user action is required.

2000-00-00 00:00:00.00 spid8s      Error: 17054, Severity: 16, State: 1.

2000-00-00 00:00:00.00 spid8s      The current event was not reported to the Windows Events log. Operating system error = (null). You may need to clear the Windows Events log if it is full»

В жуналах ОС видим Event 17311, источник MSSQLSERVER:
«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).»

Решение
Микрософт ничего интересного не предлагает: проверьте базу (это на мертвом сервере) или обратитесь в поддержку.

На самом деле всё оказалось просто: вовремя сбоя была повреждена одна из баз и при попытке её смонтировать MSSQL впадал в истерику (вспоминаем CHECKDB). Пострадавшая база была вычисленна с помощью последовательного блокирования доступа к файлам баз данных (прекратить доступ учетки сервера к файлам БД или, банально, их переименовать).

PS Как всегда, поврежденна оказалась мелкая и уже никому не нужная базуля.

Источник

SQL Server 2012 Developer SQL Server 2012 Enterprise SQL Server 2012 Standard Еще…Меньше

Проблемы

Предположим, что у вас есть база данных с параметрами сортировки с учетом регистра в Microsoft SQL Server 2012 с пакетом обновления 2 (SP2). При попытке резервного копирования баз данных служб AlwaysOn с помощью службы теневого копирования томов (VSS) в журнале приложений Windows могут появиться следующие сообщения: (источник VSS).

Source: VSSEventID: 8229EventType: 2DateTime: 9-7-2014 14:22:46.000 timestamp: 0x01cf9b707d6d6f00Description: служба записи VSS отклонила событие с ошибкой 0x800423f4, в средстве записи возникла ошибка, не подходящая для чтения.  Если попытаться выполнить резервное копирование повторно, это может привести к возникновению ошибки. Изменения, которые средство записи сделало компонентам записи при обработке события, будет недоступно для инициатора запроса. Проверьте журнал событий на наличие связанных событий из приложения, на котором размещается модуль записи VSS.

(От SQLVDI)

SQLVDI: loc = SignalAbort. Desc = клиент инициирует прерывание. ErrorCode=(0). Process=1584. Thread=7244. Клиентами. Instance=. VD=Global{6483442C-256E-4F85-85C4-E5A611ED9A88}1_SQLVDIMemoryName_0.…SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=1940. Thread=1824. Server. Instance=MSSQLSERVER. VD=Global{6483442C-256E-4F85-85C4-E5A611ED9A88}1_SQLVDIMemoryName_0.

В журнале ошибок SQL Server также появляются следующие сообщения:

<Date> <Time> Ошибка резервного копирования: 3041, уровень серьезности: 16, состояние: 1. <Date> <Time> Архивация резервной копии не удалось завершить модель базы данных команд резервного копирования. Просмотрите журнал приложения резервного копирования для получения подробных сообщений. <дата> <время> SPID<идентификатор> ошибка: 18210, уровень серьезности: 16, состояние: 1. <дата> <время> SPID<ID> BackupVirtualDeviceFile::P reparetofreeze: сбой на устройстве резервного копирования «{4E35DA4A-BAF7-4EC2-8421-EA7A3C0B7B31} 1». Ошибка операционной системы 995 (операция ввода-вывода прервана из-за выхода из потока или запроса приложения).

Кроме того, если при выполнении резервного копирования VSS вы выполняете трассировку профилировщика, то при выполнении следующего запроса:

SELECT 1 FROM SYS.AVAILABILITY_REPLICAS AS AR INNER JOIN SYS.DATABASES AS D ON DB_ID(N'TargetDatabase') = D.DATABASE_ID AND AR.REPLICA_ID = D.REPLICA_ID INNER JOIN SYS.DM_HADR_AVAILABILITY_REPLICA_STATES ST ON AR.REPLICA_ID = ST.REPLICA_ID AND ST.ROLE = 2

Происходит сбой, и появляется следующее сообщение об ошибке:

Ошибка: 208, Severity: 16, состояние: 1Invalid имя объекта «SYS. AVAILABILITY_REPLICAS «.

Решение

Эта проблема впервые устранена в следующем накопительном обновлении SQL Server.

Накопительное обновление 2 для SQL Server 2012 SP2 /en-us/help/2983175

Заметки к этому обновлениюЕсли вы установили это обновление для одной из локализованных версий SQL Server, например для японской версии SQL Server, необходимо выполнить следующие дополнительные действия, чтобы установить обновление модуля записи VSS SQL Server.

  • Запустите SQLServer2012-KB2983175-x64. exe, чтобы установить накопительное обновление 2 для SQL Server 2012 SP2.

  • Извлеките пакет, выполнив следующую командную строку: SQLServer2012-KB2983175-x64. exe/X:<целевую папку>

  • Подготовьте исходный установочный носитель.

  • Выполните следующую команду, чтобы применить обновление для модуля записи VSS SQL Server: msiexec/i <путь к SQLWriter. msi на исходном носителе установочного файла> /l * v<файл журнала с именем> Patch =<SQLWriter. msp в папке, созданной на этапе 1>например: msiexec/i «d: 1041_JPN_LP X64SETUPX64SQLWRITER.msi»/l * v C:Tempsqlwriter.log Patch = «c:sql2012sp2cu2 1033_enu_lp x64setupx64sqlwriter.MSP»

Статус

Корпорация Майкрософт подтверждает наличие этой проблемы в своих продуктах, которые перечислены в разделе «Применяется к».

Нужна дополнительная помощь?

Источник

SQL Server 2014 SP3 CU4 service terminates suddenly with the errors id 17310 and 17311.
The dump errors file show following stack:

Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQL12.SQLEXPRESSMSSQLLOGSQLDump0067.txt
SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.



BEGIN STACK DUMP:
   01/25/21 19:09:36 spid 57


   Exception Address = 00000000D4AF1840 Module(UNKNOWN+0000000000000000)
   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
   Access Violation occurred writing address 00000000D4AF1840
 Input Buffer 510 bytes -
             INSERT INTO IntestazioneDoc (Id,TipoDoc,NumDoc,Agente,CodCli,
  DataDoc,DataEvasione,Acconto,Note,Sc1,Sc2,Sc3,DocAgg,Stato,DetailsCount,
  Anagrafe_Id,CreatedAt,UpdatedAt,Deleted) SELECT Id,TipoDoc,NumDoc,Agente
  ,CodCli,DataDoc,DataEvasione,Acconto,Note,Sc1,Sc2,Sc3,DocAgg,Stato,Detai
  lsCount,Anagrafe_Id,CreatedAt,UpdatedAt,Deleted FROM OPENDATASOURCE('SQL
  NCLI', 'Server=***').myDb.dbo.IntestazioneDoc WHERE CreatedAt > '25/01/2021 11:39:37 +00:00'

Also, here there is another error:

2021-02-28 22:50:26.86 spid58      Errore: 17311, gravità: 16, stato: 1.
2021-02-28 22:50:26.86 spid58      SQL Server is terminating because of fatal exception 80000003. 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).
2021-02-28 22:50:26.89 spid58      **Dump thread - spid = 0, EC = 0x0000000038AD0D90
2021-02-28 22:50:26.91 spid58      ***Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQL12.SQLEXPRESSMSSQLLOGSQLDump0094.txt
2021-02-28 22:50:26.91 spid58      * *******************************************************************************
2021-02-28 22:50:26.91 spid58      *
2021-02-28 22:50:26.91 spid58      * BEGIN STACK DUMP:
2021-02-28 22:50:26.91 spid58      *   02/28/21 22:50:26 spid 58
2021-02-28 22:50:26.91 spid58      *
2021-02-28 22:50:26.91 spid58      * ex_handle_except encountered exception 80000003 - Server terminating
2021-02-28 22:50:26.91 spid58      *
2021-02-28 22:50:26.91 spid58      * Input Buffer 510 bytes -
2021-02-28 22:50:26.91 spid58      *             INSERT INTO Anagrafe (Id,CodCli,Descrizione,PartitaIva,Indiri
2021-02-28 22:50:26.91 spid58      *  zzo,CAP,Localita,Prov,CodAli,Listino,Sconti,Note,Fido,FidoMax,Esposizion
2021-02-28 22:50:26.91 spid58      *  eMax,Esposizione,MaxOrdinabile,CreatedAt,UpdatedAt,Deleted,Aliquote_Id,B
2021-02-28 22:50:26.91 spid58      *  loccato,Nuovo,Soggetto,Nome,Cognome,Sesso,Telefono,Cellulare,CodiceFisca
2021-02-28 22:50:26.91 spid58      *  le,CodiceDestinatario,Privacy,CondizioniVendita) SELECT Id,CodCli,Descri
2021-02-28 22:50:26.91 spid58      *  zione,PartitaIva,Indirizzo,CAP,Localita,Prov,CodAli,Listino,Sconti,Note,
2021-02-28 22:50:26.91 spid58      *  Fido,FidoMax,EsposizioneMax,Esposizione,MaxOrdinabile,CreatedAt,UpdatedA
2021-02-28 22:50:26.91 spid58      *  t,Deleted,Aliquote_Id,Bloccato,Nuovo,Soggetto,Nome,Cognome,Sesso,Telefon
2021-02-28 22:50:26.91 spid58      *  o,Cellulare,CodiceFiscale,CodiceDestinatario,Privacy,CondizioniVendita F
2021-02-28 22:50:26.91 spid58      *  ROM OPENDATASOURCE('SQLNCLI', 'Server=***').myDb.dbo.An
2021-02-28 22:50:26.91 spid58      *  agrafe WHERE CreatedAt > '25/02/2021 15:18:33 +00:00'

Is there something that I should do in my program to fix this issues?

Источник

I’m running SQL Server 2005 on my Windows 2008 server. I did a very bare install with basically just the DB Engine. It was running just fine, but I restarted the machine and now MSSQLSERVER service does not start. I check the Windows Event Log and it says the following:

SQL Server is terminating because of fatal exception 80000003. 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).

Attached is the ERRORLOG file from SQL’s log directory.

ERRORLOG.txt

Microsoft SQL Server 2005

I started with Experts Exchange in 2004 and it’s been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst

Not exactly the question you had in mind?

Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.

ask a question

Источник

0 0 голоса
Рейтинг статьи
Подписаться
Уведомить о
guest

0 комментариев
Старые
Новые Популярные
Межтекстовые Отзывы
Посмотреть все комментарии

А вот еще интересные материалы:

  • Яшка сломя голову остановился исправьте ошибки
  • Ясность цели позволяет целеустремленно добиваться намеченного исправьте ошибки
  • Ясность цели позволяет целеустремленно добиваться намеченного где ошибка
  • Ошибка 1731 при установке офиса
  • Ошибка 1731 при установке microsoft office 2007

    • ➤