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

Server (on Linux) ignores KeepAlive settings, when client connection is lost, the related server connection/process is not killed [CORE6269] #6511

Closed
firebird-automations opened this issue Mar 25, 2020 · 10 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @alexeykovyazin

In a case of abnormal client's disconnect (crash), the server process is not killed, keeping database connection open

Commits: e6159c2

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

reporter: Alexander Peshkov [ alexpeshkoff ] => Alexey Kovyazin [ alexey.kovyazin ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

That should happen on any linux using systemd (instead init + xinetd). systemd (unlike xinetd) does not provide full control of TCP/IP socket to activated by socket daemon - instead in controls that socket itself. Therefore keep alive should be enabled in it's configuration.

PS. No need to frontport to master - we do not start firebird on socket activation since FB4.

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0.6 [ 10889 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @WarmBooter

Any chances of having something like this happening on Windows too? From time to time I find "zombie" connections on Windows servers too, with FB 3.

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Definitely linux-specific issue - there is no xinetd or systemd on windows :-)

@firebird-automations
Copy link
Collaborator Author

Commented by: @WarmBooter

Sure, but I was wondering if there is some unknown bug (in Firebird) contributing for the occurrences of zombies on Windows too.

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

description: In a case of abnormal client's disconnect (crash) firebird process on a server hangs forever keeping connection to database open => In a case of abnormal client's disconnect (crash), the server process is not killed, keeping database connection open

summary: Firebird ignores KeepAlive settings, when client is lost server process hangs forever => Server (on Linux) ignores KeepAlive settings, when client connection is lost, the related server connection/process is not killed

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Cannot be tested

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

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