Subject Re: [firebird-support] Rolling back old transactions
Author Ann W. Harrison
Rick Debay wrote:
> We had some long running transactions that we were unable to commit
> because the client was rebooted.
> Looking at the statistics, there is a gap and no one is attached.
> Gfix -l doesn't return anything. Sweep doesn't change anything. We
> ended up restarting the server. Is there any way to close the
> transaction gap besides bouncing the server?

In theory, the server checks with its clients at some interval -
probably controlled by the configuration file. If the client is gone,
the server should be shutting down the connection which will rollback
open transactions. How long did you wait before shutting down the server?