Hi Adam,
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