DBCC Check

Question

DBCC Check

mitzyturbo

Hall of Fame

Points: 3452
More actions
June 28, 2011 at 3:46 am

#243373

Wondering if anyone else has come across this problem.
I've been getting some severity level 21's on a particular database, error below:
Unable to find index entry in index ID 1, of table 75147313, in database 'XXXXXX'. The indicated index is corrupt or there is a problem with the current update plan
I've ran DBCC Checkdb against this database, 2 indexes show up as having problems:
Table error: table 'XXXXXXXX' (ID 75147313). Data row does not have a matching index row in the index 'XXXXX' (ID 4). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (1:420348:28) identified by (InterfaceID = 11970 and DateTime = '2011-06-27 01:08:56.000' and Archive = 0) with index values 'DateTime = '2011-06-27 01:08:56.000' and InterfaceID = 11970 and Archive = 0'.
The other error message for the other index is the same
I've tried the usual steps of dropping and recreating the index and although DBCC Checkdb returns no error after this, the error appears the next day.
Does anyone have any suggestions as to what to try next?

Viewing 8 posts - 1 through 7 (of 7 total)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

What version of SQL?

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

mitzyturbo Hall of Fame Points: 3452 More actions · Answer 2

mitzyturbo

Hall of Fame

Points: 3452

June 28, 2011 at 4:24 am

#1345052

2005

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

I need specifics please.

SELECT @@version

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

mitzyturbo Hall of Fame Points: 3452 More actions · Answer 4

mitzyturbo Hall of Fame Points: 3452 More actions · Answer 5

Also tried the following:

DBCC CHECKTABLE ("XXXXXXXXXX", 4);

Getting over 200 errors as below:

Msg 8951, Level 16, State 1, Line 1

Table error: table 'XXXXXXXXXXXXXXXXx' (ID 1934629935). Data row does not have a matching index row in the index 'IX_DateTime' (ID 4). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 1

Data row (1:185914:43) identified by (InterfaceID = 2827 and DateTime = '2011-06-27 01:09:24.997' and Archive = 0) with index values 'DateTime = '2011-06-27 01:09:24.997' and InterfaceID = 2827 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 1

Table error: table 'XXXXXXXXXXXXXXXx' (ID 1934629935). Data row does not have a matching index row in the index 'IX_DateTime' (ID 4). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 1

Data row (1:187327:56) identified by (InterfaceID = 7300 and DateTime = '2011-06-27 01:09:31.997' and Archive = 0) with index values 'DateTime = '2011-06-27 01:09:31.997' and InterfaceID = 7300 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 1

CHECKTABLE found 0 allocation errors and 274 consistency errors in table 'XXXXXXXXXXXXXXx' (object ID 1934629935).

repair_rebuild is the minimum repair level for the errors found by DBCC CHECKTABLE (XXXXXXXXXXXXXXXXXXXX, IX_DateTime).

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Is repairrebuild the only way to go?

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 6

apply the service pack 4 for SQL Server 2005 and then rebuild the currupt indexes once again

My Blog
www.aureus-salah.com

Abhijit More SSCertifiable Points: 6897 More actions · Answer 7

mitzyturbo (6/28/2011)
Wondering if anyone else has come across this problem.
I've been getting some severity level 21's on a particular database, error below:
Unable to find index entry in index ID 1, of table 75147313, in database 'XXXXXX'. The indicated index is corrupt or there is a problem with the current update plan
I've ran DBCC Checkdb against this database, 2 indexes show up as having problems:
Table error: table 'XXXXXXXX' (ID 75147313). Data row does not have a matching index row in the index 'XXXXX' (ID 4). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (1:420348:28) identified by (InterfaceID = 11970 and DateTime = '2011-06-27 01:08:56.000' and Archive = 0) with index values 'DateTime = '2011-06-27 01:08:56.000' and InterfaceID = 11970 and Archive = 0'.
The other error message for the other index is the same
I've tried the usual steps of dropping and recreating the index and although DBCC Checkdb returns no error after this, the error appears the next day.
Does anyone have any suggestions as to what to try next?

It seems like the index on the table got disturbed you can say corrupt. The resolution i can see here is to rebuild the index.

Abhijit - http://abhijitmore.wordpress.com