Error 7928

Severity

16

Message text

Index %.*s is not consistent; found %ld leaf rows but %ld data rows.  Drop and recreate the index.

Explanation

This error is returned by dbcc checktable or dbcc checkdb (which calls dbcc checktable). When checking the integrity of a nonclustered index, checktable compares the leaf row count (the total number of rows in the leaf pages for the index) with the count of data rows. Error 7928 is raised when the leaf row count does not match the data row count, and indicates an index problem.

Action

Correct the problem by re-creating the index as follows:

  1. Check the output of the dbcc query to identify the table associated with the index.

  2. If the table is a system table, refer to “Fixing a corrupted system table index” in the chapter “Other Useful Tasks” in the most recent version of Troubleshooting and Disaster Recovery for instructions on how to repair the system table index, then go to step 4.

  3. If the table is a user table, take these steps:

    • Run sp_helpindex on the index to ensure that the information needed to re-create the index is available.

    • Drop the index.

    • Re-create the index.

  4. Run dbcc checktable on the table to verify that the corruption is gone. If the corruption still exists, call Sybase Technical Support.

Versions in which this error is raised

All versions