January 22, 2008 at 7:28 am
Hi,
I am getting the following checktable consistency errors:
dbcc checktable ('Unit')
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_Tracking' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:86) identified by (RID = (1:2082259:86) ArchiveRowID = 43153652) has index values (TRACKINGROWID = 3803312 and ArchiveRowID = 43153652).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_Tracking' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:87) identified by (RID = (1:2082259:87) ArchiveRowID = 43153653) has index values (TRACKINGROWID = 3803312 and ArchiveRowID = 43153653).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_Tracking' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:88) identified by (RID = (1:2082259:88) ArchiveRowID = 43153654) has index values (TRACKINGROWID = 3803312 and ArchiveRowID = 43153654).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_Tracking' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:89) identified by (RID = (1:2082259:89) ArchiveRowID = 43153655) has index values (TRACKINGROWID = 3803312 and ArchiveRowID = 43153655).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_Tracking' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:90) identified by (RID = (1:2082259:90) ArchiveRowID = 43153656) has index values (TRACKINGROWID = 3803312 and ArchiveRowID = 43153656).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_Tracking' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:91) identified by (RID = (1:2082259:91) ArchiveRowID = 43153657) has index values (TRACKINGROWID = 3803312 and ArchiveRowID = 43153657).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_Tracking' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:92) identified by (RID = (1:2082259:92) ArchiveRowID = 43153658) has index values (TRACKINGROWID = 3803312 and ArchiveRowID = 43153658).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_Tracking' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:93) identified by (RID = (1:2082259:93) ArchiveRowID = 43153659) has index values (TRACKINGROWID = 3803312 and ArchiveRowID = 43153659).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_Tracking' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:94) identified by (RID = (1:2082259:94) ArchiveRowID = 43153660) has index values (TRACKINGROWID = 3803312 and ArchiveRowID = 43153660).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_Tracking' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:95) identified by (RID = (1:2082259:95) ArchiveRowID = 43153661) has index values (TRACKINGROWID = 3803312 and ArchiveRowID = 43153661).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_Tracking' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:96) identified by (RID = (1:2082259:96) ArchiveRowID = 43153662) has index values (TRACKINGROWID = 3803312 and ArchiveRowID = 43153662).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_Tracking' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:97) identified by (RID = (1:2082259:97) ArchiveRowID = 43153663) has index values (TRACKINGROWID = 3803312 and ArchiveRowID = 43153663).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_Tracking' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:98) identified by (RID = (1:2082259:98) ArchiveRowID = 43153664) has index values (TRACKINGROWID = 3803312 and ArchiveRowID = 43153664).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_Tracking' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:99) identified by (RID = (1:2082259:99) ArchiveRowID = 43153665) has index values (TRACKINGROWID = 3803312 and ArchiveRowID = 43153665).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_Tracking' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:100) identified by (RID = (1:2082259:100) ArchiveRowID = 43153666) has index values (TRACKINGROWID = 3803312 and ArchiveRowID = 43153666).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_Tracking' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:101) identified by (RID = (1:2082259:101) ArchiveRowID = 43153667) has index values (TRACKINGROWID = 3803312 and ArchiveRowID = 43153667).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_Tracking' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:102) identified by (RID = (1:2082259:102) ArchiveRowID = 43153668) has index values (TRACKINGROWID = 3803312 and ArchiveRowID = 43153668).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_Tracking' (ID 2) for the row:
DBCC results for 'Unit'.
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:103) identified by (RID = (1:2082259:103) ArchiveRowID = 43153669) has index values (TRACKINGROWID = 3803312 and ArchiveRowID = 43153669).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_Tracking' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:104) identified by (RID = (1:2082259:104) ArchiveRowID = 43153670) has index values (TRACKINGROWID = 3803312 and ArchiveRowID = 43153670).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_Tracking' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:105) identified by (RID = (1:2082259:105) ArchiveRowID = 43153671) has index values (TRACKINGROWID = 3803312 and ArchiveRowID = 43153671).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_DetailKeyName' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:86) identified by (RID = (1:2082259:86) ArchiveRowID = 43153652) has index values (DetailKeyName = 'Instructions_verified' and ArchiveRowID = 43153652).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_DetailKeyName' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:87) identified by (RID = (1:2082259:87) ArchiveRowID = 43153653) has index values (DetailKeyName = 'LABOR_TIMER' and ArchiveRowID = 43153653).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_DetailKeyName' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:88) identified by (RID = (1:2082259:88) ArchiveRowID = 43153654) has index values (DetailKeyName = 'LABOR_ENTERED' and ArchiveRowID = 43153654).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_DetailKeyName' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:89) identified by (RID = (1:2082259:89) ArchiveRowID = 43153655) has index values (DetailKeyName = 'D_Quality_Code' and ArchiveRowID = 43153655).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_DetailKeyName' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:90) identified by (RID = (1:2082259:90) ArchiveRowID = 43153656) has index values (DetailKeyName = 'PART_REQUEST' and ArchiveRowID = 43153656).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_DetailKeyName' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:91) identified by (RID = (1:2082259:91) ArchiveRowID = 43153657) has index values (DetailKeyName = 'PART_REPLACED' and ArchiveRowID = 43153657).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_DetailKeyName' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:92) identified by (RID = (1:2082259:92) ArchiveRowID = 43153658) has index values (DetailKeyName = 'PART_REQUEST' and ArchiveRowID = 43153658).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_DetailKeyName' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:93) identified by (RID = (1:2082259:93) ArchiveRowID = 43153659) has index values (DetailKeyName = 'PART_REPLACED' and ArchiveRowID = 43153659).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_DetailKeyName' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:94) identified by (RID = (1:2082259:94) ArchiveRowID = 43153660) has index values (DetailKeyName = 'P_Quality_Code' and ArchiveRowID = 43153660).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_DetailKeyName' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:95) identified by (RID = (1:2082259:95) ArchiveRowID = 43153661) has index values (DetailKeyName = 'P_Quality_Code' and ArchiveRowID = 43153661).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_DetailKeyName' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:96) identified by (RID = (1:2082259:96) ArchiveRowID = 43153662) has index values (DetailKeyName = 'Instructions_verified' and ArchiveRowID = 43153662).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_DetailKeyName' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:97) identified by (RID = (1:2082259:97) ArchiveRowID = 43153663) has index values (DetailKeyName = 'LABOR_TIMER' and ArchiveRowID = 43153663).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_DetailKeyName' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:98) identified by (RID = (1:2082259:98) ArchiveRowID = 43153664) has index values (DetailKeyName = 'LABOR_ENTERED' and ArchiveRowID = 43153664).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_DetailKeyName' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:99) identified by (RID = (1:2082259:99) ArchiveRowID = 43153665) has index values (DetailKeyName = 'PART_REQUEST' and ArchiveRowID = 43153665).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_DetailKeyName' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:100) identified by (RID = (1:2082259:100) ArchiveRowID = 43153666) has index values (DetailKeyName = 'PART_REPLACED' and ArchiveRowID = 43153666).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_DetailKeyName' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:101) identified by (RID = (1:2082259:101) ArchiveRowID = 43153667) has index values (DetailKeyName = 'PART_REQUEST' and ArchiveRowID = 43153667).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_DetailKeyName' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:102) identified by (RID = (1:2082259:102) ArchiveRowID = 43153668) has index values (DetailKeyName = 'PART_REPLACED' and ArchiveRowID = 43153668).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_DetailKeyName' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:103) identified by (RID = (1:2082259:103) ArchiveRowID = 43153669) has index values (DetailKeyName = 'PART_REQUEST' and ArchiveRowID = 43153669).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_DetailKeyName' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:104) identified by (RID = (1:2082259:104) ArchiveRowID = 43153670) has index values (DetailKeyName = 'PART_REPLACED' and ArchiveRowID = 43153670).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Unit' (ID 628377874). Missing or invalid key in index 'IDX_DetailKeyName' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:2082259:105) identified by (RID = (1:2082259:105) ArchiveRowID = 43153671) has index values (DetailKeyName = 'Instructions_verified' and ArchiveRowID = 43153671).
There are 56522753 rows in 537820 pages for object 'Unit'.
CHECKTABLE found 0 allocation errors and 40 consistency errors in table 'Unit' (object ID 628377874).
repair_fast is the minimum repair level for the errors found by DBCC CHECKTABLE (FEP.dbo.Unit)
I ran the comand DBCC DBREINDEX
('Unit'
, [IDX_Tracking]
, 0
) WITH NO_INFOMSGS
but that did not fix the consistecny errors. What would be the best approach to fixing this problem.
Thanks
January 22, 2008 at 9:19 am
Call microsoft PSS. There aren't good tools for the DBA to fix this and you don't want to mess with your data.
You can try rebuilding the clustered index, but if you care about this data, meaning production, call PSS.
January 22, 2008 at 7:23 pm
The base table here is a heap (otherwise the data rows would be identified by cluster key values instead of physical RIDs). The strange thing here is that both non-clustered indexes are missng rows for the same ArchiveRowID range.
I suspect its a bug rather than a corruption issue. Which version are you using? When did the errors start appearing?
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
January 22, 2008 at 11:35 pm
This might help :
INF: List of Bugs Fixed in SQL Server 2000 Service Pack 1 (1 of 2)
http://support.microsoft.com/kb/290212/en-us
"More Green More Oxygen !! Plant a tree today"
January 23, 2008 at 2:05 pm
We are using SQL 2000 (SP3).
The errors started appearing not too long back.
The table actually has a clustered index on ArchiveRowId column
The table has 56 million rows.
January 23, 2008 at 6:41 pm
Yes, of course it does - I missed the key in there (I blame jet-lag - I'm in China this week 🙂
My bet is still a bug. There were several issues with index builds and rebuilds in parallel fixed in various service packs, including SP4. This seems likely to be the case as you've said that rebuilding the indexes don't solve the corruption problem.
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
January 23, 2008 at 10:46 pm
Is it possible to drop that cluster index and recreate it instead of rebuilding it.
"More Green More Oxygen !! Plant a tree today"
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply