Subject Re: Inactive connection timeout
Author harri007et
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:
> I wouldn't expect telnet to stay alive, it's not a real client.
> Connection timeout is by default 180 (3 minutes) So I would expect
telnet to
> drop in exactly 3 minutes. Telnet can't undestand the haeartbeat.

This was also my question - no I know :)

> what real client are you using which gives you this drop out (other
than telnet).

The following tcpdump is from EMS FB Manager session:
- open database
- open table
- just wait


10:28:01.217264 IP xyz.STARMAN.EE.1242 > firebird.server.ee.6050: S
1475644434:1475644434(0) win 64240 <mss 1460,nop,nop,sackOK>
10:28:01.324330 IP firebird.server.ee.6050 > xyz.STARMAN.EE.1242: S
2569178443:2569178443(0) ack 1475644435 win 5840 <mss 1460,nop,nop,sackOK>
10:28:01.324361 IP xyz.STARMAN.EE.1242 > firebird.server.ee.6050: .
ack 1 win 64240
10:28:01.324438 IP xyz.STARMAN.EE.1242 > firebird.server.ee.6050: P
1:97(96) ack 1 win 64240
10:28:01.342053 IP firebird.server.ee.6050 > xyz.STARMAN.EE.1242: .
ack 97 win 5840
10:28:01.342349 IP firebird.server.ee.6050 > xyz.STARMAN.EE.1242: P
1:17(16) ack 97 win 5840
10:28:01.342419 IP xyz.STARMAN.EE.1242 > firebird.server.ee.6050: P
97:161(64) ack 17 win 64224
10:28:01.342612 IP firebird.server.ee.6050 > xyz.STARMAN.EE.1242: .
ack 97 win 5840
10:28:01.353838 IP firebird.server.ee.6050 > xyz.STARMAN.EE.1242: P
17:49(32) ack 161 win 5840
10:28:01.354044 IP xyz.STARMAN.EE.1242 > firebird.server.ee.6050: P
161:185(24) ack 49 win 64192
10:28:01.376134 IP firebird.server.ee.6050 > xyz.STARMAN.EE.1242: P
49:593(544) ack 185 win 5840
10:28:01.376328 IP xyz.STARMAN.EE.1242 > firebird.server.ee.6050: P
185:205(20) ack 593 win 63648
10:28:01.416062 IP firebird.server.ee.6050 > xyz.STARMAN.EE.1242: P
593:625(32) ack 205 win 5840
/* 650 lines skipped .. */
10:28:30.666657 IP xyz.STARMAN.EE.1242 > firebird.server.ee.6050: P
14077:14085(8) ack 102445 win 63792
10:28:30.731030 IP firebird.server.ee.6050 > xyz.STARMAN.EE.1242: P
102445:102477(32) ack 14085 win 18720
10:28:30.847876 IP xyz.STARMAN.EE.1242 > firebird.server.ee.6050: .
ack 102477 win 63760
10:58:43.879016 IP xyz.STARMAN.EE.1242 > firebird.server.ee.6050: P
14085:14097(12) ack 102477 win 63760
10:58:43.879282 IP firebird.server.ee.6050 > xyz.STARMAN.EE.1242: R
102477:102489(12) ack 14085 win 63760

As you see 10:28:30 was the last info read in. So could you please
tell me, what happens at 10:58:43? Which side actually closes
connection? I bet server ..
Google gave me only one idea - linux (iptables) firewall drops
inactive connections from MASQ table. But Firebird server is running
on public ip/port.

regards,
Harri