slow connect from Firebird 3 fbclient to Firebird 2.5 server [CORE4658]

[firebird-automations]

Submitted by: Volker Rehn (vr2_s18)

Is duplicated by JDBC459

Votes: 1

fbclient of build 31529 takes a lot longer than previous versions to connect to Firebird 2.5, around 1 second vs some msecs.
This looks like a IPv4 / IPv6 issue on Windows, because if localhost is defined as 127.0.0.1 in etc/hosts, connects are as fast as with older versions of fbclient. If ::1 is also defined as localhost, connects are slow again.

First reported by Mark Rotteveel on firebird.devel.

Commits: FirebirdSQL/jaybird@879cbd4

[firebird-automations]

Commented by: @mkubecek

This is surprising; if nothing listens on ::1/3050, connect() should fail (almost) immediately; it shouldn't take one second. This looks as if something was blocking the TCP reset (or ICMP port unreachable) sent in response to the SYN packet. But in such case, I would rather expect longer timeout than one second.

[firebird-automations]

Modified by: @dyemanov

Fix Version: 3.0 RC 1 [ 10584 ]

[firebird-automations]

Modified by: @dyemanov

Fix Version: 3.0.0 [ 10048 ]

Fix Version: 3.0 RC 1 [ 10584 ] =>

[firebird-automations]

Commented by: @hvlad

Volker,

could you, please, test it again using current snapshot build ?

[firebird-automations]

Commented by: Volker Rehn (vr2_s18)

No change with build 32144. Still exactly as described above. Test client was Flamerobin with latest fbclient.

[firebird-automations]

Modified by: @dyemanov

Fix Version: 3.0 RC2 [ 10048 ] =>

[firebird-automations]

Commented by: Gilson (windsoft)

In my environment, the connection to firebird 2.5.6 using fbclient.dll 3.0 is very slow too.
After the connection the performance is ok.

[firebird-automations]

Modified by: @mrotteveel

Link: This issue is duplicated by JDBC459 [ JDBC459 ]

[firebird-automations]

Commented by: @mrotteveel

This still happens with the fbclient of 3.0.0 and 3.0.1 releases.

[firebird-automations]

Modified by: @mrotteveel

Version: 3.0.1 [ 10730 ]

Version: 3.0.0 [ 10740 ]

[firebird-automations]

Commented by: Hamish Moffatt (hmoffatt)

I was seeing this on Linux with fbclient 3.0.1 and 3.0.3, and any server 2.5.8 or 3.0.3, when connecting via ::1. When I connect via 127.0.0.1 it is fine. I see a delay of 1 second. However it turns out it was incorrect firewall rules delaying the attempted connection on ::1 from the 3.x client library. When this fails instantly it is fine again. Sorry for the noise but I couldn't delete this comment.