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-issue-importer opened this issue Apr 13, 2014 · 5 comments

Comments

@firebird-issue-importer

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

firebird-issue-importer commented Apr 13, 2014

Modified by: @dyemanov

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

assignee: Dmitry Yemanov [ dimitr ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Apr 13, 2014

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Beta 1 [ 10332 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Sep 23, 2015

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 18, 2016

Modified by: @pavel-zotov

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

QA Status: No test

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Feb 2, 2016

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