Subject Re: [firebird-support] What happened to opened transaction if the client is abnormally disconnected?
Author Helen Borrie
At 11:49 AM 28/11/2004 +0200, you wrote:

>On Sun, 28 Nov 2004 18:36:27 +1100, I wrote:
>
>
> >
> > When clients crash, or applications don't take proper care of
> > transactions
> > when users log out, the server will eventually detect the lost connection
>
>You say 'eventually'.
>What if server does not detect lost of connection?

It's assumed that it always does detect it - monitoring attachments is part
of what the server does. It will continue listening for a response from a
connection for a set timeout period (the length of which depends on the NOS
configuration), after which it assumes the connection is dead and proceeds
to deal with unfinished transactions from that connection - rolling them
back or flagging them as limbo, according to whether the transactions were
related to just that connection or involved other connections, respectively.

Presumably (and Ann or Pavel can confirm, correct or expand here) the
server won't be in a position to "detect" anything if it crashes
itself. Any unresolved transactions would just disappear in that case,
since all connections would just die and the transaction state bitmap would
be gone.

./heLen