Database gone to SUSPECT

Question

Post reply

Database gone to SUSPECT

sivaprasad

SSCertifiable

Points: 6183
More actions
April 5, 2003 at 3:54 am

#158865

One of our Database on SUSPECT Status. I tried with
1. SP_RESET_STATUS
2. SP_DETACHDB & SP_ATTACHDB
but it does not work out.
the error log of SQL Server 7.0 as follows..,
2003-04-03 16:29:10.89 spid50 0
spid 50, Getrow: rowoffset entry 10(0) out of range (pg (0x1:0x709c), obj 0x49d145b4, db 9, stat b) 0
2003-04-03 16:29:11.37 spid50 Error: 625, Severity: 20, State: 3 0
2003-04-03 16:29:11.37 spid50 Could not retrieve row from logical page (0:28828) by RID because the entry in the offset table (10) for that RID (2) is less than or equal to 0.. 0
2003-04-03 16:29:11.82 spid50 Using 'sqlimage.dll' version '4.0.5' 0
Dump thread - spid = 50, PSS = 0x716550b4, EC = 0x71655264 0
Stack Dump being sent to C:\MSSQL7\log\SQL00012.dmp 0
******************************************************************************* 0
* 0
* BEGIN STACK DUMP: 0
* 04/03/03 16:29:18 spid 50 0
* 0
* Input Buffer 135 bytes - 0
* " A R D B . d b o . a r _ o u t s t a n d i n g _ a d j u _ p r g ; 1 0
* § 0
* CUMIHABRTV § 0
* b11 8 § 0
* 11502 § 0
* 31/03/2003 0
* 0
******************************************************************************* 0
------------------------------------------------------------------------------- 0
Short Stack Dump 0
0x77f67a6b Module(ntdll+7a6b) (ZwGetContextThread+b) 0
0x00778999 Module(sqlservr+378999) (utassert_fail+1a0) 0
0x006ca593 Module(sqlservr+2ca593) (PageRef::ModifyColumns+2d8) 0
0x006ca295 Module(sqlservr+2ca295) (PageRef::ModifyColumns+22) 0
0x006dfac8 Module(sqlservr+2dfac8) (XDES::UndoPageOperation+419) 0
0x006def8e Module(sqlservr+2def8e) (XDES::RollbackToLsn+307) 0
0x00589d95 Module(sqlservr+189d95) (XDES::Rollback+14c) 0
0x006e046f Module(sqlservr+2e046f) (XCB::Rollback+2f9) 0
0x0058c8d7 Module(sqlservr+18c8d7) (clean_process+162) 0
0x005e98b0 Module(sqlservr+1e98b0) (execrpc+80b) 0
0x41062798 Module(opends60+2798) (execute_rpc+421) 0
0x410618d6 Module(opends60+18d6) (execute_event+21a) 0
0x41061baf Module(opends60+1baf) (process_commands+107) 0
0x41092be1 Module(ums+2be1) (ProcessWorkRequests+ed) 0
0x4109336a Module(ums+336a) (ThreadStartRoutine+139) 0
0x7800b995 Module(MSVCRT+b995) (beginthread+ce) 0
0x77f04ede Module(KERNEL32+4ede) (lstrcmpiW+be) 0
0x00000000 Module(sqlservr+ffc00000) 0
2003-04-03 16:29:18.50 kernel SQL Server Assertion: File: <pageref.cpp>, line=2168 0
Failed Assertion = 'newPFSFreeSpace == pPage->GetPFSFreeSpace ()'. 0
2003-04-03 16:29:18.51 spid50 Error: 3624, Severity: 20, State: 1. 0
2003-04-03 16:29:18.51 spid50 Log space info for tran 0:8199219 in database 9 0
Before: LogRecs= 8810 Used= 1332700, Rsvd= 1851810, SysUsed= 0 0
After: LogRecs= 8816 Used= 1333396, Rsvd= 1851078, SysUsed= 0 0
Short= 0, ShortComp= -1851114, TotalUsed= 1333396, Short%=-138.8 0
2003-04-03 16:29:29.26 spid50 Error: 3314, Severity: 21, State: 4 0
2003-04-03 16:29:29.26 spid50 Error while undoing logged operation in database 'ARDB'. Error at log record ID (339670:658:94).. 0
2003-04-03 16:29:29.28 spid50 Error: 9001, Severity: 21, State: 1 0
2003-04-03 16:29:29.28 spid50 The log for database 'ARDB' is not available.. 0
2003-04-03 16:29:55.81 spid50 Error: 3314, Severity: 21, State: 2 0
2003-04-03 16:29:55.81 spid50 Error while undoing logged operation in database 'ARDB'. Error at log record ID (339667:928:1).. 0
2003-04-03 16:30:02.07 spid8 Closing file D:\DATALOG\RAMCOBE\ARDEV.MDF. 0
2003-04-03 16:30:02.07 spid8 Closing file D:\DATALOG\RAMCOBE\AR_LOG.LDF. 0
2003-04-03 16:30:02.07 spid8 Starting up database 'ARDB'. 0
2003-04-03 16:30:02.07 spid8 Opening file D:\DATALOG\RAMCOBE\ARDEV.MDF. 0
2003-04-03 16:30:02.26 spid8 Opening file D:\DATALOG\RAMCOBE\AR_LOG.LDF. 0
2003-04-03 16:30:12.23 spid8 Recovery progress on database 'ARDB' (9): 4 percent. 0
2003-04-03 16:30:12.26 spid8 Recovery progress on database 'ARDB' (9): 9 percent. 0
2003-04-03 16:30:12.29 spid8 Recovery progress on database 'ARDB' (9): 14 percent. 0
2003-04-03 16:30:13.06 spid8 Recovery progress on database 'ARDB' (9): 19 percent. 0
2003-04-03 16:30:13.26 spid8 Recovery progress on database 'ARDB' (9): 23 percent. 0
2003-04-03 16:30:13.31 spid8 Recovery progress on database 'ARDB' (9): 28 percent. 0
2003-04-03 16:30:13.37 spid8 Recovery progress on database 'ARDB' (9): 33 percent. 0
2003-04-03 16:30:13.42 spid8 Recovery progress on database 'ARDB' (9): 38 percent. 0
2003-04-03 16:30:13.48 spid8 Recovery progress on database 'ARDB' (9): 42 percent. 0
2003-04-03 16:30:13.53 spid8 Recovery progress on database 'ARDB' (9): 47 percent. 0
2003-04-03 16:30:13.57 spid8 Recovery progress on database 'ARDB' (9): 52 percent. 0
2003-04-03 16:30:13.64 spid8 Recovery progress on database 'ARDB' (9): 57 percent. 0
2003-04-03 16:30:13.70 spid8 Recovery progress on database 'ARDB' (9): 61 percent. 0
2003-04-03 16:30:13.74 spid8 Recovery progress on database 'ARDB' (9): 66 percent. 0
2003-04-03 16:30:13.82 spid8 Recovery progress on database 'ARDB' (9): 71 percent. 0
2003-04-03 16:30:13.85 spid8 1 transactions rolled forward in database 'ARDB' (9). 0
2003-04-03 16:30:13.85 spid8 Recovery progress on database 'ARDB' (9): 76 percent. 0
2003-04-03 16:30:13.87 spid8 Recovery progress on database 'ARDB' (9): 80 percent. 0
2003-04-03 16:30:13.90 spid8 Using 'sqlimage.dll' version '4.0.5' 0
Dump thread - spid = 8, PSS = 0x420b4084, EC = 0x420b4234 0
Stack Dump being sent to C:\MSSQL7\log\SQL00013.dmp 0
******************************************************************************* 0
* 0
* BEGIN STACK DUMP: 0
* 04/03/03 16:30:16 spid 8 0
* 0
* 0
******************************************************************************* 0
------------------------------------------------------------------------------- 0
Short Stack Dump 0
0x77f67a6b Module(ntdll+7a6b) (ZwGetContextThread+b) 0
0x00778999 Module(sqlservr+378999) (utassert_fail+1a0) 0
0x006ca593 Module(sqlservr+2ca593) (PageRef::ModifyColumns+2d8) 0
0x006ca295 Module(sqlservr+2ca295) (PageRef::ModifyColumns+22) 0
0x006dfac8 Module(sqlservr+2dfac8) (XDES::UndoPageOperation+419) 0
0x006def8e Module(sqlservr+2def8e) (XDES::RollbackToLsn+307) 0
0x00588913 Module(sqlservr+188913) (RecoveryMgr::UndoPass+1b6) 0
0x004c11a0 Module(sqlservr+c11a0) (RecoveryMgr::RecoverDb+35c) 0
0x004be9c4 Module(sqlservr+be9c4) (DBTABLE::Startup+624) 0
0x004bdfae Module(sqlservr+bdfae) (DBMgr::StartupDB+2c4) 0
0x006bbd4c Module(sqlservr+2bbd4c) (TaskDbRestart::ProcessTskPkt+14f) 0
0x004c4e3b Module(sqlservr+c4e3b) (GlobalTskMgrProc+117) 0
0x41092be1 Module(ums+2be1) (ProcessWorkRequests+ed) 0
0x4109336a Module(ums+336a) (ThreadStartRoutine+139) 0
0x7800b995 Module(MSVCRT+b995) (beginthread+ce) 0
0x77f04ede Module(KERNEL32+4ede) (lstrcmpiW+be) 0
0x00000000 Module(sqlservr+ffc00000) 0
2003-04-03 16:30:17.81 kernel SQL Server Assertion: File: <pageref.cpp>, line=2168 0
Failed Assertion = 'newPFSFreeSpace == pPage->GetPFSFreeSpace ()'. 0
2003-04-03 16:30:17.81 spid8 Location: pageref.cpp:2168 0
Expression: newPFSFreeSpace == pPage->GetPFSFreeSpace () 0
SPID: 8 0
Process ID: 307 0
2003-04-03 16:30:17.81 spid8 Error: 3624, Severity: 20, State: 1. 0
2003-04-03 16:30:17.81 spid8 Log space info for tran 0:8199219 in database 9 0
Before: LogRecs= 8816 Used= 0, Rsvd= 0, SysUsed= 0 0
After: LogRecs= 8817 Used= 116, Rsvd= 0, SysUsed= 0 0
Short= 0, ShortComp= 116, TotalUsed= 116, Short%=100.0 0
2003-04-03 16:30:17.81 spid8 Error: 3314, Severity: 21, State: 3 0
2003-04-03 16:30:17.81 spid8 Error while undoing logged operation in database 'ARDB'. Error at log record ID (339670:658:89).. 0
2003-04-03 16:30:51.93 spid8 Error: 3414, Severity: 21, State: 1 0
2003-04-03 16:30:51.93 spid8 Database 'ARDB' (database ID 9) could not recover. Contact Technical Support.. 0
PLZ give me a solutuion on recovering of the DB.
S SIVAPRASASD
Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

Based on the fact it states

1 transactions rolled forward in database 'ARDB' (9). 0

then I assume you are getting to the point where it reads the transaction log. Copy the db files to another location the detach and try removing the ldf file from the current location. Then run sp_attach_single_file_db

to attach the database and allow to build a new TL. If that works then something is in error in the old TL. Not you may lose data with this if anything was in the TL uncommitted.

yin chia SSC Rookie Points: 45 More actions · Answer 2

I'm facing the same problem and I'd tried attach database using single file. But It still couldn't work out.