Re: [Firebird-test] Firebird 2.0, corrupting a db

[Andy C. <an...@ca...>]

Pavel Cisar wrote:
> 
> If the new spot gives you the same error then this is definitely somehow 
> connected to tables (header page is assigned to hold table data in 
> Pointer Page). It would be good to know if header page was overwritten 
> by table data or not (in this case only the Pointer Page was mangled. My 
> personal guess is that the page number was not set at all, so it's still 
> zero and zero means header page). Can you try to run gstat -h on 
> corrupted database? If it fails or show weird results, then header was 
> overwritten.

gstat -h worked fine.  Here's some output:


D:\dbs>gbak -b IOWACITY.IB x.bak
gbak: ERROR:database file appears corrupt ()
gbak: ERROR:    wrong page type
gbak: ERROR:    page 0 is of wrong type (expected 5, found 1)
gbak: ERROR:gds_$compile_request failed
gbak:Exiting before completion due to errors

D:\dbs>gstat -h IOWACITY.IB

Database "IOWACITY.IB"
Database header page information:
         Flags                   0
         Checksum                12345
         Generation              1972
         Page size               4096
         ODS version             11.0 type 0200
         Oldest transaction      1966
         Oldest active           1967
         Oldest snapshot         1967
         Next transaction        1970
         Bumped transaction      1
         Sequence number         0
         Next attachment ID      0
         Implementation ID       16
         Shadow count            0
         Page buffers            0
         Next header page        0
         Database dialect        3
         Creation date           Mar 22, 2005 16:36:45
         Attributes

     Variable header data:
         *END*