Subject RE: [firebird-support] Database restore failure
Author Rick Debay
Thanks for the quick reply. We'll know the results in ninety minutes.

-----Original Message-----
[] On Behalf Of Ann Harrison
Sent: Wednesday, May 09, 2012 4:49 PM
Subject: Re: [firebird-support] Database restore failure


A database restore failed. Does anyone know what these errors mean, and
> what we can do to prevent this from happening again?
> /* backup */
> gbak -GARBAGE_COLLECT -b rxsaccessdb:accessrxs
> /usr/backup/firebird/accessrxs.fbk
> /* test restore */
> gbak -v -se it-test:service_mgr -use_all_space -r
> /opt/firebird/db/accessrxs.fbk /opt/firebird/db/accessrxs_3.fdb
> gbak: 47330000 records restored
> gbak: adjusting an invalid decompression length from 78 to 73
> gbak: 47333043 records restored
> gbak: do not recognize table attribute 0 -- continuing ...
> gbak: do not recognize table attribute 0 -- continuing
> gbak: ERROR: string truncated
> gbak: Exiting before completion due to errors
What that means is that the gbak file is corrupt. The first message
"adjusting an invalid decompression length from 78 to 73" is an attempt
correct the error, hoping that ignoring some minor problem will let the
rest of the restore succeed. No such luck. Elements in the backup file
are tagged with attribute numbers which determine how the element should
expanded. There is no attribute zero.

I notice that you seem to have done a test restore, which is a very good
thing. What I would do next is backup the database again and retry the
restore. With any luck, that will succeed and you might look in the
log for write errors on the previous backup file. If the second try
fails, if I were you, I'd get a copy of IBBackupSurgeon and let it tell
what went wrong. Of course, being me, what I'd actually do is build a
debugging gbak and get my answers from there, but you'll save a lot of
with a good tool.

Good luck,


Disclaimer: This message (including attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. RxStrategies, Inc. shall not be liable for the improper or incomplete transmission of the information contained in this communication or for any delay in its receipt or damage to your system. RxStrategies, Inc. does not guarantee that the integrity of this communication has been maintained nor that this communication is free from viruses, interceptions or interference.