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

Concurrent transaction number not reported if lock timeout occurs [CORE2988] #3370

Closed
firebird-issue-importer opened this issue May 4, 2010 · 7 comments

Comments

@firebird-issue-importer
Copy link

firebird-issue-importer commented May 4, 2010

Submitted by: @samofatov

Assigned to: @samofatov

Is duplicated by CORE4193

Firebird 2.1 added a feature to report concurrent transaction number when there is lock contention.

However, concurrent transaction number is not reported in two important cases, which severely limits its usefulness:

Lock timeouts during read operations:

create table test (id integer);
insert into test values(1);
commit;

ISQL1:
set transaction read committed no record_version lock timeout 10;
update test set id = id;

ISQL2:
set transaction read committed no record_version lock timeout 10;
select * from test;

      ID

============
Statement failed, SQLCODE = -901
lock time-out on wait transaction
-deadlock

Lock timeouts during pessimistic locking:

ISQL1:
set transaction read committed lock timeout 10;
select * from test with lock;

ISQL2:
set transaction read committed lock timeout 10;
select * from test with lock;

      ID

============
Statement failed, SQLCODE = -901
lock time-out on wait transaction

Commits: c84d62d

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 4, 2010

Modified by: @samofatov

assignee: Nickolay Samofatov [ skidder ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 4, 2010

Modified by: @samofatov

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Feb 14, 2011

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 26, 2013

Modified by: @dyemanov

Link: This issue block progress on CORE4193 [ CORE4193 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 26, 2013

Modified by: @dyemanov

Link: This issue is duplicated by CORE4193 [ CORE4193 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 26, 2013

Modified by: @dyemanov

Link: This issue block progress on CORE4193 [ CORE4193 ] =>

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 28, 2015

Modified by: @pavel-zotov

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

QA Status: Done successfully

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

No branches or pull requests

1 participant