Subject Re: [firebird-support] inactive transactions
Author Douglas Tosi
On Tue, Dec 23, 2008 at 4:31 PM, Sergio H. Gonzalez
<shg_sistemas@...> wrote:
> Hello I have a customer who uses my app remotelly trough Terminal Server.
> Often
> happens that the conection fails and if my app had an active transaction, it
> stays open forever...
> I'm using FB2.1 How can I terminate those transactions? So far I'm stopping
> FB
> and starting it again. Is there other safe way to terminate that
> transactions?
> What happen is I just delete the records on the system table
> It is a good way to stop all transactions?

Starting from FB2.5 you will be able to drop the attachment
responsible for the transaction.
Aside from that there is no other easy way that I know of.

FWIW, your transactions should not be open forever. The server is
supposed to detect dropped connections and roll back their
transactions. You may want to look into why yours is not doing it. May
be some OS-level TCP setting, or some parameter in firebird.conf.

Douglas Tosi