Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
firebird-automations opened this issue Jan 4, 2015 · 11 comments

Comments

@firebird-automations
Copy link
Collaborator

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
Copy link
Collaborator Author

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
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 RC 1 [ 10584 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0.0 [ 10048 ]

Fix Version: 3.0 RC 1 [ 10584 ] =>

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Volker,

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

@firebird-automations
Copy link
Collaborator Author

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
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 RC2 [ 10048 ] =>

@firebird-automations
Copy link
Collaborator Author

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
Copy link
Collaborator Author

Modified by: @mrotteveel

Link: This issue is duplicated by JDBC459 [ JDBC459 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @mrotteveel

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @mrotteveel

Version: 3.0.1 [ 10730 ]

Version: 3.0.0 [ 10740 ]

@firebird-automations
Copy link
Collaborator Author

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant