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

3.0 error handling for SELECT WITH LOCK breaks compatibility with 2.5 [CORE5555] #5822

Closed
firebird-automations opened this issue May 30, 2017 · 5 comments
Closed

3.0 error handling for SELECT WITH LOCK breaks compatibility with 2.5 [CORE5555] #5822

firebird-automations opened this issue May 30, 2017 · 5 comments
Assignees
@hvlad
Labels
affect-version: 3.0.2 component: engine fix-version: 3.0.3 fix-version: 4.0 Alpha 1 priority: major qa: done successfully type: bug

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: bazilio (bazilio77)

Votes: 1

Executing SELECT WITH LOCK for the same record twice in different transactions produced SQLCODE = -901 GDSCODE = 335544345 in 2.5
But 3.0 break compatibility of error handling/
It does SQLCODE = -904 GDSCODE = 335544878

Commits: bb0afc7 c74e931
@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

With fix this case (active concurrent transaction vs SELECT WITH LOCK) returns the same sequence of error codes as other 4 cases of update conflicts:
isc_deadlock, isc_update_conflict, isc_concurrent_transaction

See also comments at CORE4473

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

Fix Version: 3.0.3 [ 10810 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test => Done successfully

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

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.2 component: engine fix-version: 3.0.3 fix-version: 4.0 Alpha 1 priority: major qa: done successfully type: bug
Projects
None yet
Milestone
No milestone
Development

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