Subject Corrupt database - page is of wrong type...
Author Bob Murdoch
Here's a message I had hoped I would never have to send:

We noticed some missing records in our main data table today. Taking a
look at the interbase.log, I notice an entry from Aug. 22 that stands out
from all of the other "read error=10054" entries:

FL61SQ01 (Server) Thu Aug 22 06:21:01 2002
Database: F:\IB\DELPERF\DELPERF.GDB
database file appears corrupt ()
wrong page type
page 291249 is of wrong type (expected 7, found 5)

However, we hadn't noticed any data or other types of errors until
today. I made a system level backup of the four files that make up this
db, then ran a gfix verify and found no errors. I then tried to backup the
database, and part of the way thru gbak stops and reports the following in
it's log:

gbak: writing data for table XRDS511
gbak: 3190 records written
gbak: writing index XRDS501_IDX
gbak: writing index XRDS501_LOC_IDX
gbak: writing data for table XRDS501
gbak: ERROR: database file appears corrupt ()
gbak: ERROR: wrong page type
gbak: ERROR: page 292250 is of wrong type (expected 7, found 5)
gbak: ERROR: gds_$start_request failed
gbak: Exiting before completion due to errors


I am in the process of running gfix full verify right now, but can anyone
give me a hint as to what I might be facing?

The db is IB 6.01, running on WInNT with forced writes on. The backup that
ran last night was able to complete (I have made a safe copy of that as
well). The db is approaching 3GB, split into four files (the first is
1.9G, the second almost 1G, and the other two haven't started being used yet).

tia for any and all help,

Bob M..