Issue Details (XML | Word | Printable)

Key: CORE-6341
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: Jaro
Votes: 0
Watchers: 3
Operations

If you were logged in you would be able to see more operations.
Firebird Core

The server maintains inactive TCP connections

Created: 23/Jun/20 06:34 PM   Updated: 24/Jun/20 03:50 PM
Component/s: Engine
Affects Version/s: 2.5.9
Fix Version/s: None

Environment:
ServerClass - SUPER SERVER
ServerVersion - LI-V2.5.4.26856 Firebird 2.5

QA Status: No test


 Description  « Hide
I have a very simple application that:
  - connects to the Firebird server,
  - execute the SELECT COUNT (*) FROM MON $ ATTACHMENTS command
  - closes the connection

1) I run the first copy of the application - result 1
2) I run the second copy of the application - result 2
3) I close the second copy of the application - result 1
4) I run the second copy of the application - result 2

Everything works fine.

5) restart router - I close the connection by force
6) I close all copies of the application
7) I run the first copy of the application - result 3 - ???

The server maintains inactive TCP connections.
It takes many hours and does not depend on the client-side application.
When does the server delete inactive connections?
Any solution without restarting the server?

I saw a similar problem on Firebird Tracker - CORE-3002 12 / May / 10 but UNRESOLVED.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Rotteveel added a comment - 23/Jun/20 07:58 PM
You put 2.5.9 in affected versions, but your environment lists version 2.5.4. Which version are you really using?

Dmitry Yemanov added a comment - 24/Jun/20 05:20 AM
And it's worth trying with FB3, given that v2.5 is no longer supported.

Jaro added a comment - 24/Jun/20 03:50 PM
My version 2.5.4