Sent: Monday, December 06, 2004 12:09 PM
Subject: RE: [firebird-support] About the subject "Transaction is still active after client crash and restart"

>
> At 12:27 PM 6/12/2004 +0200, you wrote:
>
> >... where some user cancelled a query abnormaly, next time user connecting,
> >appears an error such as "record locked by another user".
> >Environment ;
> >Win2000 Server
> >FB Super Server 1.5 (last stable ver.)
> >Delphi 7
> >FIB Components
>
> That's normal, as-designed behaviour. If the application doesn't get the
> chance to commit or cancel pending inserts, updates or deletes, because the
> user uses the 3-finger salute, it will be approximately 10 minutes before
> the server detects that the connection is gone for good and will flag the
> transaction as rolled back.
>
> So - if your user flashes up a fresh instance of the client application
> straight away, and tries to do something to the same rows that s/he left
> behind, s/he will find them locked until the server has done this detection
> and cleanup.

Is there any setting for how long does it take for server to detect
that the transaction is dead ?
Or is it just build into server?

Pawel

_________________________________________________________________
List sprawdzony skanerem poczty mks_vir ( http://www.mks.com.pl )