DBCC CHKDB Error - Error 8964 - SQL Server Forums

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

General SQL Server Forums

Data Corruption Issues

DBCC CHKDB Error - Error 8964

Author

Topic

wangkt
Starting Member

2 Posts

Posted - 2005-09-06 : 09:35:21

I got a error message with SQL 2000 SP3. I do not know this is a bug or table is real corrupted. need help with this one.

(1) DBCC CHKDB output:

Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'TAMVSQLNYU\NYU' as 'NYUMC\tamnyuclustadmin' (trusted)
Starting maintenance of database 'PowerPath_NYU' on 9/6/2005 4:20:03 AM
[1] Database PowerPath_NYU: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8964: [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 405628538. The text, ntext, or image node at page (1:1001056), slot 10, text ID 1595707686912 is not referenced.
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in table 'audit_record' (object ID 405628538).
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in database 'PowerPath_NYU'.
[Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (PowerPath_NYU ).

The following errors were found:

[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 405628538. The text, ntext, or image node at page (1:1001056), slot 10, text ID 1595707686912 is not referenced.
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in table 'audit_record' (object ID 405628538).
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in database 'PowerPath_NYU'.
[Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (PowerPath_NYU ).
** Execution Time: 0 hrs, 2 mins, 20 secs **

[2] Database PowerPath_NYU: Check Data and Index Allocation...
WARNING: Database PowerPath_NYU is currently being used by 36 user(s).
This may cause spurious problems to be reported.

** Execution Time: 0 hrs, 0 mins, 1 secs **

[3] Database PowerPath_NYU: Check System Data...

** Execution Time: 0 hrs, 0 mins, 3 secs **

Deleting old text reports... 1 file(s) deleted.

End of maintenance for database 'PowerPath_NYU' on 9/6/2005 4:22:27 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)

I also run DBCC CHKTABLE and follwoing is the output.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 405628538. The text, ntext, or image node at page (1:1001056), slot 10, text ID 1595707686912 is not referenced.
DBCC results for 'audit_record'.
There are 1958345 rows in 42549 pages for object 'audit_record'.
CHECKTABLE found 0 allocation errors and 1 consistency errors in table 'audit_record' (object ID 405628538).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (PowerPath_NYU.dbo.audit_record ).

Thanks,
KT

ryanston
Microsoft SQL Server Product Team

89 Posts

Posted - 2005-09-06 : 12:13:33

This is a legitimate corruption. Essentially what's happening is that a node in a text tree has been left orphaned for some reason, and has no references from other structures in the table.

How long has this problem been around? Have you had any hardware problems lately? Can you do a select from this table (forcing either the clustered index or heap) without error? Have you dropped or added LOB columns to your table lately?

Your options at this point are to restore your last known good backup, or to run repair (a last resort). DBCC repair will deallocate this text node, and you will lose data if it is supposed to be linked into a table.

Thanks,

----------------------
Ryan Stonecipher
Developer, Microsoft SQL Server Storage Engine, DBCC
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

wangkt
Starting Member

2 Posts

Posted - 2005-09-08 : 14:45:49

Tahnks, Rayn.
This table only has one cluster index. I can select * from audit_record without a problem. I tried the following stepes:
(1) select * into kttest from aduit_record without any problem. Both table have same record.
(2) Drop cluster index and recreated - still same ERROR
(3) DBCC CHECKTABLE('audit_record',REPAIR_FAST) can not fix this problem.
(4) DBCC CHECKTABLE('audit_record',REPAIR_ALLOW_DATA_LOSS) can fix the problem. But when I select count(*) from audit_record still same record as before.

ryanston
Microsoft SQL Server Product Team

89 Posts

Posted - 2005-09-08 : 15:28:26

quote:
Originally posted by wangkt

Tahnks, Rayn.
This table only has one cluster index. I can select * from audit_record without a problem. I tried the following stepes:
(1) select * into kttest from aduit_record without any problem. Both table have same record.
(2) Drop cluster index and recreated - still same ERROR
(3) DBCC CHECKTABLE('audit_record',REPAIR_FAST) can not fix this problem.
(4) DBCC CHECKTABLE('audit_record',REPAIR_ALLOW_DATA_LOSS) can fix the problem. But when I select count(*) from audit_record still same record as before.

REPAIR_ALLOW_DATA_LOSS will simply deallocate the orphaned text page, so I wouldn't expect you to see fewer rows in your user table. If no other errors are in the database, and the integrity of your user data is in tact, then you're set :)

Thanks,

----------------------
Ryan Stonecipher
Developer, Microsoft SQL Server Storage Engine, DBCC
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources