Subject Re: [firebird-support] Reasons for a wrong page type
Author Ann W. Harrison
Josef Gschwendtner wrote:
> Hi,
>
> what type of action / problem can (theoretically) lead to a wrong page
> type (Firebird 1.03 SS)?
> (i.e expected 5, found 0)
>

Hmmm.... crash with forced writes off, leaving pages unwritten?
Probably not, you'd get a checkpoint error before it reported the bad
page. Of course, if you told gfix to ignore checksum errors, you could
see expected 5 found 0.

Someone or something overwrote part of the database with zeros? I've
seen that on databases that had been through disk-recovery programs
after a disk corruption. Unfortunately type 5 is a data page so you'll
have lost something. If it expected a 7 (internal index page) gbak
might have been able to salvage the database. As is, the best hope is
to pump data out.

Regards,


Ann