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 |
|
manjot
Starting Member
1 Post |
 Posted - 2008-03-17 : 23:34:38
|
| Hi,I am getting this error on my indexing job:[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Database 'mmv6', index 'Message.IX_To' (ID 2137058649) (index ID 5). Extra or invalid key for the keys:[Microsoft][ODBC SQL Server Driver][SQL Server]Index row (1:4341703:43) with values (RecipientUser = 'vfckrkwgn' and TimeLogged = Feb 7 2008 12:47PM and BlockNumber = 78799731425287 and BlockRecipientIndex = 1) points to the data row identified by ().[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consiste.....i run the dbcc checktable('Message') -- where message is my table name' and it showed :DBCC results for 'Message'.There are 47634600 rows in 2260742 pages for object 'Message'.DBCC execution completed. If DBCC printed error messages, contact your system administrator.The cluster is made as:USE [mmv6]GO/****** Object: Index [IX_To] Script Date: 03/18/2008 15:39:25 ******/CREATE NONCLUSTERED INDEX [IX_To] ON [dbo].[Message] ( [RecipientUser] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]the data row is:2008-02-07 12:47:59.000 78799731425287 0 B47aafdf50001 2 2343 Tax Refund (Message ID J8N923B) 2008-02-07 12:47:49.000 refunds-tax irs.org 0 000000000001 0 11 (550 Requested action not taken: mailbox unavailable) vfckrkwgn hotmail.com 0 0 0 -34275322 0 1 NULL 0 0 NULLAny suggestions? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-21 : 00:55:51
|
| I'll recreate that index then run dbcc again in this case. |
 |
|
|
|
|
|
Corrupted non-clustered index