Re: [firebird-support] Database corruption with FB 1.5 on Linux... Please help
Hello Myles, Do backup with the following switches: gbak -b -g -v -ig ... Regards, Alexey Kovyazin IBSurgeon We have a Firebird 1.5 Super Server database on Linux running that decided last week to stop successfully completing a backup with GBAK. After running for about an hour, it fails with the following error: gbak: ERROR: database file appears corrupt () gbak: ERROR: wrong page type gbak: ERROR: page 12726 is of wrong type (expected 7, found 5) gbak: ERROR: gds_$receive failed gbak: Exiting before completion due to errors [Non-text portions of this message have been removed]
[firebird-support] Database corruption with FB 1.5 on Linux... Please help
We have a Firebird 1.5 Super Server database on Linux running that decided last week to stop successfully completing a backup with GBAK. After running for about an hour, it fails with the following error: gbak: ERROR: database file appears corrupt () gbak: ERROR: wrong page type gbak: ERROR: page 12726 is of wrong type (expected 7, found 5) gbak: ERROR: gds_$receive failed gbak: Exiting before completion due to errors I can shutdown the Firebird server, successfully copy the FDB file to another name. The original FDB file seems to be working perfectly well for normal operations, other than this backup problem. When attempting to run GFIX on it, with a -v option, it finds one index page that is bad. When running GFIX with -full option, it returns: Number of record level errors : 5 Number of index page errors : 5 Number of database page errors : 52117 What is the best approach to address this corruption? Thanks in advance for any assistance. Myles
Re: [firebird-support] Database corruption with FB 1.5 on Linux... Please help
Try install fb 2.5 and do a select * from for all your tables. At the end copy the fdb back to your linux server. Em 08/02/2013 16:36, vladman992000 my...@techsol.org escreveu: ** We have a Firebird 1.5 Super Server database on Linux running that decided last week to stop successfully completing a backup with GBAK. After running for about an hour, it fails with the following error: gbak: ERROR: database file appears corrupt () gbak: ERROR: wrong page type gbak: ERROR: page 12726 is of wrong type (expected 7, found 5) gbak: ERROR: gds_$receive failed gbak: Exiting before completion due to errors I can shutdown the Firebird server, successfully copy the FDB file to another name. The original FDB file seems to be working perfectly well for normal operations, other than this backup problem. When attempting to run GFIX on it, with a -v option, it finds one index page that is bad. When running GFIX with -full option, it returns: Number of record level errors : 5 Number of index page errors : 5 Number of database page errors : 52117 What is the best approach to address this corruption? Thanks in advance for any assistance. Myles [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://docs.yahoo.com/info/terms/
Re: [firebird-support] Database corruption with FB 1.5 on Linux... Please help
Try install fb 2.5 and do a select * from for all your tables. At the end copy the fdb back to your linux server. Em 08/02/2013 16:36, vladman992000 my...@techsol.org escreveu: [Non-text portions of this message have been removed]
Re: [firebird-support] Database Corruption
Hello, Consider our Firebird recovery support service: http://ib-aid.com/services/recovery Payment is after successfully recovery. Regards, Alexey Kovyazin IBSurgeon I have a customer database that is returning internal gds software consistency check (applied differences will not fit in record (177)) whenever I access a particular table. I've run gbak with -g switch and it fails on the one particular table I've run it with and without running gfix -v -full before the gbak. It still fails. One thread I found suggested changing the database to read_only before running the gbak command. It still errors with the same message referred to at the top of the post on the same table. In the firebird.log, there is a deadlock error which occurred 90 minutes before the ...applied differences... error. This is a Firebird 1.5 database. Any help is appreciated. [Non-text portions of this message have been removed]
[firebird-support] Database Corruption
I have a customer database that is returning internal gds software consistency check (applied differences will not fit in record (177)) whenever I access a particular table. I've run gbak with -g switch and it fails on the one particular table I've run it with and without running gfix -v -full before the gbak. It still fails. One thread I found suggested changing the database to read_only before running the gbak command. It still errors with the same message referred to at the top of the post on the same table. In the firebird.log, there is a deadlock error which occurred 90 minutes before the ...applied differences... error. This is a Firebird 1.5 database. Any help is appreciated.