SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database gone into Suspect mode after the execution of an SP


Database gone into Suspect mode after the execution of an SP

Author
Message
SQLServerScrapbook
SQLServerScrapbook
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 30
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
GilaMonster
GilaMonster
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86649 Visits: 45254
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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search