Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zeeshanhanif
Starting Member
7 Posts |
 Posted - 2008-06-19 : 03:28:20
|
| when i run query like select * from item where itemid=1476941 it gives me this error ... do ne body know y this happening ??? other itemids works fine.. only this item id creating problem ...Error:Database ID 7, page (1:99330), slot 27 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. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-06-19 : 03:32:10
|
| Are you using the Read Uncommitted isolation level?It might be a transient error, or it might be corruption. Run a checkTable on that table, see what it returnsDBCC CHECKTABLE ('< table name >')--Gail Shaw |
 |
|
|
zeeshanhanif
Starting Member
7 Posts |
Posted - 2008-06-19 : 03:49:45
|
| this DBCC return me back on table "Item"DBCC results for 'Item'.Msg 8961, Level 16, State 1, Line 4Table error: Object ID 504388866, index ID 1, partition ID 72057594075938816, alloc unit ID 72057594101432320 (type LOB data). The off-row data node at page (1:99330), slot 27, text ID 865586905088 does not match its reference from page (1:99327), slot 16.Msg 8929, Level 16, State 1, Line 4Object ID 504388866, index ID 1, partition ID 72057594075938816, alloc unit ID 72057594101497856 (type In-row data): Errors found in off-row data with ID 865586905088 owned by data record identified by RID = (1:99327:12)Msg 8929, Level 16, State 1, Line 4Object ID 504388866, index ID 1, partition ID 72057594075938816, alloc unit ID 72057594101497856 (type In-row data): Errors found in off-row data with ID 865587953664 owned by data record identified by RID = (1:99327:16)There are 857969 rows in 44006 pages for object "Item".CHECKTABLE found 0 allocation errors and 3 consistency errors in table 'Item' (object ID 504388866).repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (justcompareit.dbo.Item).DBCC execution completed. If DBCC printed error messages, contact your system administrator. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-06-20 : 03:24:23
|
| Ouch. You've got corruption. I would suggest you do a CheckDB to make sure no other tables in the DB have been damagedDo you have a recent backup? Do you know how long this corruption has existed?--Gail Shaw |
|
|
|
|
|
|
|
|
DBCC CHECKTABLE