February 9, 2016 at 10:49 am
We have a production database for Solarwinds Orion Network Performance Monitor in which we discovered corruption in a MapStudioFiles table following DBCC CHECKDB errors.
CHECKDB Output:
Msg 8961, Level 16, State 1, Line 1 Table error: Object ID 747149707, index ID 1, partition ID 72062477575258112, alloc unit ID 72057594049724416 (type LOB data). The off-row data node at page (1:3414), slot 0, text ID 1031262163304448 does not match its reference from page (1:412), slot 22.
Msg 8961, Level 16, State 1, Line 1 Table error: Object ID 747149707, index ID 1, partition ID 72062477575258112, alloc unit ID 72057594049724416 (type LOB data). The off-row data node at page (1:160077), slot 0, text ID 1026498368241664 does not match its reference from page (1:408), slot 11.
Msg 8929, Level 16, State 1, Line 1 Object ID 747149707, index ID 1, partition ID 72062477575258112, alloc unit ID 72062476506234880 (type In-row data): Errors found in off-row data with ID 182073438109696 owned by data record identified by RID = (1:408:11)
Msg 8929, Level 16, State 1, Line 1 Object ID 747149707, index ID 1, partition ID 72062477575258112, alloc unit ID 72062476506234880 (type In-row data): Errors found in off-row data with ID 186837233172480 owned by data record identified by RID = (1:412:22)
CHECKDB found 0 allocation errors and 4 consistency errors in table 'MapStudioFiles' (object ID 747149707). CHECKDB found 0 allocation errors and 4 consistency errors in database 'OrionNPM'. repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (OrionNPM).
We don't have a valid backup because it seems this error was happening a long time but since the server was not on our monitor tool nobody noticed the errors on DBCC job and there wasn't any e-mail being sent on failure.
On a TEST server we restored a backup just to check the repair allow data loss method and DBCC CheckTable was able to fix two rows (rows that were deleted)
CHECKTABLE fixed 0 allocation errors and 2 consistency errors in table 'MapStudioFiles' (object ID 747149707).
And then after the second execution all issues were fixed. Table has 249 rows from 251 rows before the repair.
In another test:
I've noticed that if you query the table doing a select you don't get any error and shows all the data on the table. (is this because the corruption is on a LOB column?)
So my first thought was copy the table into another table to see if any errors arise. I was able to do it without any problem using SELECT INTO, after that ran the DBCC CHECKTABLE and everything is OK and the new table has the 251 rows.
Does this mean that the corruption is gone? Or because it is on a LOB column you would only see the issue if you try to get the object out of the database or if the application queries the table?
March 22, 2016 at 9:51 am
I have the same exact thing happening, only with DocStreams in a Sharepoint db.
I'm using a test system, restored the backup (that has the corruption), DBCC CHECKDB came back with 44 inconsistancy errors. I ran repair allow data loss, out put below.
Repair: Deleted off-row data column with ID 1484914688, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594055688192 (type LOB data) on page (1:2512099), slot 1.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594055688192 (type LOB data) on page (1:2512099), slot 2.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:332935), slot 39. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1484914688, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:332935), slot 39.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:332935), slot 40. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:332935), slot 40.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:494113), slot 35. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1484914688, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:494113), slot 35.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:494113), slot 36. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:494113), slot 36.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:507574), slot 25. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1484914688, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:507574), slot 25.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:515005), slot 5. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:515005), slot 5.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:647593), slot 54. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:647593), slot 54.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:675208), slot 35. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1484914688, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:675208), slot 35.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:1198374), slot 79. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1484914688, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:1198374), slot 79.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:1198374), slot 80. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:1198374), slot 80.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:1221271), slot 79. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:1221271), slot 79.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:1303165), slot 37. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1484914688, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:1303165), slot 37.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:1303165), slot 38. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:1303165), slot 38.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:1313480), slot 12. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:1313480), slot 12.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:1611376), slot 34. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1484914688, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:1611376), slot 34.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:1611376), slot 35. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:1611376), slot 35.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:1646410), slot 21. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1484914688, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:1646410), slot 21.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:1646410), slot 22. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:1646410), slot 22.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:1666174), slot 23. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1484914688, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:1666174), slot 23.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:1666174), slot 24. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:1666174), slot 24.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:1814932), slot 32. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1484914688, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:1814932), slot 32.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:1814932), slot 33. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:1814932), slot 33.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:1815656), slot 20. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1484914688, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:1815656), slot 20.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:1815656), slot 21. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:1815656), slot 21.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:1913566), slot 56. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1484914688, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:1913566), slot 56.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:2078247), slot 51. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1484914688, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:2078247), slot 51.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:2078247), slot 52. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:2078247), slot 52.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:2089630), slot 44. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1484914688, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:2089630), slot 44.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:2089630), slot 45. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:2089630), slot 45.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:2459688), slot 4. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:2459688), slot 4.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:2897814), slot 14. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1484914688, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:2897814), slot 14.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:2897814), slot 15. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:2897814), slot 15.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:3210743), slot 17. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:3210743), slot 17.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:3282035), slot 18. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1484914688, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:3282035), slot 18.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:3282035), slot 19. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:3282035), slot 19.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:3549876), slot 23. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:3549876), slot 23.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:3648238), slot 7. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1484914688, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:3648238), slot 7.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:3851773), slot 4. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1484914688, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:3851773), slot 4.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:3851773), slot 5. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:3851773), slot 5.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:4280754), slot 2. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1484914688, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:4280754), slot 2.
Repair: Deleted record for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data), on page (1:4280754), slot 3. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1723727872, for object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data) on page (1:4280754), slot 3.
Msg 8914, Level 16, State 1, Line 3
Incorrect PFS free space information for page (1:2512099) in object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594055688192 (type LOB data). Expected value 95_PCT_FULL, actual value 80_PCT_FULL.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 3
Table error: Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594055688192 (type LOB data). The off-row data node at page (1:2512099), slot 1, text ID 1484914688 is not referenced.
The error has been repaired.
Msg 8964, Level 16, State 1, Line 3
Table error: Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594055688192 (type LOB data). The off-row data node at page (1:2512099), slot 2, text ID 1723727872 is not referenced.
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1484914688 owned by data record identified by RID = (1:332935:39)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:332935:40)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1484914688 owned by data record identified by RID = (1:494113:35)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:494113:36)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1484914688 owned by data record identified by RID = (1:507574:25)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:515005:5)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:647593:54)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1484914688 owned by data record identified by RID = (1:675208:35)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1484914688 owned by data record identified by RID = (1:1198374:79)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:1198374:80)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:1221271:79)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1484914688 owned by data record identified by RID = (1:1303165:37)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:1303165:38)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:1313480:12)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1484914688 owned by data record identified by RID = (1:1611376:34)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:1611376:35)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1484914688 owned by data record identified by RID = (1:1646410:21)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:1646410:22)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1484914688 owned by data record identified by RID = (1:1666174:23)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:1666174:24)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1484914688 owned by data record identified by RID = (1:1814932:32)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:1814932:33)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1484914688 owned by data record identified by RID = (1:1815656:20)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:1815656:21)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1484914688 owned by data record identified by RID = (1:1913566:56)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1484914688 owned by data record identified by RID = (1:2078247:51)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:2078247:52)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1484914688 owned by data record identified by RID = (1:2089630:44)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:2089630:45)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:2459688:4)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1484914688 owned by data record identified by RID = (1:2897814:14)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:2897814:15)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:3210743:17)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1484914688 owned by data record identified by RID = (1:3282035:18)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:3282035:19)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:3549876:23)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1484914688 owned by data record identified by RID = (1:3648238:7)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1484914688 owned by data record identified by RID = (1:3851773:4)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:3851773:5)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1484914688 owned by data record identified by RID = (1:4280754:2)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 3
Object ID 926626344, index ID 0, partition ID 72057594265075712, alloc unit ID 72057594169655296 (type In-row data): Errors found in off-row data with ID 1723727872 owned by data record identified by RID = (1:4280754:3)
The error has been repaired.
CHECKDB found 0 allocation errors and 44 consistency errors in table 'DocStreams' (object ID 926626344).
CHECKDB fixed 0 allocation errors and 44 consistency errors in table 'DocStreams' (object ID 926626344).
CHECKDB found 0 allocation errors and 44 consistency errors in database 'WSS_Content'.
CHECKDB fixed 0 allocation errors and 44 consistency errors in database 'WSS_Content'.
____________________________________________________________________________________________
I can do a look up of the RIDS and they come up with no errors.
DBCC TRACEON (3604, -1)
GO
DBCC PAGE('WSS_Content', 1, 3851773, 3) WITH TABLERESULTS
GO
I'm confused on if there is data loss or if it's the LOB.
Also, before I ran the DBCC Repair allow data loss, I exported the data to a new table in a new DB, ran DBCC CHECKDB and it came back clean.... Is that my fix or is Repair allow dataloss my fix?
Any help would be appreciated. I inherited this at my new job and it had been going on for a long time, so restore from back isn't an option.
March 22, 2016 at 2:18 pm
It's a little difficult to say if the corruption is gone. From the error messages, it appears to be a problem with the pointers on the two off-row storage pages. The two off-row LOB data pages could have been switched, for all we know. I would determine the two IDs for the rows that REPAIR_ALLOW_DATA_LOSS deleted, copy these two rows from the production table to the test database, and have the business owner check these two rows to make sure that the data is correct. If it is, you may be able to proceed with copying the table in production to a new copy, and rename the new copy into the old table's place.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply