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.
| Author |
Topic |
|
nathans
Aged Yak Warrior
938 Posts |
 Posted - 2005-07-12 : 19:20:31
|
Guys,I ran into this today after a fellow developer created a new trigger. It is documented here:[url]http://support.microsoft.com/kb/839523[/url]Dropping the trigger of course alleviated the problem, but Id like to understand what was happening under the hood at the time.I first noticed an increasing frequency of these errors in the Event Log: ODBC: Msg 0, Level 19, State 1SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. These errors (around 12-15) were eventually followed by a shutdown of the database and caused a fail over of our cluster. I ended up tracing the login detailed in the Event Log and tracked it down to a procedure causing the trigger to fire.But whats going on internally?!Nathan Skerl |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-07-12 : 19:46:29
|
| Nathan, you will probably have to post on an MS forum and hope an engineer responds. Basically, the update caused a memory exception. There are quite a few memory related errors with TEXT and cursors fixed with SP4 if you read the release notes. Manipulation of text from a memory and physical storage perspective is completely different than other data operations in SQL Server.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2005-07-13 : 13:17:48
|
| Thanks D. most information I find on M$ says little about the problem; only points to upgrade SP3 -> SP4, which resolves the issue.Nathan Skerl |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-07-13 : 13:20:50
|
| He doesn't mean looking at the MS site. He means to post your question where you know MS engineers read the questions. Such an example are the MS newsgroups.Tara |
|
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2005-07-13 : 13:23:45
|
Roger that Tara.Thanks  Nathan Skerl |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-07-13 : 13:29:09
|
| If you're lucky, Paul Randal will see this thread and help answer your questions. Tara |
|
|
|
|
|
|
access violation exception while updating TEXT col