|Subject||RE: [firebird-support] Database corruption|
> -----Original Message-----Database "fds_corrupt.gdb"
> From: Helen Borrie [mailto:helebor@...]
> Sent: Monday, September 06, 2004 2:44 AM
> >We did a backup/restore on the db when moving to the latest
> version of FB.
> >It has remained a dialect 1 db.
> Was this recent? Could you run a gstat -h just to make sure
> about the ODS version?
Database header page information:
Page size 8192
ODS version 10.1
Oldest transaction 20517
Oldest active 1102144
Oldest snapshot 1102131
Next transaction 1102163
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 2048
Next header page 0
Database dialect 1
Creation date Feb 6, 2004 23:38:29
Attributes force write, no reserve
Variable header data:
Sweep interval: 0
>Yes, I noticed in the Firebird.log that a number of indices are mentioned as
> The error reported by gbak:
> "database file appears corrupt ()
> -wrong page type
> -page 1653541 is of wrong type (expected 7, found 5)"
> indicates a corrupt (possibly empty) index page. If you can
> find out which index it was for, and it is a user index,
> probably dropping the index will fix the problem.
corrupt after running gfix (I keep forgetting that gfix output goes to the
log, not to stdout). Things like:
Index 7 is corrupt on page 1781253 in table RETURN_SALE (142)
Index 7 has orphan child page at page 1781253 in table RETURN_SALE
All in all, looks to be about a dozen indices mentioned. Also found some
entries like this:
Relation has 4 orphan backversions (1071745 in use) in table
Page 1121295 is an orphan