469,568 Members | 1,580 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,568 developers. It's quick & easy.

index corruption issues

We are having some troubles with corrupt indexes on our SQL 2000
dbase.

It is only affecting 2 tables out of about 150 we have.

These 2 tables are heavily used.

We have run dbcc repairs; dropped and recreated indexes but the
problem persists

Is it possible that this ongoing problem is indicative of a hardware
problem.

If so how could we diagnose this?

here is a sample of the dbcc check against one of the tables whose
indexes we are having trouble with:

thanks

J.C. Clay

Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'page_views' (ID 1436024347). Missing or invalid
key in index 'IX_sessionid' (ID 7) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:42151:27) identified by (RID = (1:42151:27) ) has index
values (session_id = B89F855E-CBB7-4874-A3BD-8D8827ED1481@_).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'page_views' (ID 1436024347). Missing or invalid
key in index 'IX_page_views_nav' (ID 8) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:42151:27) identified by (RID = (1:42151:27) ) has index
values (navigation_id = A9E17BF3-41A6-43EF-8FD6-15C5B5E5E744@_).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'page_views' (ID 1436024347). Missing or invalid
key in index 'IX_page_views_tab_nav' (ID 10) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:42151:27) identified by (RID = (1:42151:27) ) has index
values (tab_navigation_id =
6373D50E-EF0B-4084-B8A7-032653E262E2@_).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'page_views' (ID 1436024347). Missing or invalid
key in index 'IX_page_view_id' (ID 11) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:42151:27) identified by (RID = (1:42151:27) ) has index
values (page_view_id = 431E5427-A688-4957-967B-A3466799D94E@_).
DBCC results for 'page_views'.
There are 958422 rows in 54595 pages for object 'page_views'.
CHECKTABLE found 0 allocation errors and 4 consistency errors in table
'page_views' (object ID 1436024347).
repair_fast is the minimum repair level for the errors found by DBCC
CHECKTABLE (profound.dbo.page_views ).
Jul 20 '05 #1
1 6379
bi********@yahoo.com (J. C. Clay) wrote in message news:<30**************************@posting.google. com>...
We are having some troubles with corrupt indexes on our SQL 2000
dbase.

It is only affecting 2 tables out of about 150 we have.

These 2 tables are heavily used.

We have run dbcc repairs; dropped and recreated indexes but the
problem persists

Is it possible that this ongoing problem is indicative of a hardware
problem.

If so how could we diagnose this?

here is a sample of the dbcc check against one of the tables whose
indexes we are having trouble with:

thanks

J.C. Clay

Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'page_views' (ID 1436024347). Missing or invalid
key in index 'IX_sessionid' (ID 7) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:42151:27) identified by (RID = (1:42151:27) ) has index
values (session_id = B89F855E-CBB7-4874-A3BD-8D8827ED1481@_ ).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'page_views' (ID 1436024347). Missing or invalid
key in index 'IX_page_views_nav' (ID 8) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:42151:27) identified by (RID = (1:42151:27) ) has index
values (navigation_id = A9E17BF3-41A6-43EF-8FD6-15C5B5E5E744@_ ).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'page_views' (ID 1436024347). Missing or invalid
key in index 'IX_page_views_tab_nav' (ID 10) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:42151:27) identified by (RID = (1:42151:27) ) has index
values (tab_navigation_id =
6373D50E-EF0B-4084-B8A7-032653E262E2@_ ).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'page_views' (ID 1436024347). Missing or invalid
key in index 'IX_page_view_id' (ID 11) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:42151:27) identified by (RID = (1:42151:27) ) has index
values (page_view_id = 431E5427-A688-4957-967B-A3466799D94E@_ ).
DBCC results for 'page_views'.
There are 958422 rows in 54595 pages for object 'page_views'.
CHECKTABLE found 0 allocation errors and 4 consistency errors in table
'page_views' (object ID 1436024347).
repair_fast is the minimum repair level for the errors found by DBCC
CHECKTABLE (profound.dbo.page_views ).


It looks like you're using uniqueidentifier values, so you might be
seeing this issue:

http://support.microsoft.com/default...b;en-us;284440

Simon
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Richard Bailey | last post: by
7 posts views Thread by Fred MacMurray | last post: by
6 posts views Thread by Mike | last post: by
5 posts views Thread by Upendra Agnihotram | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.