20.06.2013 17:21, Veselin Pavlov пишет: > Hi all, > > We are experiencing problems with unreceived db events. > After some investigation found out that the connection to the event > (aux) port from the client to the server is lost and the client never > understands about that. > Many routers and firewalls automatically close idle connections after a > certain period of time and we suspect this is the reason which makes > event connection to be lost sometimes. > > Is there a way to detect the lost connection
I copyNpaste a comment from appropriate part of pre-fb3 code: "//This is error condition, but we have absolutely no ways to report it." What about fb3 - please add a ticket to the tracker, I will extend API to make error reporting possible. > or better prevent it from > being closed. Tune keepalive timeout. Making it 2 minutes instead 2 hours is OK for networks in 2013. Packets will travel. > For the db connection we are successfully using DummyPacketInterval but > it does not affect the event connection. This is also worth going to the tracker, better with reproducible test case. > The server is on Linux. > /proc/sys/net/ipv4/tcp_keepalive_time is 7200 > /proc/sys/net/ipv4/tcp_keepalive_intvl is 75 > /proc/sys/net/ipv4/tcp_keepalive_probes is 9 > RemoteAuxPort is set to permanent value. > yes-yes - 30 years old defaults :) ------------------------------------------------------------------------------ This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
