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

AV in engine when StatementTimeout is active for user statement and some internal DSQL statement was executed as part of overall execution process [CORE6526] #6753

Closed
firebird-automations opened this issue Mar 28, 2021 · 3 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @hvlad

In the case below the internal DSQL statement is run on commit when index is modified.
Note, most internal statements used by the engine is ESQL, not DSQL - thus they are not interact with StatementTImeout.

set term ^;

execute block as begin
in autonomous transaction do
execute statement 'set statistics index rdb$index_0';
end
^
set statement timeout 60
^
execute block as begin
in autonomous transaction do
execute statement 'set statistics index rdb$index_0';
end
^

Statement failed, SQLSTATE = 08006
Error reading data from the connection.

The bug was reported by Pavel Zotov with much more complex scenario.

Commits: 1b9f5d8

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

Fix Version: 4.0.0 [ 10931 ]

@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