SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 SQL 2000 Suspect Database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Westley
Posting Yak Master

229 Posts

Posted - 04/17/2007 :  22:14:44  Show Profile  Reply with Quote
Guys,
Got an issue with an DB where it turn itself to suspect with just some normal queries. Its SQL 2000 8.00.2175 on Win2K3 sp1.
From SQL log, it got the following:

ex_raise2: Exception raised, major=79, minor=87, severity=22, attempting to create symptom dump

Error: 7987, Severity: 22, State: 1

SQL Server Assertion: File: <logscan.cpp>, line=3187
Failed Assertion = '(m_lastLSN == NullLSN) || (m_lastLSN > m_curLSN)'.

Any idea on what will be causing it and what can be done to fix it? We tried rebooting the instance with no luck and we finally restore the DB from last good backup. But we would like to find out the cause of it.
Thanks

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 04/18/2007 :  01:57:38  Show Profile  Visit nr's Homepage  Reply with Quote
I always look at disk problems first.


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

Westley
Posting Yak Master

229 Posts

Posted - 04/18/2007 :  03:32:16  Show Profile  Reply with Quote
Disk doesn't have any issues as we can see the file the whole time. And there is nothing shown in the Event view about disk having issues.
Go to Top of Page

Westley
Posting Yak Master

229 Posts

Posted - 04/18/2007 :  03:39:38  Show Profile  Reply with Quote
By the way, here is another message I found:

Error while undoing logged operation in database 'dbname'. Error at log record ID (191314:8296:477)..

Any other ideas?
Go to Top of Page

SatyaSKJ
Starting Member

United Kingdom
46 Posts

Posted - 04/18/2007 :  04:50:31  Show Profile  Visit SatyaSKJ's Homepage  Send SatyaSKJ a Yahoo! Message  Reply with Quote
See this relevant KBA http://support.microsoft.com/kb/319851 for the last issue. Relevant KBA http://support.microsoft.com/kb/828337/&&DI=6243&IG=30ddc38ccdae452c82a78b7fa13c264a&POS=4&CM=WPU&CE=1&CS=AWP&SR=1 for the first issue.

Satya SKJ
SQL Server MVP
http://www.sqlserver-qa.net
Go to Top of Page

Westley
Posting Yak Master

229 Posts

Posted - 04/18/2007 :  05:55:23  Show Profile  Reply with Quote
Satya,
Following the link you provided, only http://support.microsoft.com/kb/319851 works. And the fixes it suggested there was already included in sp3, which I'm already on sp4 which have got that patch in. So I don't think that is the issue here? Any other ideas?
Thanks
Go to Top of Page

mcrowley
Aged Yak Warrior

771 Posts

Posted - 04/18/2007 :  09:23:41  Show Profile  Reply with Quote
Have a look at the following link: http://support.microsoft.com/kb/828337. What is the result of this in your database?


dbcc checkdb() with no_infomsgs


You may have some inconsistencies in the database from a while ago.
Go to Top of Page

Westley
Posting Yak Master

229 Posts

Posted - 04/18/2007 :  22:45:36  Show Profile  Reply with Quote
Thanks for the link and info. But that doesn't really say much.
Since we lost the log of the DBA and we can't do anything with it, with the backup we had, we did the dbcc checkdb without any errors reported.
Any other ideas?
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 04/19/2007 :  03:48:01  Show Profile  Reply with Quote
RAM error?

I use memtest86 for RAM tests. But it needs to run for 48 hours at least - which is probably not much good if your server is 24/7!

Kristen
Go to Top of Page

SatyaSKJ
Starting Member

United Kingdom
46 Posts

Posted - 04/19/2007 :  06:43:55  Show Profile  Visit SatyaSKJ's Homepage  Send SatyaSKJ a Yahoo! Message  Reply with Quote
As you have got SP4 already its better to take up the case to CSS in this case, for the root cause.

Satya SKJ
SQL Server MVP
http://www.sqlserver-qa.net
Go to Top of Page

Westley
Posting Yak Master

229 Posts

Posted - 04/19/2007 :  20:35:31  Show Profile  Reply with Quote
I don't think its the RAM, and we did take the case up to CSS, but nothing as yet, so would like to see if anyone got any ideas that can speed up the process here....
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 04/20/2007 :  02:27:17  Show Profile  Reply with Quote
Can you reproduce the problem on a different machine? If not I would mark the machine Suspect too!

Kristen
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000