Error 2578

Severity

16

Message text

The first page %ld in sysindexes for table '%.*s' has previous page # %ld in its page header. The previous page # should be NULL. Please check sysindexes.

NoteIn Adaptive Server Enterprise version 15.0 and later, error 9923 (“The first page %ld in syspartitions for partition %ld of table '%.*s' has previous page # %ld in its page header. The previous page # should be NULL”) has replaced error 2578.

Explanation

The syspartitions table lists each table and index partition and the segment where the partition is stored. syspartitions maintains key storage management information, such as the first page of a data or index page chain, the last page of a heap, the root page of an index partition, and so on.

Adaptive Server expects to find a value of zero for the previous page number on the first page for a table (meaning that there are no prior pages in the page chain). Error 2578 is raised when dbcc checktable or dbcc checkdb is run, and the previous page number in the table’s first page is not zero. This error is caused by an incorrect first page value for the table in sysindexes, or corruption in the table’s first page.

Action

If the object with the error is a system table, call Sybase Technical Support. They may be able to help you repair the corruption, but it may be necessary to restore from clean backups.

If the table is a user table, and this is the only error message you see when you run dbcc checktable or dbcc checkdb, it is likely that the table’s first page entry in sysindexes is incorrect. Use one of these options to recover from the problem:

If you see other errors in addition to error 2578, the problem may be more extensive. Follow the instructions in this manual for handling those errors.

Additional information

Before calling Sybase Technical Support, have the information listed in “Reporting errors” available, including the output of dbcc checktable or dbcc checkdb.

Versions in which this error is raised

Version 12.5.x and earlier, and error 9923 in version 15.0 and later