September 5, 2007 at 10:36 am
While my production sql server was running, suddenly i got the error below and the connection was lost. Can anyone pls guide what is this error for, why this occured and how to resolve it.
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 232 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
I run SQL Server 2000 with SP4 with OS Win 2003. I found this error in event viewer
September 6, 2007 at 1:29 am
You'll probably find the stack dump files in SQL's error log directory. (SQLDumpxxx.txt and SQLDumpxxx.mdmp)
I would recomend that you contact MS's Product Support and log a case for this. There are many possble reasons for a stack dump and they are the best people to investigate that.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 6, 2007 at 6:33 am
Thanks. The problem is they charge and our company is very poor to pay this charges. My boss feels that this is a dba work.
September 6, 2007 at 10:05 am
Yes, they do charge. If the crash is a result of a bug, I believe that they waiver that charge (I could be wrong)
Does your boss expect you to debug the sql server application as well as admin it? Do you understand assembler or have access to the SQL source code? If this was a once off, you can probably ignore it. If not....
If there is a SQLDumpxxx.txt file, take a look in it and you should be able to find the input buffer at the time of the crash. Might give you an idea, might not. If you can reproduce the crash, it might be something in the query, or it might not.
Sorry I can't help you more. I had a Server that dumped core about once a day for several months. Got nowhere until we called PSS in. They traced it to a faulty 3rd party OLE DB driver
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 6, 2007 at 1:43 pm
The charges for the support call to PSS should be waived if you in fact run into a documented 'bug'.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply