Thursday, 7 April 2016

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


__._,_.___

Posted by: Alexey Kovyazin <ak@ib-aid.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)

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/

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

.

__,_._,___

No comments:

Post a Comment