April 10, 2013 at 1:54 am
SQL Server Version: 2005 Standard RTM version 9.00.1406.00
A Stored Procedure(This SP Runs everyday but has never caused suspect mode) was running which does a large amount of data transfer within a transaction. The transaction might remain active for about 15 to 20 minutes. There might also be other processes accessing the table which is under transaction. So blocking might have been occurring. The Database went into suspect Mode generating huge number of Dump files. The DB was however restored from the Backup files. My concern is that the same issue could rise again as we are not able to identify the problem behind it.
Some error data from Dump files:
First File Dump File:
* 04/04/13 01:18:16 spid 95
* Location: lckmgr.cpp:9421
* Expression: NULL == m_lockList.Head ()
Second Dump File:
* 04/04/13 01:18:20 spid 95
* Exception Address = 0000000000000000 Module(sqlservr+FFFFFFFFFF000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 0000000000000000
Third Dump File:
* 04/04/13 01:18:23 spid 95
* Location: "xact.cpp":2630
* Expression: !m_updNestedXactCnt
* SPID: 95
* Process ID: 268
* Description: Trying to use the transaction while there are 1 parallel nested xacts outstanding
Fourth Dump File:
* 04/04/13 01:18:43 spid 95
* ex_raise2: Exception raised, major=52, minor=42, state=1, severity=22
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Begin transaction log dump for database 'DB_Name'; for rollback failure - filter XdesId.
--Huge Number of Transaction Log Entries Here--
Fifth Dump File:
* 04/04/13 01:21:40 spid 18
* Location: page.cpp:4245
* Expression: spaceNeeded <= spaceContig && spaceNeeded <= space_usable
Sixth Dump File:
* 04/04/13 01:21:40 spid 18
* HandleAndNoteToErrorlog: Exception raised, major=34, minor=48, severity=21
Next Dump File:
* 04/04/13 01:21:57 spid 21
* Location: page.cpp:4100
* Expression: !pageFull
* SPID: 21
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Begin transaction log dump for database 'DB_Name'; for REDO failure - filter on PageId.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Begin transaction log dump for database 'DB_Name'; for REDO failure - filter XdesId.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Begin transaction log dump for database 'DB_Name'; for recovery failure - no filter.
Seventh Dump File:
* 04/04/13 01:24:39 spid 98
* Exception Address = 000000000288FC14 Module(sqlservr+000000000188FC14)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 0000000000000000
Eighth Dump File:
* 04/04/13 01:24:41 spid 98
* Location: T:\Yukon\sqltdbms\storeng\dfs\manager\lckmgrp.h:675
* Expression: m_iteratorInSafeState
Nineth Dump File:
* 04/04/13 01:24:41 spid 98
* ex_terminator - Last chance exception handling
April 10, 2013 at 2:21 am
The very first thing I will suggest is patch that instance. You're running RTM of SQL 2005 which had some nasty problems in it. Patch up to SP4 ASAP.
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply