crash - fatal exception c0000005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

crash - fatal exception c0000005

Author

Topic

cz
Starting Member

19 Posts

Posted - 2011-10-16 : 15:44:13

Our sql server 2005 Enterprise on Windows 2003 crashes every a few weeks with the following same messages:

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).
2011-10-14 12:10:59.85 Server Using 'dbghelp.dll' version '4.0.5'
2011-10-14 12:10:59.86 Server **Dump thread - spid = 0, PSS = 0x0000000000000000, EC = 0x0000000000000000
2011-10-14 12:10:59.86 Server ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0356.txt
2011-10-14 12:10:59.86 Server * *******************************************************************************
2011-10-14 12:10:59.86 Server *
2011-10-14 12:10:59.86 Server * BEGIN STACK DUMP:
2011-10-14 12:10:59.86 Server * 10/14/11 12:10:59 spid 0
2011-10-14 12:10:59.86 Server *
2011-10-14 12:10:59.86 Server * ex_handle_except encountered exception C0000005 - Server terminating
2011-10-14 12:10:59.86 Server *
2011-10-14 12:10:59.86 Server *
2011-10-14 12:10:59.86 Server * MODULE BASE END SIZE
2011-10-14 12:10:59.87 Server * sqlservr 0000000001000000 000000000365AFFF 0265b000
2011-10-14 12:10:59.87 Server * ntdll 0000000077EC0000 0000000077FFAFFF 0013b000
....
2011-10-14 12:10:59.88 Server * winhttp 000007FF763B0000 000007FF76433FFF 00084000
2011-10-14 12:10:59.88 Server *
2011-10-14 12:10:59.88 Server * P1Home: 0000000000000001:
2011-10-14 12:10:59.88 Server * P2Home: 000000006A5DD1D0: 000A003000300030 0000000000000000 0000000000000000 0000000000000000 0000000000000030 0000000000000000
...

We opened a Ticket to Microsoft Support months ago, but there is little help. Winhttp.dll is suspecteded to cause the crashes.
Any clues?

Thanks in advance.
cz

cz
Starting Member

19 Posts

Posted - 2011-10-16 : 15:58:14

More info-

select @@version,

Microsoft SQL Server 2005 - 9.00.4294.00 (X64) Apr 15 2010 11:59:31 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

9.00.4294.00 SP3 Enterprise Edition (64-bit)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-10-16 : 23:08:23

You need to reopen the case with Microsoft or create a new one. Only they can help you with this.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

alexylee
Starting Member

14 Posts

Posted - 2011-10-18 : 14:18:30

As Tara said, you will need to have MS to look at the dump.
Most likely MS will need a dump file.
Please take a look at below to get a dump file.

http://debugbeyond.blogspot.com/2010/06/how-to-dump.html
(try B. using adplus)

Once you get crash dump, the cause can be investigated much easier.

http://www.sqlmgmt.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources