Subject Re: [firebird-support] Re: Connected users from MON$ATTACHMENT
Author Jeferson Sisto
Post date 2015-08-12T18:58:57Z
Jeferson said:
>> I already try to do it, but when a connection from a client (another
>> machine) is ended abnormally (for example, turn off the machine or
>> disconnect the cable of network), this connection still stay on system
>> table "MON$ATTACHMENT".

Dmitry said:
>It's because the connection is still really alive, the server has no 
>idea that it was terminated from the other side. You need to configure 
>either the TCP keepalive interval at the OS level or enable 
>DummyPacketInterval in firebird.conf, so that such forced disconnects 
>were detected faster by the server.


Thank Dmitry,

I read the firebird.conf and the article in Microsoft site. Please, help me again:

1) In firebird.conf, in session about parameter DummyPacketInterval, there is a warning "DO NOT USE THIS OPTION". I can or cannot use this parameter? This parameter only can be used  with the changes in OS, quoted in the Microsoft article?

2) About OS, our customers uses Microsoft Windows. I read the documentation and I understand (or I guess) that the unique parameter that I should add in Windows Register is KeepAliveInterval. Is it right? Are mandatory the other two parameters?

Sorry about so many questions, but this configuration is not my daily job (I'm a Delphi/C# programmer).

Thank you.


2015-08-12 7:23 GMT-03:00 Dmitry Yemanov dimitr@... [firebird-support] <firebird-support@yahoogroups.com>:
 

11.08.2015 23:42, Jeferson Sisto wrote:

> I already try to do it, but when a connection from a client (another
> machine) is ended abnormally (for example, turn off the machine or
> disconnect the cable of network), this connection still stay on system
> table "MON$ATTACHMENT".

 It's because the connection is still really alive, the server has no
idea that it was terminated from the other side. You need to configure
either the TCP keepalive interval at the OS level or enable
DummyPacketInterval in firebird.conf, so that such forced disconnects
were detected faster by the server.

Dmitry