October 13, 2010 at 9:37 pm
Hi DBCC failed for 2 databases on one of our prod boxes.
here is the detail:
Database : InvesTran
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=54343308,referenced_minor_id=23) of row (class=0,object_id=5119309,column_id=0,referenced_major_id=54343308,referenced_minor_id=23) in sys.sql_dependencies does not have a matching row (object_id=54343308,column_id=23) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=54343308,referenced_minor_id=23) of row (class=0,object_id=21119366,column_id=0,referenced_major_id=54343308,referenced_minor_id=23) in sys.sql_dependencies does not have a matching row (object_id=54343308,column_id=23) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=54343308,referenced_minor_id=23) of row (class=0,object_id=133171820,column_id=0,referenced_major_id=54343308,referenced_minor_id=23) in sys.sql_dependencies does not have a matching row (object_id=54343308,column_id=23) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=54343308,referenced_minor_id=23) of row (class=0,object_id=647217606,column_id=0,referenced_major_id=54343308,referenced_minor_id=23) in sys.sql_dependencies does not have a matching row (object_id=54343308,column_id=23) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=54343308,referenced_minor_id=23) of row (class=0,object_id=1736653530,column_id=0,referenced_major_id=54343308,referenced_minor_id=23) in sys.sql_dependencies does not have a matching row (object_id=54343308,column_id=23) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=386920550,referenced_minor_id=8) of row (class=0,object_id=5119309,column_id=0,referenced_major_id=386920550,referenced_minor_id=8) in sys.sql_dependencies does not have a matching row (object_id=386920550,column_id=8) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=386920550,referenced_minor_id=8) of row (class=0,object_id=21119366,column_id=0,referenced_major_id=386920550,referenced_minor_id=8) in sys.sql_dependencies does not have a matching row (object_id=386920550,column_id=8) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=386920550,referenced_minor_id=8) of row (class=0,object_id=480265016,column_id=0,referenced_major_id=386920550,referenced_minor_id=8) in sys.sql_dependencies does not have a matching row (object_id=386920550,column_id=8) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=247268236,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=263268293,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=391268749,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=679269775,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=826746298,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=1223271713,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=1399272340,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=773122045,referenced_minor_id=4) of row (class=0,object_id=432264845,column_id=0,referenced_major_id=773122045,referenced_minor_id=4) in sys.sql_dependencies does not have a matching row (object_id=773122045,column_id=4) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=854398213,referenced_minor_id=19) of row (class=0,object_id=144315874,column_id=0,referenced_major_id=854398213,referenced_minor_id=19) in sys.sql_dependencies does not have a matching row (object_id=854398213,column_id=19) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=854398213,referenced_minor_id=19) of row (class=0,object_id=912982579,column_id=0,referenced_major_id=854398213,referenced_minor_id=19) in sys.sql_dependencies does not have a matching row (object_id=854398213,column_id=19) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=854398213,referenced_minor_id=19) of row (class=0,object_id=951270744,column_id=0,referenced_major_id=854398213,referenced_minor_id=19) in sys.sql_dependencies does not have a matching row (object_id=854398213,column_id=19) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=854398213,referenced_minor_id=19) of row (class=0,object_id=1201035660,column_id=0,referenced_major_id=854398213,referenced_minor_id=19) in sys.sql_dependencies does not have a matching row (object_id=854398213,column_id=19) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=854398213,referenced_minor_id=32) of row (class=0,object_id=1790121618,column_id=0,referenced_major_id=854398213,referenced_minor_id=32) in sys.sql_dependencies does not have a matching row (object_id=854398213,column_id=32) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=910222593,referenced_minor_id=3) of row (class=0,object_id=810746241,column_id=0,referenced_major_id=910222593,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=910222593,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1064442916,referenced_minor_id=9) of row (class=0,object_id=5119309,column_id=0,referenced_major_id=1064442916,referenced_minor_id=9) in sys.sql_dependencies does not have a matching row (object_id=1064442916,column_id=9) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1064442916,referenced_minor_id=9) of row (class=0,object_id=544265244,column_id=0,referenced_major_id=1064442916,referenced_minor_id=9) in sys.sql_dependencies does not have a matching row (object_id=1064442916,column_id=9) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1762157373,referenced_minor_id=5) of row (class=0,object_id=5119309,column_id=0,referenced_major_id=1762157373,referenced_minor_id=5) in sys.sql_dependencies does not have a matching row (object_id=1762157373,column_id=5) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1762157373,referenced_minor_id=5) of row (class=0,object_id=720265871,column_id=0,referenced_major_id=1762157373,referenced_minor_id=5) in sys.sql_dependencies does not have a matching row (object_id=1762157373,column_id=5) in sys.columns.
CHECKDB found 0 allocation errors and 26 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 26 consistency errors in database 'InvesTran'.
Database : InvesTranGoldman
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=54343308,referenced_minor_id=23) of row (class=0,object_id=5119309,column_id=0,referenced_major_id=54343308,referenced_minor_id=23) in sys.sql_dependencies does not have a matching row (object_id=54343308,column_id=23) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=54343308,referenced_minor_id=23) of row (class=0,object_id=21119366,column_id=0,referenced_major_id=54343308,referenced_minor_id=23) in sys.sql_dependencies does not have a matching row (object_id=54343308,column_id=23) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=54343308,referenced_minor_id=23) of row (class=0,object_id=133171820,column_id=0,referenced_major_id=54343308,referenced_minor_id=23) in sys.sql_dependencies does not have a matching row (object_id=54343308,column_id=23) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=54343308,referenced_minor_id=23) of row (class=0,object_id=647217606,column_id=0,referenced_major_id=54343308,referenced_minor_id=23) in sys.sql_dependencies does not have a matching row (object_id=54343308,column_id=23) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=54343308,referenced_minor_id=23) of row (class=0,object_id=1736653530,column_id=0,referenced_major_id=54343308,referenced_minor_id=23) in sys.sql_dependencies does not have a matching row (object_id=54343308,column_id=23) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=386920550,referenced_minor_id=8) of row (class=0,object_id=5119309,column_id=0,referenced_major_id=386920550,referenced_minor_id=8) in sys.sql_dependencies does not have a matching row (object_id=386920550,column_id=8) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=386920550,referenced_minor_id=8) of row (class=0,object_id=21119366,column_id=0,referenced_major_id=386920550,referenced_minor_id=8) in sys.sql_dependencies does not have a matching row (object_id=386920550,column_id=8) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=386920550,referenced_minor_id=8) of row (class=0,object_id=480265016,column_id=0,referenced_major_id=386920550,referenced_minor_id=8) in sys.sql_dependencies does not have a matching row (object_id=386920550,column_id=8) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=247268236,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=263268293,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=391268749,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=679269775,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=826746298,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=1223271713,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=1399272340,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=773122045,referenced_minor_id=4) of row (class=0,object_id=432264845,column_id=0,referenced_major_id=773122045,referenced_minor_id=4) in sys.sql_dependencies does not have a matching row (object_id=773122045,column_id=4) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=854398213,referenced_minor_id=19) of row (class=0,object_id=144315874,column_id=0,referenced_major_id=854398213,referenced_minor_id=19) in sys.sql_dependencies does not have a matching row (object_id=854398213,column_id=19) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=854398213,referenced_minor_id=19) of row (class=0,object_id=912982579,column_id=0,referenced_major_id=854398213,referenced_minor_id=19) in sys.sql_dependencies does not have a matching row (object_id=854398213,column_id=19) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=854398213,referenced_minor_id=19) of row (class=0,object_id=951270744,column_id=0,referenced_major_id=854398213,referenced_minor_id=19) in sys.sql_dependencies does not have a matching row (object_id=854398213,column_id=19) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=854398213,referenced_minor_id=19) of row (class=0,object_id=1201035660,column_id=0,referenced_major_id=854398213,referenced_minor_id=19) in sys.sql_dependencies does not have a matching row (object_id=854398213,column_id=19) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=854398213,referenced_minor_id=32) of row (class=0,object_id=1790121618,column_id=0,referenced_major_id=854398213,referenced_minor_id=32) in sys.sql_dependencies does not have a matching row (object_id=854398213,column_id=32) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=910222593,referenced_minor_id=3) of row (class=0,object_id=810746241,column_id=0,referenced_major_id=910222593,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=910222593,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1064442916,referenced_minor_id=9) of row (class=0,object_id=5119309,column_id=0,referenced_major_id=1064442916,referenced_minor_id=9) in sys.sql_dependencies does not have a matching row (object_id=1064442916,column_id=9) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1064442916,referenced_minor_id=9) of row (class=0,object_id=544265244,column_id=0,referenced_major_id=1064442916,referenced_minor_id=9) in sys.sql_dependencies does not have a matching row (object_id=1064442916,column_id=9) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1762157373,referenced_minor_id=5) of row (class=0,object_id=5119309,column_id=0,referenced_major_id=1762157373,referenced_minor_id=5) in sys.sql_dependencies does not have a matching row (object_id=1762157373,column_id=5) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1762157373,referenced_minor_id=5) of row (class=0,object_id=720265871,column_id=0,referenced_major_id=1762157373,referenced_minor_id=5) in sys.sql_dependencies does not have a matching row (object_id=1762157373,column_id=5) in sys.columns.
CHECKDB found 0 allocation errors and 26 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 26 consistency errors in database 'InvesTranGoldman'.
Are these non-repariable issues? i have backups but i wanted to be sure if this can be resolved without restore. this is production box.
October 13, 2010 at 10:35 pm
sorry, the server mentioned in my prev post is a UAT/QA box.
However, i ran checkdb on prod and getting similar errors for these two databases.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=54343308,referenced_minor_id=23) of row (class=0,object_id=5119309,column_id=0,referenced_major_id=54343308,referenced_minor_id=23) in sys.sql_dependencies does not have a matching row (object_id=54343308,column_id=23) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=54343308,referenced_minor_id=23) of row (class=0,object_id=21119366,column_id=0,referenced_major_id=54343308,referenced_minor_id=23) in sys.sql_dependencies does not have a matching row (object_id=54343308,column_id=23) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=54343308,referenced_minor_id=23) of row (class=0,object_id=133171820,column_id=0,referenced_major_id=54343308,referenced_minor_id=23) in sys.sql_dependencies does not have a matching row (object_id=54343308,column_id=23) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=54343308,referenced_minor_id=23) of row (class=0,object_id=647217606,column_id=0,referenced_major_id=54343308,referenced_minor_id=23) in sys.sql_dependencies does not have a matching row (object_id=54343308,column_id=23) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=54343308,referenced_minor_id=23) of row (class=0,object_id=1736653530,column_id=0,referenced_major_id=54343308,referenced_minor_id=23) in sys.sql_dependencies does not have a matching row (object_id=54343308,column_id=23) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=386920550,referenced_minor_id=8) of row (class=0,object_id=5119309,column_id=0,referenced_major_id=386920550,referenced_minor_id=8) in sys.sql_dependencies does not have a matching row (object_id=386920550,column_id=8) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=386920550,referenced_minor_id=8) of row (class=0,object_id=21119366,column_id=0,referenced_major_id=386920550,referenced_minor_id=8) in sys.sql_dependencies does not have a matching row (object_id=386920550,column_id=8) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=386920550,referenced_minor_id=8) of row (class=0,object_id=480265016,column_id=0,referenced_major_id=386920550,referenced_minor_id=8) in sys.sql_dependencies does not have a matching row (object_id=386920550,column_id=8) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=247268236,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=263268293,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=391268749,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=679269775,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=826746298,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=1223271713,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=1399272340,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=773122045,referenced_minor_id=4) of row (class=0,object_id=432264845,column_id=0,referenced_major_id=773122045,referenced_minor_id=4) in sys.sql_dependencies does not have a matching row (object_id=773122045,column_id=4) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=854398213,referenced_minor_id=19) of row (class=0,object_id=144315874,column_id=0,referenced_major_id=854398213,referenced_minor_id=19) in sys.sql_dependencies does not have a matching row (object_id=854398213,column_id=19) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=854398213,referenced_minor_id=19) of row (class=0,object_id=912982579,column_id=0,referenced_major_id=854398213,referenced_minor_id=19) in sys.sql_dependencies does not have a matching row (object_id=854398213,column_id=19) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=854398213,referenced_minor_id=19) of row (class=0,object_id=951270744,column_id=0,referenced_major_id=854398213,referenced_minor_id=19) in sys.sql_dependencies does not have a matching row (object_id=854398213,column_id=19) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=854398213,referenced_minor_id=19) of row (class=0,object_id=1201035660,column_id=0,referenced_major_id=854398213,referenced_minor_id=19) in sys.sql_dependencies does not have a matching row (object_id=854398213,column_id=19) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=854398213,referenced_minor_id=32) of row (class=0,object_id=1790121618,column_id=0,referenced_major_id=854398213,referenced_minor_id=32) in sys.sql_dependencies does not have a matching row (object_id=854398213,column_id=32) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=910222593,referenced_minor_id=3) of row (class=0,object_id=810746241,column_id=0,referenced_major_id=910222593,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=910222593,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1064442916,referenced_minor_id=9) of row (class=0,object_id=5119309,column_id=0,referenced_major_id=1064442916,referenced_minor_id=9) in sys.sql_dependencies does not have a matching row (object_id=1064442916,column_id=9) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1064442916,referenced_minor_id=9) of row (class=0,object_id=544265244,column_id=0,referenced_major_id=1064442916,referenced_minor_id=9) in sys.sql_dependencies does not have a matching row (object_id=1064442916,column_id=9) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1762157373,referenced_minor_id=5) of row (class=0,object_id=5119309,column_id=0,referenced_major_id=1762157373,referenced_minor_id=5) in sys.sql_dependencies does not have a matching row (object_id=1762157373,column_id=5) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1762157373,referenced_minor_id=5) of row (class=0,object_id=720265871,column_id=0,referenced_major_id=1762157373,referenced_minor_id=5) in sys.sql_dependencies does not have a matching row (object_id=1762157373,column_id=5) in sys.columns.
CHECKDB found 0 allocation errors and 26 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 26 consistency errors in database 'InvesTran'.
-------------------------------
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=54343308,referenced_minor_id=23) of row (class=0,object_id=5119309,column_id=0,referenced_major_id=54343308,referenced_minor_id=23) in sys.sql_dependencies does not have a matching row (object_id=54343308,column_id=23) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=54343308,referenced_minor_id=23) of row (class=0,object_id=21119366,column_id=0,referenced_major_id=54343308,referenced_minor_id=23) in sys.sql_dependencies does not have a matching row (object_id=54343308,column_id=23) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=54343308,referenced_minor_id=23) of row (class=0,object_id=133171820,column_id=0,referenced_major_id=54343308,referenced_minor_id=23) in sys.sql_dependencies does not have a matching row (object_id=54343308,column_id=23) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=54343308,referenced_minor_id=23) of row (class=0,object_id=647217606,column_id=0,referenced_major_id=54343308,referenced_minor_id=23) in sys.sql_dependencies does not have a matching row (object_id=54343308,column_id=23) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=54343308,referenced_minor_id=23) of row (class=0,object_id=1736653530,column_id=0,referenced_major_id=54343308,referenced_minor_id=23) in sys.sql_dependencies does not have a matching row (object_id=54343308,column_id=23) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=386920550,referenced_minor_id=8) of row (class=0,object_id=5119309,column_id=0,referenced_major_id=386920550,referenced_minor_id=8) in sys.sql_dependencies does not have a matching row (object_id=386920550,column_id=8) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=386920550,referenced_minor_id=8) of row (class=0,object_id=21119366,column_id=0,referenced_major_id=386920550,referenced_minor_id=8) in sys.sql_dependencies does not have a matching row (object_id=386920550,column_id=8) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=386920550,referenced_minor_id=8) of row (class=0,object_id=480265016,column_id=0,referenced_major_id=386920550,referenced_minor_id=8) in sys.sql_dependencies does not have a matching row (object_id=386920550,column_id=8) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=247268236,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=263268293,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=391268749,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=679269775,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=826746298,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=1223271713,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=458640877,referenced_minor_id=35) of row (class=0,object_id=1399272340,column_id=0,referenced_major_id=458640877,referenced_minor_id=35) in sys.sql_dependencies does not have a matching row (object_id=458640877,column_id=35) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=773122045,referenced_minor_id=4) of row (class=0,object_id=432264845,column_id=0,referenced_major_id=773122045,referenced_minor_id=4) in sys.sql_dependencies does not have a matching row (object_id=773122045,column_id=4) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=854398213,referenced_minor_id=19) of row (class=0,object_id=144315874,column_id=0,referenced_major_id=854398213,referenced_minor_id=19) in sys.sql_dependencies does not have a matching row (object_id=854398213,column_id=19) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=854398213,referenced_minor_id=19) of row (class=0,object_id=912982579,column_id=0,referenced_major_id=854398213,referenced_minor_id=19) in sys.sql_dependencies does not have a matching row (object_id=854398213,column_id=19) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=854398213,referenced_minor_id=19) of row (class=0,object_id=951270744,column_id=0,referenced_major_id=854398213,referenced_minor_id=19) in sys.sql_dependencies does not have a matching row (object_id=854398213,column_id=19) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=854398213,referenced_minor_id=19) of row (class=0,object_id=1201035660,column_id=0,referenced_major_id=854398213,referenced_minor_id=19) in sys.sql_dependencies does not have a matching row (object_id=854398213,column_id=19) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=854398213,referenced_minor_id=32) of row (class=0,object_id=1790121618,column_id=0,referenced_major_id=854398213,referenced_minor_id=32) in sys.sql_dependencies does not have a matching row (object_id=854398213,column_id=32) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=910222593,referenced_minor_id=3) of row (class=0,object_id=810746241,column_id=0,referenced_major_id=910222593,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=910222593,column_id=3) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1064442916,referenced_minor_id=9) of row (class=0,object_id=5119309,column_id=0,referenced_major_id=1064442916,referenced_minor_id=9) in sys.sql_dependencies does not have a matching row (object_id=1064442916,column_id=9) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1064442916,referenced_minor_id=9) of row (class=0,object_id=544265244,column_id=0,referenced_major_id=1064442916,referenced_minor_id=9) in sys.sql_dependencies does not have a matching row (object_id=1064442916,column_id=9) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1762157373,referenced_minor_id=5) of row (class=0,object_id=5119309,column_id=0,referenced_major_id=1762157373,referenced_minor_id=5) in sys.sql_dependencies does not have a matching row (object_id=1762157373,column_id=5) in sys.columns.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1762157373,referenced_minor_id=5) of row (class=0,object_id=720265871,column_id=0,referenced_major_id=1762157373,referenced_minor_id=5) in sys.sql_dependencies does not have a matching row (object_id=1762157373,column_id=5) in sys.columns.
CHECKDB found 0 allocation errors and 26 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 26 consistency errors in database 'InvestranGoldman'.
------------------------------------------------ yes
yes
How can both prod and qa have similar errors on same two databases. i see these two dbs were restored on QA on 7th dec 2009. after that no restores.
or is it the prod had the issue then it propagated to qa ?
October 13, 2010 at 10:52 pm
Have you recently upgraded these databases from SQL 2000?
If so, you might want to check out these links (NOTE: the methods described are NOT supported by Microsoft!!!):
TechEd Demo: Using the SQL 2005 Dedicated Admin Connection to fix Msg 8992: corrupt system tables
Fixing DBCC CHECKDB Msg 8992 Errors [/url]
I suspect the reason this is showing up in both QA and Prod is that this corruption was in your prod database, and at some point in time it was copied (via a backup/restore) to your QA environment. This is further evidenced by both environments pointing to the same object_id values.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
October 13, 2010 at 10:57 pm
the databases on QA were restored from prod in dec last year.
is there a way to quickly check if and when it was migrated? asking the primary dba will take time.
from logs i see that dbcc has been failing for last 5 days (unfortunately no past logs) but we got alert for the first time. may be this is happening since dec last year or more!!
October 13, 2010 at 11:46 pm
Thanks Wayne. I read Paul's and ur articles. There is no straight fwd way to fix this.
compatibality level for these dbs are 80 which means they were migrated right? coz if i create a db in 2005 i generally wont change its compatibility level to 80 from 90.
Not feasible to restore from a clean backup taken in 2000 (not sure if i have that old backup). lots of changes would have been done to the db so thats not an option.
the only other thing i can see if update system tables as both articles suggested.
October 14, 2010 at 2:32 am
ps. (10/13/2010)
Are these non-repariable issues? i have backups but i wanted to be sure if this can be resolved without restore. this is production box.
They're repairable, but not in the normal way.
http://sqlinthewild.co.za/index.php/2009/08/26/corruption-in-sysdependencies/
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
October 14, 2010 at 2:34 am
WayneS (10/13/2010)
If so, you might want to check out these links (NOTE: the methods described are NOT supported by Microsoft!!!):TechEd Demo: Using the SQL 2005 Dedicated Admin Connection to fix Msg 8992: corrupt system tables
Overkill and unnecessary in this particular case. This is, in fact, the only form of orphaned system table rows that I know of that doesn't need that treatment.
ps. (10/13/2010)
the only other thing i can see if update system tables as both articles suggested.
Please don't. Not necessary here and you're likely to mess something else up in the process.
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
October 14, 2010 at 2:49 am
Thanks Gail. I read your article.
I tried to found type of object for some of the errors and in each case till now, one of the objects is either SP or a View. (i still need to run ur query for all errors).
So i need to script out the SPs/Views/Functions, drop them and recreate them. Am i right?
October 14, 2010 at 3:25 am
ps. (10/14/2010)
So i need to script out the SPs/Views/Functions, drop them and recreate them. Am i right?
Script them and their permissions, drop and recreate.
Once done, run checkDB again, the problem should be resolved.
What likely was the original cause was some bright spark back on SQL 2000 doing a delete from sysobjects to drop a table.
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
October 14, 2010 at 3:31 am
Thanks Gail. As of now I am collecting information about the affected objects. I'll need to show the details to concerned team and then we'll take action. As usual, this cannot be done immediately and need to be done in a greenzone with RFC.
I cannot find who altered the objects in 2000 coz this was migrated a year back. doubt we have trace information for that period. need to check. we have audit trace running on all servers.
October 14, 2010 at 3:35 am
ps. (10/14/2010)
I cannot find who altered the objects in 2000 coz this was migrated a year back. doubt we have trace information for that period. need to check. we have audit trace running on all servers.
It could have been done years ago. SQL 2000 doesn't run checkCatalog when checkDB runs (SQL 2005 does), so this kind of problem can go unnoticed for very long periods of time.
Is this the first time this database has had a checkDB since migration?
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
October 14, 2010 at 3:36 am
Edit: Dup
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
October 14, 2010 at 3:41 am
No. DBCC is scheduled on a daily basis. Since we support several hundred servers, its not feasible to login manually and check on each server.
We have email notification setup for any issues. I can see from past logs that this has been failing for last 5 days ( i dont have logs prior to that) but i am sure this must be failing since day 1.
Yes I came to know from Paul's and Your article that DBCC checkcatalog is not run when we run dbcc checkdb in 2000.
We still have some 2000 servers and i'm going to suggest scheduling dbcc checkcatalog on these servers.
October 14, 2010 at 3:52 am
ps. (10/14/2010)
No. DBCC is scheduled on a daily basis. Since we support several hundred servers, its not feasible to login manually and check on each server.
What????
Whoever said anything about running them manually? What's the problem with an integrity check maintenance plan or SQL agent job, one configured to mail someone if the job failed?
I don't know any DBA who runs checkDB manually on all their databases or checks the results of checkDBs manually.
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
October 14, 2010 at 3:59 am
We have the maintainence plan in place that throws email alert.
We do not use SQL Agent for job scheduling. we have a system called autosys that does scheduling part.
We have another set of dba maintainence script that does all automated work(written in vbscript). autosys calls these jobs as per schedule.
this dbamaint script has emailing functionality which sends email if anything wrong happens. i think there was some issue with the email functionality on this server. This is the first time ever that i got mail from this server.
------
Now we are slowly migrating to scripts written in powershell and scheduling using sql agent on new servers.
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply