Subject | Re: [firebird-support] secondary server attachments cannot validate databases during gfix |
---|---|
Author | Alexey Kovyazin |
Post date | 2016-03-10T06:45:37Z |
gfix does not validate databases online till 2.5.4.
Update 250 to 255 and try again, or perform recovery operations in exclusive mode.
Use these sequence to repair
https://ib-aid.com/en/articles/how-to-repair-a-corrupt-firebird-database/
Regards,
Alexey Kovyazin
IBSurgeon www.ib-aid.com
Hello Group,
I have a server running Firebird 2.5.0 in Classic mode on Windows.
There is a database that appears corrupted (internal Firebird consistency check ...).
I have got all users out and renamed the file and attempted:
gfix -v localhost:C:\data\corrupt.fdb -user sysdba -password masterke
It is failing with the following message:
bad parameters on attach or create database
-secondary server attachments cannot validate databases
Using Process Explorer, I can see that there are no other processes with a handle to this file. (It is also renamed, and the clients are pointing at the alias which doesn't presently exist)
I suspect that whatever the corruption is, it is confusing gfix into believing that there are other active connections. Is there a way around this?
Thanks
Adam