[Firebird-devel] [ firebird-Bugs-976756 ] GFIX -force leaves lock on database file - can't restore

[SourceForge.net <no...@so...>]

Bugs item #976756, was opened at 2004-06-21 18:23
Message generated for change (Comment added) made by skidder
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=976756&group_id=9028

Category: Core Engine
Group: Confirmed Bug
Status: Open
Resolution: Accepted
Priority: 5
Submitted By: nealo (nealo)
Assigned to: Nickolay Samofatov (skidder)
Summary: GFIX -force leaves lock on database file - can't restore

Initial Comment:
With GFIX -force, I cannot use GBAK to perform a
restore.  Windows reports the DB file as 'in-use' until
all instances of the firebird clients (that were
connected when the -force was performed) are closed.

I'm using FB 1.5.0.4306 (super server) on winXP sp1

Full description (mostly) as posted in
fir...@ya...:

The -force option for GFIX does not seem to work
correctly. As a result, I am not able to automate the
backup/restore process. I'm just following the
procedure outlined at firebird.sourceforge.net and
posting it here first.

To reproduce the bug:

- use an FB client (I used IBAccess in my test) to
connect to a database using a user other than SYSDBA or
the OWNER
- from a command prompt:

gfix -user "SYSDBA" -password "masterkey" -shut -force
0 <database>

When GFIX completes, the database connection
established in IBAccess can no longer do anything
(expected), but when I try to perform a restore to the
database using GBAK

gbak -R -user "SYSDBA" -password "masterkey" <backup
file> <database>

I get:

gbak: ERROR: could not drop database <database>
(database might be in use)
gbak: Exiting before completion due to errors

If I then close IBAccess, the GBAK call succeeds.


gfix -force does prevent new connections and it does
prevent existing connections from doing anything. But
it seems that the existing connection still keeps a
grip on the database file.


So I can't reliably automate a database backup/restore.
End users have a bad habit of leaving the client
application open overnight.

I don't know if this is a bug with GFIX or with FBServer.

----------------------------------------------------------------------

>Comment By: Nickolay Samofatov (skidder)
Date: 2004-11-18 23:32

Message:
Logged In: YES 
user_id=495356

To the best of my memory while I fixed a bunch of issues
related to database shutdown I did nothing so far to address
this particular problem.

Dmitry, are you sure that the disappeared in Firebird 2.0?

----------------------------------------------------------------------

Comment By: Dmitry Yemanov (dimitr)
Date: 2004-11-17 22:36

Message:
Logged In: YES 
user_id=61270

AFAIU, this is no longer an issue for v2.0, but I'd like
Nickolay to comment.

----------------------------------------------------------------------

Comment By: Philippe Makowski (makowski)
Date: 2004-08-05 13:35

Message:
Logged In: YES 
user_id=483965

I confirm this bug with the 1.5.1 version too

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=976756&group_id=9028