Hi,

I have a very big problem. I need to disconnect non SYSDBA users from the database from time to time, I do it with gfix shut.

"C:\Program Files\Firebird\Firebird_2_1\bin\gfix" -user SYSDBA -password anypass D:\XTrack_usluga\baza\XTRACK1_5.FDB -shut single -force 30

As I have some design issues I know that some connections/transactions are canceled (that's why force is needed). The problem is that I cant bring the database online (I need to restart server!).

I try to bring it online with command like this:
"C:\Program Files\Firebird\Firebird_2_1\bin\gfix" -user SYSDBA -password anypass D:\XTrack_usluga\baza\XTRACK1_5.FDB -online normal


The message I get is:
lock conflict on no wait transaction
-database D:\XTrack_usluga\baza\XTRACK1_5.FDB shutdown

I use Firebird 2.1.1 Classic server, I had the same problem with 2.0.4 CS

Please help!

Thanks
Piotr