Subject RE: unsubscribe
Author Hasnain Najafi





Hardware Refresh Team



From: []
Sent: 04 April 2016 07:42
Subject: [firebird-support] db corruption



Hi everyone.


Due to some failing hardware and my tardiness to move the FB server elsewhere, our development databases have become corrupt.


This isn’t a big deal as we/I can create new ones (the metadata has been backed up and we have plenty of client data to use), but I have taken it as a challenge to learn more about recovering a corrupt database.


I have used gfix and gbak, as well as DBWorkbench but try as I might, I cannot repair the database.


For both databases while running gbak:

gbak -user sysdba -password masterkey -b -ig -l corrupt.fdb corruptbak.fbk –v

I get the error:

gbak: ERROR:internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp l

ine: 239)

gbak: ERROR:gds_$receive failed

gbak:Exiting before completion due to errors

gbak: ERROR:internal Firebird consistency check (can't continue after bugcheck)


When I run gfix on both:

gfix -user sysdba -password masterkey -validate -full -no_update corrupt.fdb

I get the error:

internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)


For those in the know, is this a recoverable error? 

Should I cut my losses and create a new DB?

Any tips or tricks I could try?


I can pump some (most) of the data from them but hit errors on some tables (unfortunately large important ones) .  One DB is 1.3Gb, the other is over 11Gb.


I am using WI-V2.5.3.26780 Firebird 2.5 ODS 11.2




Andrew Zenz




Boots UK Limited, Registered 928555, Nottingham NG2 3AA This e-mail (including any attachments) is confidential. It may be read, copied and used only by the intended recipient. If you are not the intended recipient you should not copy it or use it for any purpose or disclose its contents to any other person. If you have received this message in error, please notify us and remove it from your system. We cannot accept liability for any damage you incur as a result of virus infection.