Error: 605, Severity: 21, State: 1

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Error: 605, Severity: 21, State: 1

Author

Topic

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2005-03-03 : 05:55:16

SQL Server 2K sp3a
WS2K3 on 2 nodes cluster.

This Morning I notify this error on Event Log:

Error: 605, Severity: 21, State: 1
Attempt to fetch logical page (1:6368) in database 'AJL_Credi_PROD01' belongs to object '3670073', not to object 'FATTURA'.

Next I run - dbcc checktable ('fattura') - and this is the result:

Server: Msg 8909, Level 16, State 1, Line 3
Table error: Object ID 3670073, index ID 0, page ID (1:6368). The PageId in the page header = (48:4390960).
Server: Msg 8928, Level 16, State 1, Line 3
Object ID 1538104520, index ID 0: Page (1:6368) could not be processed. See other errors for details.
CHECKTABLE found 0 allocation errors and 1 consistency errors in table '(Object ID 3670073)' (object ID 3670073).
DBCC results for 'FATTURA'.
There are 68027 rows in 2458 pages for object 'FATTURA'.
CHECKTABLE found 0 allocation errors and 1 consistency errors in table 'FATTURA' (object ID 1538104520).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (AJL_Credi_PROD01.dbo.FATTURA ).

Any idea why this happen and how to solve it?
Do I really have to try, as suggested, to use 'repair_allow_data_loss'?
Please advise.

Franco

nr
SQLTeam MVY

12543 Posts

Posted - 2005-03-03 : 06:14:32

Usually happens because of a disk problem.
Try rebuilding the indexes - that usually sorts it out.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2005-03-03 : 09:51:13

Thanks for your suggestion.

I run dbcc checktable repair_fast and dbcc checktable repair_rebuild without success.

So I decide to run dbcc checktable repair_allow_data_loss and SQL Server tells me that he found errors and he was able to repair these errors.

From HW point of view everything in our SAN seems to be in a state of OPTIMAL, so I have no issue on that side.

Thanks again for yout time.

Franco

nr
SQLTeam MVY

12543 Posts

Posted - 2005-03-03 : 10:02:02

I meant dbcc dbreindex.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2005-03-03 : 10:06:57

I know and I have run dbreindex without success.

Franco

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources