[firebird-support] RE: unsubscribe

 

unsubscribe

 

Regards,

 

Hardware Refresh Team

 

 

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 04 April 2016 07:42
To: firebird-support@yahoogroups.com
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

 

Cheers,

 

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.

__._,_.___

---

Posted by: Hasnain Najafi <hasnain.najafi@boots.co.uk>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? The Yahoo Mail app is fast, beautiful and intuitive. Try it today!

---

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___