x

SQL Server Crashes with a stack dump

One of my SQL Servers(2008R2 SP1) crashed this morning with error:

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).

I also found a stack dump in the error log.

I have restarted the service since then and it is working fine now, DBCC comes clean, so does hardware diagnostic. Has anybody seen this before? I have found numorous links on the net like this one [http://bit.ly/LaWD0L][1] but I just want to see if you guys have experienced this before and what the best thing to do to avoid chance of it happening again?

P.S. I am planning to open a ticket with MS to see what they have to say(in case I hit a bug or windows update cause the problem etc..).

Edit:

I just found out security update was applied two hours before the crash, not sure it was the culprit.

UPDATE:

Worked with MS support engineers and just wanted to update the question here with their findings in case somebody else find it useful. They find out from the stack dump that the crash has something to do with the database access engine(we use Microsoft 64-bit ACE provider to upload data from Excel to SQL Server) and I was told to apply patches KB2460011 and KB2516475 and seems like the issue if fixed(we were not able to replicate the issue after applying the hotfixes; it crashed twice before that).

[1]: http://bit.ly/LaWD0L
more ▼

asked May 09, 2012 at 12:17 PM in Default

DaniSQL gravatar image

DaniSQL
4.9k 33 35 39

Thanks for the update!
May 20, 2012 at 07:22 PM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Yep got that exact issue about 4 weeks ago!

Your best option is to open a support case with MS - they will be able to trawl the dump files and narrow down the cause for you.
more ▼

answered May 09, 2012 at 12:23 PM

Kev Riley gravatar image

Kev Riley ♦♦
53.9k 47 49 76

Thanks. I am opening a ticket with MS product support now. will update you with what they say
May 09, 2012 at 01:05 PM DaniSQL
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x595
x346
x1

asked: May 09, 2012 at 12:17 PM

Seen: 1925 times

Last Updated: May 20, 2012 at 07:22 PM