Post reply

DBCC Check

  • 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?

  • June 28, 2011 at 4:18 am

    #1345048

    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

  • June 28, 2011 at 4:24 am

    #1345052

    2005

  • June 28, 2011 at 4:53 am

    #1345066

    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

  • June 28, 2011 at 4:54 am

    #1345067

    Microsoft SQL Server 2005 - 9.00.3239.00 (Intel X86) Apr 9 2008 22:56:02 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

  • June 29, 2011 at 3:56 am

    #1345762

    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?

  • June 29, 2011 at 4:11 am

    #1345772

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

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • June 29, 2011 at 4:14 am

    #1345777

    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

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

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