Re: [firebird-support] Database/Table Corruption
Hello, before you try FirstAID, download IBPump and try to pump all data to the new database with the same structure. Regards, Alexey Kovyazin IBSurgeon On 27.12.2019 22:49, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: Hello. FB 2.5.7 Windows 10 64 bits Page size 4096 I am facing some dificulties to backup and restore a corrupted DB. I searched the Internet to find some help and tried everthing I read. I already tried "gfix -full - mend" and did not work. gbak -B -V -user SYSDBA -password masterkey MYDB.FDB MYDB.FBK . . gbak:46 records written gbak: ERROR:internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 239) gbak: ERROR:gds_$receive failed gbak:Exiting before completion due to errors gbak: ERROR:internal Firebird consistency check (can't continue after bugcheck) I already dropped the table that causes this message but than the error occurs ahead. ... . . gbak:writing table constraints gbak:writing constraint INTEG_1 gbak:writing constraint INTEG_2 gbak:writing constraint INTEG_3 gbak:writing constraint INTEG_4 gbak:writing constraint INTEG_5 gbak:writing constraint INTEG_6 gbak:writing constraint INTEG_7 gbak:writing constraint INTEG_8 gbak:writing constraint INTEG_9 gbak:writing constraint INTEG_10 gbak:writing constraint INTEG_11 gbak:writing constraint INTEG_12 gbak:writing constraint INTEG_13 gbak:writing constraint INTEG_14 gbak:writing constraint INTEG_15 gbak:writing constraint INTEG_16 gbak:writing constraint INTEG_17 gbak: ERROR:internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 239) gbak:Exiting before completion due to errors gbak: ERROR:internal Firebird consistency check (can't continue after bugcheck) Any help will be apreciated. Atenciosamente, + + Hugo Eyng + +
Re: [firebird-support] Database/Table Corruption
On 27/12/2019 20:49, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > FB 2.5.7 > Windows 10 64 bits > Page size 4096 I'd suggest upgrading to 2.5.9 and see if that fixes the problem. Both in 2.5.8 and 2.5.9, bugs with gbak were fixed. Those bug fixes don't match the description of this problem, but it never hurts to try with a newer version. > I am facing some dificulties to backup and restore a corrupted DB. I > searched the Internet to find some help and tried everthing I read. > > I already tried "gfix -full - mend" and did not work. It should be -mend, not - mend. However, did you read all the caveats about using -mend in the gfix documentation[1] as it can cause loss of data? However, did gfix output any information about problems? Preferably start with gfix -validate -full -no_update then move to gfix -validate -full and only use gfix -mend as a last resort (and make a copy of the database before running it!). [1]: https://firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-dbverify.html -- Mark Rotteveel
Re: [firebird-support] Database/Table Corruption
27.12.2019 20:49, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Any help will be apreciated. http://www.ibphoenix.com/services/repair https://ib-aid.com/en/firebird-interbase-recovery-service/ -- WBR, SD. ++ 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/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Database/Table Corruption
Hello. FB 2.5.7 Windows 10 64 bits Page size 4096 I am facing some dificulties to backup and restore a corrupted DB. I searched the Internet to find some help and tried everthing I read. I already tried "gfix -full - mend" and did not work. gbak -B -V -user SYSDBA -password masterkey MYDB.FDB MYDB.FBK . .. .. . gbak:46 records written gbak: ERROR:internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 239) gbak: ERROR:gds_$receive failed gbak:Exiting before completion due to errors gbak: ERROR:internal Firebird consistency check (can't continue after bugcheck) I already dropped the table that causes this message but than the error occurs ahead. . .. .. gbak:writing table constraints gbak:writing constraint INTEG_1 gbak:writing constraint INTEG_2 gbak:writing constraint INTEG_3 gbak:writing constraint INTEG_4 gbak:writing constraint INTEG_5 gbak:writing constraint INTEG_6 gbak:writing constraint INTEG_7 gbak:writing constraint INTEG_8 gbak:writing constraint INTEG_9 gbak:writing constraint INTEG_10 gbak:writing constraint INTEG_11 gbak:writing constraint INTEG_12 gbak:writing constraint INTEG_13 gbak:writing constraint INTEG_14 gbak:writing constraint INTEG_15 gbak:writing constraint INTEG_16 gbak:writing constraint INTEG_17 gbak: ERROR:internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 239) gbak:Exiting before completion due to errors gbak: ERROR:internal Firebird consistency check (can't continue after bugcheck) Any help will be apreciated. Atenciosamente, + + Hugo Eyng + +