[firebird-support] Re: Connected users from MON$ATTACHMENT

[Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]]

12.08.2015 21:58, Jeferson Sisto wrote:
>
> 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?

You can use it, unless your clients never disconnect for days/weeks. 
OS-level changes are not required in this case.

> 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?

https://www.ibphoenix.com/resources/documents/how_to/doc_104


Dmitry

Re: [firebird-support] Re: Connected users from MON$ATTACHMENT

[Jeferson Sisto jsis...@gmail.com [firebird-support]]

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.

*Jeferson Sisto*
jsis...@gmail.com
jsis...@yahoo.com.br


2015-08-12 7:23 GMT-03:00 Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] :

>
>
> 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
>
> 
>

[firebird-support] Re: Connected users from MON$ATTACHMENT

[Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]]

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