Subject Re: *.FDB Lock Not Released when Process Shuts Down
Author Roger Crämer
--- In firebird-support@yahoogroups.com, "megankmeyer"
<meyerme13@h...> wrote:
> Our project is using FB 1.5 as a backend for a general logging
> application. We've come across an issue where when our application
> process is shutdown that the FB Server does not let go of the lock on
> the database file.
>
> Has anyone experienced a similar issue or might have suggestions for
> troubleshooting/fixing the problem?
>
> Thanks in advance,
> ~Megan

Hi,

there seems to be a similar problem with Superserver.
When there's a connection to the database from a 'normal' user (i.e. not
sueruser or database owner) and the database is shut down using
'gfix -shut -f <n>' at least after <n> seconds the user cannot use
the database anymore.
But the Superserver locks the database file until the applicaton that
held the database connection has been terminated.
This happened first with our own application and we could reproduce
that using 'isql'.

Our actual solution to solve that problem is to first send the
'gfix -shut -f' and then shut down the Superserver.

Roger