consistency errors in table 'REPOSITORY.ITEM_STATES' in ccm DB.
Hello,
We are a customer with a development system and a couple production instances of Jazz. I'm the part time SQL guy and dishwasher. I recently encountered some corruption errors from DBCC in the table named in the subject in our development env. I cannot find any disk corruption and have gone to the trouble of replacing the disk that that the data files reside on. We are using SQL 2008R2 SP2 on win 2k8r2.
Restoring from previous backups does not help. I'm curious how important this table is to RTC and as such if running a DBCC repair may render the DB unuseable? Or if we can just ignore these errors?
btw - Why does the ccm log grow so much? Even on a Dev system with a 6G MDF our log file is 30Gig. Can it be safely truncated?
Here are the DBCC errors
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8339983196317548544 (type Unknown), page (1:166680). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -12.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 19985195799216128 (type Unknown), page ID (1:166686) contains an incorrect page ID in its page header. The PageId in the page header = (104:4391023).
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 21110928200761344 (type Unknown), page ID (1:166682) contains an incorrect page ID in its page header. The PageId in the page header = (95:7798879).
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 22518303084314624 (type Unknown), page ID (1:166687) contains an incorrect page ID in its page header. The PageId in the page header = (95:7798879).
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 30118144637206528 (type Unknown), page ID (1:166684) contains an incorrect page ID in its page header. The PageId in the page header = (45:4653133).
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 31244027362344960 (type Unknown), page ID (1:166683) contains an incorrect page ID in its page header. The PageId in the page header = (95:7798879).
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 33495818587799552 (type Unknown), page ID (1:166685) contains an incorrect page ID in its page header. The PageId in the page header = (77:5308469).
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2891216025113722880 (type Unknown), page (10369:231225286). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -12.
Thank you
Ron