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-issue-importer opened this issue Jun 11, 2018 · 20 comments
Closed

Firebird freeze for new connections [CORE5844] #6105

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

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 11, 2018

Modified by: Ivan Diez (ivan_70)

Version: 3.0.1 [ 10730 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 11, 2018

Modified by: Ivan Diez (ivan_70)

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 11, 2018

Commented by: @hvlad

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 11, 2018

Modified by: @dyemanov

security: Developers [ 10012 ] =>

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 12, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 13, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 19, 2018

Commented by: @hvlad

Ivan,

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 24, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 25, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 25, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 25, 2018

Commented by: Sorien (sorien)

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 26, 2018

Commented by: @hvlad

Please, test next snapshot build (after 33012)

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 26, 2018

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 26, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 26, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 26, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 26, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 26, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 26, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 27, 2018

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