Subject Re: [ib-support] Corrupt Database
Author Pete Clark
In message <5.1.0.14.2.20021101101103.01df5a70@....
com>, Ann W. Harrison <aharrison@...> writes
>At 12:38 AM 11/1/2002 +0100, Pete Clark wrote:
>
>>I am getting errors whilst trying to backup the Interbase Version WI-
>>V5.5.0.742 database. So I used Interbase Server, Maintenance, Database
>>Validation, founds some errors, told the program to fix them, then
>>backup again. But I still get some errors:
>>
>>gbak: ERROR: database file appears corrupt ()
>>gbak: ERROR: wrong page type
>>gbak: ERROR: page 0 is of wrong type (expected 7, found 1)
>>gbak: ERROR: gds_$receive failed
>>gbak: Exiting before completion due to errors
>
>It sounds as if your database has exceeded 4Gb in a single file,
>causing the byte-offset value to roll over.

No, its 750Mb.

> The result is that
>something has written an index page (7) on page 0 which should
>be the header page (1). The header page then got written back
>over the index page - it gets written a lot. Gbak was following
>an index and discovered the error.

I now suspect user abuse, as in Alt/Ctrl/Del, or switching the PC off,
although of course, no one knows anything about it.

>
>Gbak uses only system indexes - indexes on system tables. Since
>it reads all of every data table, it uses only natural scans of
>user data. So, you've had the bad luck to corrupt a system index.
>The tools distributed won't fix that. With luck you've got a recent
>backup and can move forward from it. Otherwise contact IBSurgeon
>or me.

Thanks for the input. I wondering if I was missing some simple button
to push.. (:->

The database is still working, so I shall export, recreate, and import.

I presume that there is no simple 'create sql file of layout and data'
method for Interbase, because I am planning to do it the long way.

>Regards,
>
>Ann
>www.ibphoenix.com
>We have answers.

--
Pete Clark