Guest User

Untitled

a guest
Jul 16th, 2018
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.98 KB | None | 0 0
  1. select * from table_a
  2. Msg 7105, Level 22, State 6, Line 1
  3. The Database ID 5, Page (1:81463), slot 53 for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE.
  4.  
  5. DBCC CHECKTABLE('table_a')
  6. DBCC results for 'table_a'.
  7. Msg 8928, Level 16, State 1, Line 1
  8. Object ID 2101582525, index ID 0, partition ID 137729312358400, alloc unit ID 137729312358400 (type In-row data):
  9. Page (1:75023) could not be processed. See other errors for details. Msg 8941, Level 16, State 2, Line 1 Table error:
  10. Object ID 2101582525, index ID 0, partition ID 137729312358400, alloc unit ID 137729312358400 (type In-row data), page (1:75023). Test (sorted [i].offset <= m_freeData) failed. Slot 1, offset 0xffff is invalid.
  11. Msg 8941, Level 16, State 2, Line 1 Table error:
  12. Object ID 2101582525, index ID 0, partition ID 137729312358400, alloc unit ID 137729312358400 (type In-row data), page (1:75023). Test (sorted [i].offset <= m_freeData) failed. Slot 1, offset 0xffff is invalid.
  13. Msg 8929, Level 16, State 1, Line 1 Object ID 2101582525, index ID 0, partition ID 137729312358400, alloc unit ID 137729312358400 (type In-row data):
  14. Errors found in off-row data with ID 75574870016 owned by data record identified by RID = (1:80165:3) Msg 8964, Level 16, State 1, Line 1 Table error:
  15. Object ID 2101582525, index ID 0, partition ID 137729312358400, alloc unit ID 71913848373575680 (type LOB data). The off-row data node at page (1:75161), slot 43, text ID 69459640320 is not referenced. Msg 8964, Level 16, State 1, Line 1 Table error:
  16. Object ID 2101582525, index ID 0, partition ID 137729312358400, alloc unit ID 71913848373575680 (type LOB data).
  17. The off-row data node at page (1:75161), slot 45, text ID 69459705856 is not referenced.
  18.  
  19. DBCC CHECKTABLE('table_a')
  20. DBCC results for 'incidents_main'. There are 47782 rows in 4683 pages for object "incidents_main". DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Add Comment
Please, Sign In to add comment