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

Alexey Kovyazin


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?