Subject Re: [firebird-support] secondary server attachments cannot validate databases during gfix
Author Alexey Kovyazin
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