Tuesday, March 27, 2012

Getting 644 Error in log

I am getting a pair of errors in the SQL Server log:
**
Could not find the index entry for
RID '367007017019022035037037038030303130313030303037353836
353030323431324d415220202020202020' in index page
(1:126931), index ID 2, database 'ee8idbbd'..
**
AND
**
Error: 644, Severity: 21, State: 5
**
I looked in KB article 834290 and tried Method 2 on the
affected table. There were no columns that exhibited the
given symptoms, so either I did it wrong or this does not
apply.
Can someone help me diagnose this problem before it
happens again?1. Is that the build you are on at the moment (build 904 sqlservr.exe)? If
so, you might want to call into PSS to get that hotfix.
2. Do you get this error, as the KB article claims when you run an update
on READ UNCOMMITTED?
3. You might want to run a checkdb on the database and make sure that there
are no allocation or consistency errors.
Cheers.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

No comments:

Post a Comment