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

Unexpected lock conflict error may be raised while connecting to a heavily loaded database [CORE4265] #4589

Closed
firebird-automations opened this issue Nov 12, 2013 · 6 comments
Closed

Unexpected lock conflict error may be raised while connecting to a heavily loaded database [CORE4265] #4589

firebird-automations opened this issue Nov 12, 2013 · 6 comments
Assignees
@dyemanov
Labels
affect-version: 2.1.5 Update 1 affect-version: 2.1.5 affect-version: 2.5.2 Update 1 affect-version: 2.5.2 affect-version: 3.0 Alpha 1 component: engine fix-version: 3.0 Alpha 2 priority: major qa: cannot be tested type: bug

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

Under high concurrent load isc_attach_database() may return isc_lock_conflict error:

Statement failed, SQLSTATE = 40001
lock conflict on no wait transaction

without any obvious reasons. This happens only when a number of connections are being established at the same time.

Commits: 13949c0 FirebirdSQL/fbt-repository@bb781a1
@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

reporter: Dmitry Yemanov [ dimitr ] => Pavel Zotov [ tabloid ]

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => In Progress [ 3 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: In Progress [ 3 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 2 [ 10560 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test => Cannot be tested

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

@dyemanov dyemanov

Labels
affect-version: 2.1.5 Update 1 affect-version: 2.1.5 affect-version: 2.5.2 Update 1 affect-version: 2.5.2 affect-version: 3.0 Alpha 1 component: engine fix-version: 3.0 Alpha 2 priority: major qa: cannot be tested type: bug
Projects
None yet
Milestone
No milestone
Development

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