Post reply

Consistency Errors on System Tables

  • July 26, 2017 at 4:32 am

    #339129

    Hi!

    We have a database which is connected to a third-party software.
    Recently we have installed a new version of this software which needs to make some changes in the database (new tables, new columns, etc)
    During this procedure of updating the database the operation aborted with the following error:

    ****
    Microsoft][ODBC SQL Server Driver][SQL Server]Internal error. The string routine in file e:\sql11_main_t\sql\ntdbms\common\shared\dstream.cpp,
    line 685 failed with HRESULT 0x8007007a. [Microsoft][ODBC SQL Server Driver][SQL Server]Unable to find index entry in index ID 1, of table 1323151759, in database 'XXXXXX'. The indicated index is corrupt or there is a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact product support.
    ****

    After that we run the DBCC CheckDB and it reported several consistency errors.
    Then we then run CheckDB with the “repair_rebuild” option and some of the errors were fixed.
    We were able to perform the database update and everything seems to work fine.
    However, when we run CheckDB again we still get consistency errors. These errors are related with system tables and as far as I know they can´t be corrected with the usual repairing tools.

    Any ideas to solve this situation? Restore a backup is not an option because all backups also have the corruption.

    Below is the result of CheckDB after the repair.

    Thanks in Advance

    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=1) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=2) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=3) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=4) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=5) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=6) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=7) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=8) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=9) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=10) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=11) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=12) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=13) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=14) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=15) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=16) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=17) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=18) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=19) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=20) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=21) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=22) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=23) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=24) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=25) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=26) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=27) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=28) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=29) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=30) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=31) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=32) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=33) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=34) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=35) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=36) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=37) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=38) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=39) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=40) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=41) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=42) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=43) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=44) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=45) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=46) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=47) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=48) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=49) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=50) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=51) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=52) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=53) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=54) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=55) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=56) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=57) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=58) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=59) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=60) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=61) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=62) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=63) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=64) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=65) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=66) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=67) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=68) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=69) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=70) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=71) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=72) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=73) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1122115784) of row (object_id=1122115784,index_id=0) in sys.indexes does not have a matching row (object_id=1122115784) in sys.objects.
    CHECKDB found 0 allocation errors and 74 consistency errors not associated with any single object.
    CHECKDB found 0 allocation errors and 74 consistency errors in database 'XXXXXX'.

  • July 26, 2017 at 5:12 am

    #1952725

    Quick thought, looks like either that the update has removed the object with the id of 1106115727 by deleting from the system tables, have you reviewed the "upgrade" script?
    😎
    Have you checked the IO subsystem's health?
    Last time I fixed an error similar to this when the client didn't have any usable backups, I did a side by side installation and then migrated to the new installation by simple detach/attach.

  • July 26, 2017 at 6:27 am

    #1952744

    joliveira 19841 - Wednesday, July 26, 2017 4:32 AM

    Hi!

    We have a database which is connected to a third-party software.
    Recently we have installed a new version of this software which needs to make some changes in the database (new tables, new columns, etc)
    During this procedure of updating the database the operation aborted with the following error:

    ****
    Microsoft][ODBC SQL Server Driver][SQL Server]Internal error. The string routine in file e:\sql11_main_t\sql\ntdbms\common\shared\dstream.cpp,
    line 685 failed with HRESULT 0x8007007a. [Microsoft][ODBC SQL Server Driver][SQL Server]Unable to find index entry in index ID 1, of table 1323151759, in database 'XXXXXX'. The indicated index is corrupt or there is a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact product support.
    ****

    After that we run the DBCC CheckDB and it reported several consistency errors.
    Then we then run CheckDB with the “repair_rebuild†option and some of the errors were fixed.
    We were able to perform the database update and everything seems to work fine.
    However, when we run CheckDB again we still get consistency errors. These errors are related with system tables and as far as I know they can´t be corrected with the usual repairing tools.

    Any ideas to solve this situation? Restore a backup is not an option because all backups also have the corruption.

    Below is the result of CheckDB after the repair.

    Thanks in Advance

    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=1) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=2) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=3) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=4) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=5) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=6) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=7) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=8) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=9) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=10) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=11) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=12) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=13) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=14) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=15) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=16) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=17) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=18) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=19) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=20) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=21) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=22) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=23) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=24) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=25) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=26) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=27) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=28) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=29) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=30) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=31) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=32) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=33) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=34) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=35) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=36) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=37) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=38) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=39) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=40) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=41) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=42) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=43) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=44) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=45) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=46) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=47) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=48) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=49) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=50) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=51) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=52) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=53) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=54) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=55) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=56) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=57) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=58) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=59) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=60) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=61) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=62) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=63) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=64) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=65) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=66) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=67) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=68) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=69) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=70) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=71) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=72) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1106115727) of row (object_id=1106115727,column_id=73) in sys.columns does not have a matching row (object_id=1106115727) in sys.objects.
    Msg 8992, Level 16, State 1, Line 1
    Check Catalog Msg 3853, State 1: Attribute (object_id=1122115784) of row (object_id=1122115784,index_id=0) in sys.indexes does not have a matching row (object_id=1122115784) in sys.objects.
    CHECKDB found 0 allocation errors and 74 consistency errors not associated with any single object.
    CHECKDB found 0 allocation errors and 74 consistency errors in database 'XXXXXX'.

    is this the full message

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • July 26, 2017 at 6:49 am

    #1952748

    Forgot to ask, did you run DBCC CHECKDB ('DBNAME') WITH NO_INFOMSGS ALL_ERRORMSGS ?
    😎

  • July 26, 2017 at 8:56 am

    #1952807

    Eirikur Eiriksson - Wednesday, July 26, 2017 5:12 AM

    Quick thought, looks like either that the update has removed the object with the id of 1106115727 by deleting from the system tables, have you reviewed the "upgrade" script?
    😎
    Have you checked the IO subsystem's health?
    Last time I fixed an error similar to this when the client didn't have any usable backups, I did a side by side installation and then migrated to the new installation by simple detach/attach.

    Hi! Thanks for your reply!

    We don't have access to de script.
    After the error on the upgrade I performed the tests on a backup that I did before the test. The upgrade script is no the guilty :))

    The timeline was like this …

    1) Backup of database
    2) Execute the upgrade script … Aborted with error
    3) Restore the backup in a different server
    4) Execute DBCC CheckDB … Errors were found
    5) Execute DBCC CheckDB (with the option *Repair_rebuild*) … Some errors were corrected, some were not
    6) Perform the upgrade script again … It went ok
    7) Perform DBCC CheckDB again with the “upgraded†database… The check returned the list of errors that I posted before.

  • July 26, 2017 at 8:59 am

    #1952809

    Eirikur Eiriksson - Wednesday, July 26, 2017 6:49 AM

    Forgot to ask, did you run DBCC CHECKDB ('DBNAME') WITH NO_INFOMSGS ALL_ERRORMSGS ?
    😎

    Hi Eirikur!

    I didn't run ... Did it now... The output is the same.

    Thanks

  • July 26, 2017 at 9:01 am

    #1952811

    Hi Perry
    Thnks for the reply!

    Yes. The output I posted is the  complete result of the check.

  • July 26, 2017 at 9:06 am

    #1952813

    joliveira 19841 - Wednesday, July 26, 2017 9:01 AM

    Hi Perry
    Thnks for the reply!

    Yes. The output I posted is the  complete result of the check.

    the message mentions "Unable to find index entry in index ID 1, of table 1323151759"
    Have you identified what object 1323151759 is?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • July 26, 2017 at 9:07 am

    #1952815

    joliveira 19841 - Wednesday, July 26, 2017 8:56 AM

    Eirikur Eiriksson - Wednesday, July 26, 2017 5:12 AM

    Quick thought, looks like either that the update has removed the object with the id of 1106115727 by deleting from the system tables, have you reviewed the "upgrade" script?
    😎
    Have you checked the IO subsystem's health?
    Last time I fixed an error similar to this when the client didn't have any usable backups, I did a side by side installation and then migrated to the new installation by simple detach/attach.

    Hi! Thanks for your reply!

    We don't have access to de script.
    After the error on the upgrade I performed the tests on a backup that I did before the test. The upgrade script is no the guilty :))

    The timeline was like this …

    1) Backup of database
    2) Execute the upgrade script … Aborted with error
    3) Restore the backup in a different server
    4) Execute DBCC CheckDB … Errors were found
    5) Execute DBCC CheckDB (with the option *Repair_rebuild*) … Some errors were corrected, some were not
    6) Perform the upgrade script again … It went ok
    7) Perform DBCC CheckDB again with the “upgraded†database… The check returned the list of errors that I posted before.

    So the error output you posted are the errors after the repair?
    😎

    What about the storage (IO subsystem)? Have you checked the health status there, i.e. SMART,SAN logs etc?

  • July 26, 2017 at 9:45 am

    #1952830

    Perry Whittle - Wednesday, July 26, 2017 9:06 AM

    joliveira 19841 - Wednesday, July 26, 2017 9:01 AM

    Hi Perry
    Thnks for the reply!

    Yes. The output I posted is the  complete result of the check.

    the message mentions "Unable to find index entry in index ID 1, of table 1323151759"
    Have you identified what object 1323151759 is?

    Yes.
    It was identified and that error was repaired by the "CheckDB repair_rebuild".
    After the repair, the upgrade of the database perform ok.
    But still I get that list of 74 inconsistencies when executing CheckDB

  • July 26, 2017 at 9:48 am

    #1952834

    Eirikur Eiriksson - Wednesday, July 26, 2017 9:07 AM

    joliveira 19841 - Wednesday, July 26, 2017 8:56 AM

    Eirikur Eiriksson - Wednesday, July 26, 2017 5:12 AM

    Quick thought, looks like either that the update has removed the object with the id of 1106115727 by deleting from the system tables, have you reviewed the "upgrade" script?
    😎
    Have you checked the IO subsystem's health?
    Last time I fixed an error similar to this when the client didn't have any usable backups, I did a side by side installation and then migrated to the new installation by simple detach/attach.

    Hi! Thanks for your reply!

    We don't have access to de script.
    After the error on the upgrade I performed the tests on a backup that I did before the test. The upgrade script is no the guilty :))

    The timeline was like this …

    1) Backup of database
    2) Execute the upgrade script … Aborted with error
    3) Restore the backup in a different server
    4) Execute DBCC CheckDB … Errors were found
    5) Execute DBCC CheckDB (with the option *Repair_rebuild*) … Some errors were corrected, some were not
    6) Perform the upgrade script again … It went ok
    7) Perform DBCC CheckDB again with the “upgraded†database… The check returned the list of errors that I posted before.

    So the error output you posted are the errors after the repair?
    😎

    What about the storage (IO subsystem)? Have you checked the health status there, i.e. SMART,SAN logs etc?

    Yes.
    The error output I posted is from after the repair
    At this stage I'm working with the database at a completely different system/hardware.

  • July 26, 2017 at 12:15 pm

    #1952876

    First, running,  CheckDB with the “repair_rebuild” is really your option of last resort.

    Have you tried restoring a previous backup to a sandbox server and running the CheckDB against an older database backup to determine if the corruption occurred earlier than the upgrade.

  • July 26, 2017 at 1:38 pm

    #1952898

    CheckDB with repair (any repair) WILL NOT fix these errors, so please don't suggest it.
    You probably do have some IO subsystem problems, as that's the main cause of corruption, and the repair left the DB in a not-completely-consistent state

    What do the following return?

    SELECT *  FROM sys.objects WHERE object_id = 1106115727
    SELECT * FROM sys.columns WHERE object_id = 1106115727
    SELECT * FROM sys.indexes WHERE object_id = 1106115727

    Can your try the following please?
    Restore the damaged backup to a test server
    Identify what table is object_id 1106115727
    Drop that table
    Then run CheckDB (without a repair option) and post whatever errors it returns

    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

  • July 27, 2017 at 4:54 am

    #1952973

    GilaMonster - Wednesday, July 26, 2017 1:38 PM

    CheckDB with repair (any repair) WILL NOT fix these errors, so please don't suggest it.
    You probably do have some IO subsystem problems, as that's the main cause of corruption, and the repair left the DB in a not-completely-consistent state

    What do the following return?

    SELECT *  FROM sys.objects WHERE object_id = 1106115727
    SELECT * FROM sys.columns WHERE object_id = 1106115727
    SELECT * FROM sys.indexes WHERE object_id = 1106115727

    Can your try the following please?
    Restore the damaged backup to a test server
    Identify what table is object_id 1106115727
    Drop that table
    Then run CheckDB (without a repair option) and post whatever errors it returns

    Hi Gail!
    Thanks for the help

    I looked for the table with that object_id and the table does  not exists. That is the cause of inconsistency .
    Judging by the name of the columns I have that table in the database but with a different  object _id
    So I have some columns in sys.columns that don't belong to any table.

    This is happening  in a  DB restored from a backup made before the upgarde and in a completely different server .

  • July 27, 2017 at 4:56 am

    #1952974

    Lynn Pettis - Wednesday, July 26, 2017 12:15 PM

    First, running,  CheckDB with the “repair_rebuild†is really your option of last resort.

    Have you tried restoring a previous backup to a sandbox server and running the CheckDB against an older database backup to determine if the corruption occurred earlier than the upgrade.

    Hi Lynn!
    Thanks for the help.

    The corruption occured before the upgrade.
    Older backups have it too.

Viewing 15 posts - 1 through 15 (of 26 total)

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy