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

Firebird freeze for new connections [CORE5844] #6105

Closed
firebird-automations opened this issue Jun 11, 2018 · 20 comments
Closed

Firebird freeze for new connections [CORE5844] #6105

firebird-automations opened this issue Jun 11, 2018 · 20 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Ivan Diez (ivan_70)

Hi,

sometime we have the firebird seems to be frozen and no new connection are allowed. I mean, people working with the app can work normally but people who tries to opens the app cannot., even when we try to open a direct database connection (flamerobin) it's impossible.

Please help!!

Commits: edce1bd 54f024a

@firebird-automations
Copy link
Collaborator Author

Modified by: Ivan Diez (ivan_70)

Version: 3.0.1 [ 10730 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: Ivan Diez (ivan_70)

security: Managers [ 10013 ] => Developers [ 10012 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Specify, please:
- OS name, version and bitness
- Firebird architecture and bitness
- changed settings at firebird.conf
- messages at firebird.log

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

security: Developers [ 10012 ] =>

@firebird-automations
Copy link
Collaborator Author

Commented by: Ivan Diez (ivan_70)

The server OS version is a Windows 2008 R2 Standard
Firebird installation is a SuperServer v3.0.1
No change on firebird.conf
and the is the latest message we got at firebird.log: INET/inet_error: read errno = 10054 This error message is repeated thousand of times in the log file

kind regards

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Ivan,

please, answer *all* questions.

Could you try latest release v3.0.3 ?
Could you provide us with full memory dump when some new connection is freezed ?

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Ivan,

without info i requested i'll be forced to close this ticket as incomplete, sorry

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

FB 3.0.3, it happens all the time when i terminate application (client with multiple connections and events)
in 3.0.4 (from 24.7.2018) its partially fixed but still present from time to time

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

Dump from 3.0.4.33011 (64bit) SuperServer - 1 active client app with 5 connections opened

http://www.merkuris.sk/files/firebird.zip

and dump when i try to open new connection while server is "frozen"

http://www.merkuris.sk/files/firebird_2.zip

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Thanks, dump show how the issue happens.
Could you reproduce the ussue and, if yes, would you like to test custom build with patch ?

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

i can reproduce it, but it takes same time, if you prepare binary i'll test it immediately

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Please, test next snapshot build (after 33012)

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

after 2 hours of testing i can't reproduce it anymore, i had 2 server crashes but don't have memory dumps, when i get them i'll create new issue, but this issue seems to be fixed for me

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Thank you for confirmation!

I have no idea if it is the same case as was initially reported by Ivan Diez, but,
as he is silent for more than a month, i'll close this ticket as resolved.

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

Fix Version: 4.0 Beta 1 [ 10750 ]

Fix Version: 3.0.4 [ 10863 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Version: 3.0.3 [ 10810 ]

Version: 4.0 Alpha 1 [ 10731 ]

Version: 3.0.2 [ 10785 ]

Version: 3.0.0 [ 10740 ]

Version: 4.0 Initial [ 10621 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

The issue is related with events processing and could happens when POST_EVENT run by ON DISCONNECT trigger .
Also, application doesn't cancel events when disconnects - i reproduced it by killing application.

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

i got dump from server crash during testing this issue FB 64bit (3.0.4.33014)

http://www.merkuris.sk/files/firebird_3.zip

i can confirm that we are using EVENT fired from ON DISCONNECT TRIGGER

@firebird-automations
Copy link
Collaborator Author

Commented by: Ivan Diez (ivan_70)

Hi Vlad / Sorien,

I cannot connect time ago due a personal issue.

Thanks to track and solve the issue, I'm more than excited to download the version 3.0.4 to found it solved!!

Best regards
Iván

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