ALTER SESSION RESET does not work in ISQL, results in error "Cannot reset user session - There are open transactions (2 active)" [CORE6384] #6623
Comments
|
Commented by: @dyemanov Why not using SET AUTODDL OFF if you need to execute ALTER SESSION RESET? |
|
Commented by: @hvlad Mark, please, don't start it over again. Re-read discussion in fb-devel "[Firebird-devel] ALTER SESSION RESET not allowed if there are transactions?" started by you at 2 jun 2018 |
|
Commented by: @mrotteveel Well, to be honest, I had forgotten about that discussion, and reading it back my primary focus in that discussion was on the behaviour for Jaybird and drivers, and not isql. When I was trying out something in isql yesterday, I was quite surprised by the error when executing ALTER SESSION RESET. I think using SET AUTODDL OFF is not a solution/workaround that is immediately obvious. At minimum it I think it needs to be explicitly mentioned in section ALTER SESSION RESET of the release notes. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: @mrotteveel
As isql uses two transactions, it is not possible to execute ALTER SESSION RESET. Doing so results in the following error:
D:\DevSoft\FB_tests\Firebird-4.0.0.2133-0_x64>isql -user sysdba -password masterkey localhost:employee
Database: localhost:employee, User: SYSDBA
SQL> alter session reset;
Statement failed, SQLSTATE = 01002
Cannot reset user session
-There are open transactions (2 active)
SQL>
Given the requirement that there is no active transaction (or only the current transaction executing ALTER SESSION RESET), it looks like ISQL needs to get special treatment for handling ALTER SESSION RESET, for example on detection of ALTER SESSION RESET, commit both transaction, or something similar.
The text was updated successfully, but these errors were encountered: