Subject | Re: [firebird-support] Rolling back old transactions |
---|---|
Author | Ann W. Harrison |
Post date | 2005-04-19T15:14:44Z |
Rick Debay wrote:
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?
Regards,
Ann
> We had some long running transactions that we were unable to commitIn theory, the server checks with its clients at some interval -
> 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?
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?
Regards,
Ann