SQL Server is terminating because of fatal exception c0000005.
-
Sunday, April 29, 2012 1:51 PM
Good Morning,
I have noticed a weird behaviour in our SQL server. SQL server stopped responding with below errors in log files and everything started working fine after re starting the SQL service. First time I have noticed this behaviour. I have found several hits on the internet with possible reasons for this issue, one is due to bad code and other is due to bad hardware. Please advise how I can troubleshoot this issue further.
SQL version: sql server 2005 ,9.00.4053.00, SP3
Windows Version: Windows server 2003 R2 ,Ent SP2
From text file:
=====================================================================
BugCheck Dump
=====================================================================
This file is generated by Microsoft SQL Server
version 9.00.4053.00
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.
Computer type is AT/AT COMPATIBLE.
Bios Version is DELL - 1
Phoenix ROM BIOS PLUS Version 1.10 A02
Current time is 09:26:18 04/28/12.
8 Intel x86 level 15, 2992 Mhz processor (s).
Windows NT 5.2 Build 3790 CSD Service Pack 2.
Memory
MemoryLoad = 97%
Total Physical = 8187 MB
Available Physical = 198 MB
Total Page File = 19883 MB
Available Page File = 12120 MB
Total Virtual = 2047 MB
Available Virtual = 47 MB
***Symbol load failed - Proceed to dump without any symbols
***Stack Dump being sent to e:\MSSQL\LOG\SQLDump0156.txt
SqlDumpExceptionHandler: Process 2140 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server i
s terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 04/28/12 09:26:18 spid 0
*
*
* Exception Address = 7C82BC38 Module(UNKNOWN+00000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 3D7743FD
*
* MODULE BASE END SIZE
*
* Edi: 0000000F:
* Esi: 3D7743F8:
* Eax: 000D01F0: AA00E5AD 3D774400 00000000 00000000 C8B522BB 11CE5CF3
* Ebx: 000D0000: 000000C8 0000014D EEFFEEFF 00000002 00000000 0000FE00
* Ecx: 7FFA8000: 02D1BEF8 02D20000 02D0D000 00000000 00001E00 00000000
* Edx: 000D0608: 7C889C80 FFFFFFFE 00000001 0000085C 00000A6C 00000FA0
* Eip: 7C82BC38: 8805468A 4E8DE345 89398B08 FFFE4CBD 0C568BFF FF7C9589
* Ebp: 02D1F8DC: 02D1F908 71AE24BA 000D0000 00000000 0000006C 02D1FB40
* SegCs: 0000001B:
* EFlags: 00010212: 005F0046 00520050 0043004F 00530045 004F0053 00530052
* Esp: 02D1F6C0: 02D1FAE4 02D1FA38 00000000 71B21E29 02D1F714 71AE3EAA
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
7C82BC38 Module(UNKNOWN+00000000)
71AE24BA Module(UNKNOWN+00000000)
71B24BD9 Module(UNKNOWN+00000000)
71B24711 Module(UNKNOWN+00000000)
71B24608 Module(UNKNOWN+00000000)
71C03FD5 Module(UNKNOWN+00000000)
71C0416E Module(UNKNOWN+00000000)
0119A237 Module(UNKNOWN+00000000)
0119A3EB Module(UNKNOWN+00000000)
011777D2 Module(UNKNOWN+00000000)
0119A012 Module(UNKNOWN+00000000)
0103CDAA Module(UNKNOWN+00000000)
01006E27 Module(UNKNOWN+00000000)
01006F4D Module(UNKNOWN+00000000)
01006C5D Module(UNKNOWN+00000000)
010AAC3C Module(UNKNOWN+00000000)
010AAB5C Module(UNKNOWN+00000000)
010AA60C Module(UNKNOWN+00000000)
010AA7A9 Module(UNKNOWN+00000000)
781329BB Module(UNKNOWN+00000000)
78132A47 Module(UNKNOWN+00000000)From Log file:
2012-04-28 09:25:52.46 Logon Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: 10.199.3.76]
2012-04-28 09:25:52.68 Logon Error: 18456, Severity: 14, State: 11.
2012-04-28 09:25:52.68 Logon Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: 10.199.3.76]
2012-04-28 09:26:18.35 Server CImageHelper::Init () Version-specific dbghelp.dll is not used
2012-04-28 09:26:18.37 Server CImageHelper::Init () Failed load of dbghelp.dll - A dynamic link library (DLL) initialization routine failed.2012-04-28 09:26:18.39 Server CImageHelper::Init () Version-specific dbghelp.dll is not used
2012-04-28 09:26:18.40 Server CImageHelper::Init () Failed load of dbghelp.dll - A dynamic link library (DLL) initialization routine failed.2012-04-28 09:26:18.40 Server ***Symbol load failed - Proceed to dump without any symbols
2012-04-28 09:26:18.40 Server ***Stack Dump being sent to e:\MSSQL\LOG\SQLDump0156.txt
2012-04-28 09:26:18.41 Server SqlDumpExceptionHandler: Process 2140 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2012-04-28 09:26:18.41 Server * *******************************************************************************
2012-04-28 09:26:18.41 Server *
2012-04-28 09:26:18.41 Server * BEGIN STACK DUMP:
2012-04-28 09:26:18.41 Server * 04/28/12 09:26:18 spid 0
2012-04-28 09:26:18.41 Server *
2012-04-28 09:26:18.41 Server *
2012-04-28 09:26:18.41 Server * Exception Address = 7C82BC38 Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2012-04-28 09:26:18.41 Server * Access Violation occurred reading address 3D7743FD
2012-04-28 09:26:18.41 Server *
2012-04-28 09:26:18.41 Server * MODULE BASE END SIZE
2012-04-28 09:26:18.41 Server *
2012-04-28 09:26:18.41 Server * Edi: 0000000F:
2012-04-28 09:26:18.41 Server * Esi: 3D7743F8:
2012-04-28 09:26:18.41 Server * Eax: 000D01F0: AA00E5AD 3D774400 00000000 00000000 C8B522BB 11CE5CF3
2012-04-28 09:26:18.41 Server * Ebx: 000D0000: 000000C8 0000014D EEFFEEFF 00000002 00000000 0000FE00
2012-04-28 09:26:18.41 Server * Ecx: 7FFA8000: 02D1BEF8 02D20000 02D0D000 00000000 00001E00 00000000
2012-04-28 09:26:18.41 Server * Edx: 000D0608: 7C889C80 FFFFFFFE 00000001 0000085C 00000A6C 00000FA0
2012-04-28 09:26:18.41 Server * Eip: 7C82BC38: 8805468A 4E8DE345 89398B08 FFFE4CBD 0C568BFF FF7C9589
2012-04-28 09:26:18.41 Server * Ebp: 02D1F8DC: 02D1F908 71AE24BA 000D0000 00000000 0000006C 02D1FB40
2012-04-28 09:26:18.41 Server * SegCs: 0000001B:
2012-04-28 09:26:18.41 Server * EFlags: 00010212: 005F0046 00520050 0043004F 00530045 004F0053 00530052
2012-04-28 09:26:18.41 Server * Esp: 02D1F6C0: 02D1FAE4 02D1FA38 00000000 71B21E29 02D1F714 71AE3EAA
2012-04-28 09:26:18.41 Server * SegSs: 00000023:
2012-04-28 09:26:18.41 Server * *******************************************************************************
2012-04-28 09:26:18.41 Server * -------------------------------------------------------------------------------
2012-04-28 09:26:18.41 Server * Short Stack Dump
2012-04-28 09:26:18.41 Server 7C82BC38 Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server 71AE24BA Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server 71B24BD9 Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server 71B24711 Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server 71B24608 Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server 71C03FD5 Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server 71C0416E Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server 0119A237 Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server 0119A3EB Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server 011777D2 Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server 0119A012 Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server 0103CDAA Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server 01006E27 Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server 01006F4D Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server 01006C5D Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server 010AAC3C Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server 010AAB5C Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server 010AA60C Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server 010AA7A9 Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server 781329BB Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server 78132A47 Module(UNKNOWN+00000000)
2012-04-28 09:26:18.41 Server Stack Signature for the dump is 0x44DB07C5
All Replies
-
Sunday, April 29, 2012 1:58 PM
seems required to apply latest hot fix or it may required to contact MS support for the dump generated.
Rama Udaya.K ramaudaya.blogspot.com ---------------------------------------- Please remember to mark the replies as answers if they help and unmark them if they provide no help.
- Edited by Rama UdayaMicrosoft Community Contributor Sunday, April 29, 2012 2:18 PM
-
Monday, April 30, 2012 3:02 AM
Hello FloridaDBA,
This exception appear long time ago, in SQL2000 i also had the same problem. In google or Microsoft Help don't help me any more.
With exception c0000005 we won't know exactly where they are come from....
My solution is trace SQL of database and try to find table cause exception, after that try to re-index. If the first step don't success, try to backup table and truncate and create new one.Hope helpful to you.
P/s: If your system running SQL2000, please update lastest patch (SP4 version 2249) this exception seen gone. With newer version of sql please update.
Cuong
- Edited by Dang Vinh Cuong Monday, April 30, 2012 3:06 AM
- Marked As Answer by Iric WenModerator Tuesday, May 08, 2012 6:15 AM
-
Monday, April 30, 2012 2:22 PM
Basically, as you may be aware & as it spells out EXCEPTION_ACCESS_VIOLATION occurs when thread goes to read/write on a virtual address space which it has no appropriate access to.
With above dump, it seems that symbols are missing.
Can you please see if there is any non-native DLL in SQL Server Address space?
Is there a particular reason why you are still on 9.00.4053 which came around 2009?
9.00.5000 (SP4) & 9.00.5266 CU# 3 released on 2010 & 2011 respectively. If you can then please try to be on latest build.
Click on How to obtain the latest service pack for SQL Server 2005.
