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

Wait mode and lock timeout of external transaction of EXECUTE STATEMENT not matched to corresponding parameters of local transaction [CORE3100] #3478

Closed
firebird-automations opened this issue Aug 7, 2010 · 6 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @hvlad

Reported by Ivan Prenosil at fb-devel :

For the new command to execute statements in external databases

EXECUTE STATEMENT ' ... ' ON EXTERNAL 'mydb.fdb';

the documentation says

... started new transaction with the same parameters as current transaction ...

but it ignores WAIT parameter. I guess it is by design because of impossibility
to detect deadlocks between two databases, right ?
But it also ignores this parameter
SET TRANSACTION LOCK TIMEOUT 5
Is it intentional ?

Commits: 2dbab96 087a7f7

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

NB: parameter NO AUTO UNDO not passed from 'outer' Tx to autonomous one. See script in the letter to dimitr 26-mar-2015 09:38.

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Fix Version: 3.0 Alpha 1 [ 10331 ]

Fix Version: 2.5.1 [ 10333 ]

summary: Wait mode and lock timeout of external transaction of EXECUTE STATEMENT not matched to corresponding parameters o flocal transaction => Wait mode and lock timeout of external transaction of EXECUTE STATEMENT not matched to corresponding parameters of local transaction

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 2.5.0 [ 10221 ]

Fix Version: 2.5.1 [ 10333 ] =>

@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: Done successfully

Test Details: NB: parameter NO AUTO UNDO not passed from 'outer' Tx to autonomous one. See script in the letter to dimitr 26-mar-2015 09:38.

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