| Subject | Re: [firebird-support] About the subject "Transaction is still active after client crash and restart" |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-12-06T14:32:03Z |
At 02:48 PM 6/12/2004 +0100, you wrote:
parameters, both default and options. You can pick up the release notes in
many languages from the IBPhoenix website. The actual configuration file is
firebird.conf and it is also well annotated.
Understanding how transactions behave is more of a skill you need to have
been born with. :-) IMO, one of the most useful descriptions of
transactions at work to be found among the free documentation is in the
EmbedSQL.pdf book of the Borland IB6 doc set. You can easily google for a
download source for this. The relevant free TI sheets at
www.objects.com/TechInfo.html should be helpful, too, even if you are not
using Delphi or BCCB.
./hb
>----- Original Message -----Yes. The release notes comprehensively explain the configuration
>From: "Helen Borrie" <helebor@...>
>To: <firebird-support@yahoogroups.com>
>Sent: Monday, December 06, 2004 2:27 PM
>Subject: Re: [firebird-support] About the subject "Transaction is still
>active after client crash and restart"
>
>
> >
> > At 01:05 PM 6/12/2004 +0100, you wrote:
> >
> > >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?
> >
> > Yes and Yes. :-)
> >
> > From firebird.conf:
> > # Normally, Firebird uses SO_KEEPALIVE socket option to keep track of
> > # active connections. If you do not like default 2-hour keepalive timeout
> > # then adjust your server OS settings appropriately. On UNIX-like OS's,
> > # modify contents of /proc/sys/net/ipv4/tcp_keepalive_*. On Windows,
> > # follow instructions of this article:
> > # http://support.microsoft.com/default.aspx?kbid=140325
> >
>Dear Helen,
>thank you a lot for your support.
>I'm quite new to this group, so maybe there is any FAQ to read before
>posting silly questions?
parameters, both default and options. You can pick up the release notes in
many languages from the IBPhoenix website. The actual configuration file is
firebird.conf and it is also well annotated.
Understanding how transactions behave is more of a skill you need to have
been born with. :-) IMO, one of the most useful descriptions of
transactions at work to be found among the free documentation is in the
EmbedSQL.pdf book of the Borland IB6 doc set. You can easily google for a
download source for this. The relevant free TI sheets at
www.objects.com/TechInfo.html should be helpful, too, even if you are not
using Delphi or BCCB.
./hb