November 14, 2007 at 8:35 am
Folks,
I have a problem,
dbcc checkdb with no_infomsgs says:
CHECKDB found 0 allocation errors and 7 consistency errors in table 'COEP' (object ID 1361439924).
CHECKDB found 0 allocation errors and 9 consistency errors in table 'GLPCA' (object ID 1405300116).
CHECKDB found 0 allocation errors and 79 consistency errors in table 'COSP' (object ID 2074490469).
CHECKDB found 0 allocation errors and 100 consistency errors in database 'FC1'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (FC1 ).
I have only pasted summary information for the sake of brevity.
I know for a fact this is old data and that this problem has existed for a long time (way past any existing backups).
Does anyone have some suggestions for identifying the actual data in question and removing it manually?
(rather than running repair_allow_data_loss)
I would be most grateful for any feedback.
Thanks,
Tim
Thanks,
Tim
November 14, 2007 at 12:24 pm
You need to post the complete output before I can tell you what the problems are - then it *may* be possible to get around the problems without running repair. However, given that CHECKDB has specified REPAIR_ALLOW_DATA_LOSS, it's extremely unlikely that there's any other way.
Please post the output of running CHECKDB with the NO_INFOMSGS and ALL_ERRORMSGS options.
Thanks
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
November 14, 2007 at 1:14 pm
Thanks Paul,
Here's the full text:
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -956259060, index ID 28940, page ID (6:6190825). The PageId in the page header = (34819:-1992097595).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -7979418, index ID 12544, page ID (6:6190826). The PageId in the page header = (60365:989151006).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 1000, index ID 0, page ID (6:6190829). The PageId in the page header = (0:256001).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 69141534, index ID 1045, page ID (6:6190828). The PageId in the page header = (1065:69403682).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 947143278, index ID 20528, page ID (6:6190827). The PageId in the page header = (26316:1103713538).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 1361439924, index ID 2, page ID (6:8467433). The PageId in the page header = (6:8180080).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 1361439924, index ID 2, page ID (6:8467434). The PageId in the page header = (6:8180081).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 1361439924, index ID 2, page ID (6:8467435). The PageId in the page header = (6:8180082).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 1361439924, index ID 2, page ID (6:8467436). The PageId in the page header = (6:8180083).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 1361439924, index ID 2, page ID (6:8467437). The PageId in the page header = (6:8180084).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 1361439924, index ID 2, page ID (6:8467438). The PageId in the page header = (6:8180085).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 1361439924, index ID 2, page ID (6:8467439). The PageId in the page header = (6:8180086).
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1405300116, index ID 0: Page (6:8467432) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1405300116, index ID 0, page (6:8467432), row 0. Test (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed. Values are 427 and 426.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1405300116, index ID 0: Page (6:8467433) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1405300116, index ID 0: Page (6:8467434) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1405300116, index ID 0: Page (6:8467435) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1405300116, index ID 0: Page (6:8467436) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1405300116, index ID 0: Page (6:8467437) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1405300116, index ID 0: Page (6:8467438) could not be processed. See other errors for details.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID -956259060)' (object ID -956259060).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID -7979418)' (object ID -7979418).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 1000)' (object ID 1000).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 69141534)' (object ID 69141534).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 947143278)' (object ID 947143278).
CHECKDB found 0 allocation errors and 7 consistency errors in table 'COEP' (object ID 1361439924).
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1405300116, index ID 0: Page (6:8467439) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2074490469, index ID 0: Page (6:6190824) could not be processed. See other errors for details.
Server: Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 0, page (6:6190824). Test (sorted .offset <= m_freeData) failed. Slot 3, offset 0x24a4 is invalid.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2074490469, index ID 0: Page (6:6190825) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2074490469, index ID 0: Page (6:6190826) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2074490469, index ID 0: Page (6:6190827) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2074490469, index ID 0: Page (6:6190828) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2074490469, index ID 0: Page (6:6190829) could not be processed. See other errors for details.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (1:7018949) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (1:8282737) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (1:8282738) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (1:8578775) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:5870617) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:5870618) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:5870685) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:5948462) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:5950641) was not encountered.
CHECKDB found 0 allocation errors and 9 consistency errors in table 'GLPCA' (object ID 1405300116).
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:5950956) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:6002890) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:6012807) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:6038384) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:6039493) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:6039494) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:6039616) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:6039914) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:6039918) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:6039919) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:6043420) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:6043421) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:6125199) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:6132959) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:6161888) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:6323636) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:6323637) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:7276392) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:7276393) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:7431656) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:7431660) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:7431662) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:7431807) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (3:8055738) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (4:5580270) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (4:6055491) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (4:6057904) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (4:6269704) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (4:6269705) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (4:6269706) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (4:6269707) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (4:6397043) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (4:6404769) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (4:6782068) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (4:7334886) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (4:7544364) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (4:7544365) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (4:7556976) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (4:7556977) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (4:7876955) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:6076746) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:6118270) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:6131072) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:6190956) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:6190957) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:6190958) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:6190959) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:6309485) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:6309486) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:6309487) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:6323600) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:6323601) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:6323602) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:6323603) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:6584076) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:6663561) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:6979153) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:7923990) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:7923991) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:8030726) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:8030727) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:8061755) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2074490469, index ID 1. Parent node for page (6:8277400) was not encountered.
CHECKDB found 0 allocation errors and 79 consistency errors in table 'COSP' (object ID 2074490469).
CHECKDB found 0 allocation errors and 100 consistency errors in database 'FC1'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (FC1 ).
November 14, 2007 at 2:15 pm
Well, you've certainly got some IO susbsystem-caused corruption in there. You could *try* rebuilding the clustered index on the COSP table to fix some of the problems, but the rest you'll have to fix with REPAIR_ALLOW_DATA_LOSS.
Try that (after making a backup first) and see what happens.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
November 14, 2007 at 3:12 pm
Thanks Paul,
Much appreciated.
This system (a copy of an older one which has line-by-line the same errors) is on new hardware now and the corruptions come from older hardware so at least I don't have any doubt about the current hardware (or further corruptions).
I will build a copy on test hardware and see how we go....
Ahh well.... I'd better stock up on Espresso's
🙁
Tim
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply