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-issue-importer opened this issue Aug 7, 2010 · 6 comments

Comments

@firebird-issue-importer
Copy link

@firebird-issue-importer firebird-issue-importer commented Aug 7, 2010

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

@firebird-issue-importer firebird-issue-importer commented Aug 7, 2010

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 8, 2010

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

@firebird-issue-importer firebird-issue-importer commented Aug 8, 2010

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 2, 2010

Modified by: @dyemanov

Fix Version: 2.5.0 [ 10221 ]

Fix Version: 2.5.1 [ 10333 ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 14, 2011

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 29, 2015

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
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants