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

Jump to bottom

[FB3 CS] Server stops accepting new connections - lock denied [CORE5813] #6075

Open
firebird-automations opened this issue May 3, 2018 · 7 comments
Open

[FB3 CS] Server stops accepting new connections - lock denied [CORE5813] #6075

firebird-automations opened this issue May 3, 2018 · 7 comments
Assignees
@hvlad
Labels
affect-version: 3.0.3 component: engine priority: major type: bug

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: John Franck (bozzy)

Is related to CORE5436

Classic Server stops accepting new connections, while already active ones continue to work regularly.

Load conditions seems irrilevant, we had a total of 4 events in less than a week, two of these during very low load conditions and two in average conditions.

Error in firebird.log (this is the last event this morning, load conditions at 6 am are extremely low in our environment):

------------------------

sqlserver Thu May 3 06:17:56 2018
Database: /opt/firebird/security3.fdb
page 0, page type 1 lock denied (216)

sqlserver Thu May 3 06:17:57 2018
Database:
page 0, page type 1 lock denied (216)

------------------------

I've also noticed there are other errors in firebird.log, but these seems not to be related to any connection problems (I've got no reports from users). I put them here anyway:

------------------------

sqlserver Wed May 2 18:43:50 2018
Database: /opt/firebird/security3.fdb
page 377, page type 3 lock denied (216)

sqlserver Wed May 2 18:43:52 2018
Database: /opt/firebird/security3.fdb
page 377, page type 3 lock denied (216)

sqlserver Wed May 2 18:43:53 2018
Database: /opt/firebird/security3.fdb
page 377, page type 3 lock denied (216)

------------------------

This problem seems to be similar to this one: CORE5436 which however affects Firebird on Windows.

This is a big problem for us, service is going down from time to time and requires a server restart.
@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

This is a support issue, please post it to the Firebird Support mailing list. If not otherwise resolved, you can request this issue to be re-opened.

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

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

resolution: Incomplete [ 4 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: John Franck (bozzy)

Sorry but how is this different from CORE5436 ?

Vlad Khorsun suggested me to open a new ticket since this is probably the same problem as the just mentioned bug, but also affecting Linux platform (while CORE5436 was for Windows).

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

Link: This issue is related to CORE5436 [ CORE5436 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

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

resolution: Incomplete [ 4 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Looks like original reason of the issue was found and fixed.
And it is not platform dependent this time.
Please, try next snapshot build (after 3.0.4.32985)

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

@hvlad hvlad

Labels
affect-version: 3.0.3 component: engine priority: major type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@hvlad @firebird-automations