Subject Re: [firebird-support] Wrong page type, how to examine/fix?
Author Kjell Rilbe
Den 2014-02-24 13:57 skrev Ann Harrison såhär:
>
>
>
> > On Feb 24, 2014, at 7:24 AM, Kjell Rilbe <kjell.rilbe@...
> >
> > database file appears corrupt
> (D:\DATADIA\DATA\FIREBIRD\BACKUP\DIAMONDS.FDB)
> > -wrong page type
> > -page 12301932 is of wrong type (expected 4, found 7)
> >
> Alas, not a great situation. Page type 4 is a pointer page - an array
> of data page numbers that's one level of indirection in resolving
> record locations. Page type 7 is ani index page. Fortunately, pointer
> pages can be reconstructed from the rest of the database structure. I
> think that the free version of IBFirstAid will tell you which table is
> missing a pointer page. From there, the paid version should be able to
> fix the problem.
>

If the errors are located in a specific index (or unique constraint),
would it be a good idea to drop that index/constraint and try a regular
gbak backup/restore cycle?

And if the errors are located in a table's data pages - drop the table
and do gbak backup/restore?

I did get an indication that it might be in a table I can recreate by
other means...

Regards,
Kjell