Re: [firebird-support] help to repair a corrupted database
Hi. Are you able to backup and restore the database instead of "gfixing"? Em 07/04/2016 12:28, korkl...@yahoo.it [firebird-support] escreveu: hi, i'm trying to repair a corrupted db for firebird 2.5.2, the database file is of about 30 gb. i have disconnected all the user, i did a copy of the file and then i executed the command gfix -validate 'dbname' with the credentials of the user that created the db (not the sysdba) now the gfix process is 90 minutes that is on 0 cpu usage and 1 mb of ram but the firebird process sometime works, is the gfix process freezed or it's normal? can i terminate it and retry or maybe this can add other problems to my database file? thanks -- Atenciosamente, Hugo Eyng
Re: [firebird-support] help to repair a corrupted database
Hi, Gfix visits each page of the database, so 90 minutes is not so long if your disk subsystem is not based SSD. In general, follow these steps http://ib-aid.com/en/articles/how-to-repair-a-corrupt-firebird-database/ Check firebird.log too - gfix reports there its findings. Regards, Alexey Kovyazin IBSurgeon hi, i'm trying to repair a corrupted db for firebird 2.5.2, the database file is of about 30 gb. i have disconnected all the user, i did a copy of the file and then i executed the command gfix -validate 'dbname' with the credentials of the user that created the db (not the sysdba) now the gfix process is 90 minutes that is on 0 cpu usage and 1 mb of ram but the firebird process sometime works, is the gfix process freezed or it's normal? can i terminate it and retry or maybe this can add other problems to my database file? thanks
Re: [firebird-support] help to repair a corrupted database
On Thu, Apr 7, 2016 at 11:28 AM, korkl...@yahoo.it [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > hi, i'm trying to repair a corrupted db for firebird 2.5.2, the database > file is of about 30 gb. > > i have disconnected all the user, i did a copy of the file and then i > executed the command > gfix -validate 'dbname' with the credentials of the user that created the > db (not the sysdba) > > now the gfix process is 90 minutes that is on 0 cpu usage and 1 mb of ram > but the firebird process sometime works, > > is the gfix process freezed or it's normal? > Probably normal. Gfix itself doesn't do much, it just connects to the database with options that cause Firebird to validate the database. > can i terminate it and retry or maybe this can add other problems to my > database file? > I wouldn't terminate it for another couple of hours. It's unlikely that stopping gfix will have adverse effects on the database, though stopping the Firebird server could. What are the symptoms of the corruption? Good luck, Ann