July 26, 2017 at 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'.
July 26, 2017 at 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.
July 26, 2017 at 6:27 am
joliveira 19841 - Wednesday, July 26, 2017 4:32 AMHi!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
Forgot to ask, did you run DBCC CHECKDB ('DBNAME') WITH NO_INFOMSGS ALL_ERRORMSGS ?
😎
July 26, 2017 at 8:56 am
Eirikur Eiriksson - Wednesday, July 26, 2017 5:12 AMQuick 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
Eirikur Eiriksson - Wednesday, July 26, 2017 6:49 AMForgot 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
Yes. The output I posted is the complete result of the check.
July 26, 2017 at 9:06 am
joliveira 19841 - Wednesday, July 26, 2017 9:01 AMHi 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
joliveira 19841 - Wednesday, July 26, 2017 8:56 AMEirikur Eiriksson - Wednesday, July 26, 2017 5:12 AMQuick 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
Perry Whittle - Wednesday, July 26, 2017 9:06 AMjoliveira 19841 - Wednesday, July 26, 2017 9:01 AMHi 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
Eirikur Eiriksson - Wednesday, July 26, 2017 9:07 AMjoliveira 19841 - Wednesday, July 26, 2017 8:56 AMEirikur Eiriksson - Wednesday, July 26, 2017 5:12 AMQuick 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
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
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
July 27, 2017 at 4:54 am
GilaMonster - Wednesday, July 26, 2017 1:38 PMCheckDB 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 stateWhat 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 = 1106115727Can 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
Lynn Pettis - Wednesday, July 26, 2017 12:15 PMFirst, 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