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

SELECT WITH LOCK may enter an infinite loop for a single record [CORE4388] #4710

Closed
firebird-automations opened this issue Apr 13, 2014 · 5 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

If a concurrent transaction has deleted (and committed) the record that our transaction is trying to lock, the engine keeps infinitely attempting to lock the deleted record.

Commits: a6225ec FirebirdSQL/fbt-repository@1d826c7

====== Test Details ======

This bug was found during OLTP-EMUL development, but I don't remember details.
Can not reproduce this bug on WI-T3.0.0.30566 Firebird 3.0 Alpha 1 and WI-T3.0.0.30809 Firebird 3.0 Alpha 2.
Any advice about how this test should be properly written will be appreciated.

@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 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 Beta 1 [ 10332 ]

@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 => Done with caveats

Test Details: This bug was found during OLTP-EMUL development, but I don't remember details.
Can not reproduce this bug on WI-T3.0.0.30566 Firebird 3.0 Alpha 1 and WI-T3.0.0.30809 Firebird 3.0 Alpha 2.
Any advice about how this test should be properly written will be appreciated.

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