Provide ability to see in the trace log actions related to session management
(e.g. ALTER SESSION RESET)
--------------------------------------------------------------------------------------------------------
Key: CORE-6469
URL: http://tracker.firebirdsql.org/browse/CORE-6469
Project: Firebird Core
Issue Type: Improvement
Affects Versions: 4.0 Beta 2
Reporter: Pavel Zotov
Priority: Minor
Ticket has been created after discuss with Vlad.
Currently trace log does not contain info about requests related to session
management. It will be nice to see such info there.
Example:
1) create config for trace:
=======
database =
{
enabled = true
log_initfini = false
log_errors = true
time_threshold = 0
log_connections = true
log_transactions = true
log_statement_finish = true
}
=======
- and run trace
2) run following .sql:
=======
set bail on;
shell del c:\temp\tmp4test.fdb 2>nul;
create database 'localhost:c:\temp\tmp4test.fdb' user 'sysdba' password
'masterkey';
set list on;
set autoddl off;
commit;
select cast(1234.5678 as decfloat(16)) as before_ssn_reset from rdb$database;
alter session reset;
select cast(3456.7890 as decfloat(16)) as after_ssn_reset from rdb$database;
=======
In the trace log we see:
=======
2021-01-19T07:53:11.6930 (2360:00000000061C0640) START_TRANSACTION
C:\TEMP\TMP4TEST.FDB (ATT_3, SYSDBA:NONE, NONE, TCPv6:::1/61195)
C:\FB\40SS\isql.exe:7044
(TRA_7, CONCURRENCY | WAIT | READ_WRITE)
2021-01-19T07:53:11.6940 (2360:00000000061C0640) EXECUTE_STATEMENT_FINISH
C:\TEMP\TMP4TEST.FDB (ATT_3, SYSDBA:NONE, NONE, TCPv6:::1/61195)
C:\FB\40SS\isql.exe:7044
(TRA_7, CONCURRENCY | WAIT | READ_WRITE)
Statement 6:
-------------------------------------------------------------------------------
select cast(1234.5678 as decfloat(16)) as before_ssn_reset from rdb$database
1 records fetched
0 ms, 5 fetch(es)
2021-01-19T07:53:11.6940 (2360:00000000061C0640) ROLLBACK_TRANSACTION
C:\TEMP\TMP4TEST.FDB (ATT_3, SYSDBA:NONE, NONE, TCPv6:::1/61195)
C:\FB\40SS\isql.exe:7044
(TRA_7, CONCURRENCY | WAIT | READ_WRITE)
0 ms, 1 fetch(es), 1 mark(s)
2021-01-19T07:53:11.6950 (2360:00000000061C0640) START_TRANSACTION
C:\TEMP\TMP4TEST.FDB (ATT_3, SYSDBA:NONE, NONE, TCPv6:::1/61195)
C:\FB\40SS\isql.exe:7044
(TRA_8, CONCURRENCY | WAIT | READ_WRITE)
2021-01-19T07:53:11.6950 (2360:00000000061C0640) EXECUTE_STATEMENT_FINISH
C:\TEMP\TMP4TEST.FDB (ATT_3, SYSDBA:NONE, NONE, TCPv6:::1/61195)
C:\FB\40SS\isql.exe:7044
(TRA_8, CONCURRENCY | WAIT | READ_WRITE)
Statement 7:
-------------------------------------------------------------------------------
select cast(3456.7890 as decfloat(16)) as after_ssn_reset from rdb$database
1 records fetched
0 ms, 5 fetch(es)
2021-01-19T07:53:11.6950 (2360:00000000061C0640) COMMIT_TRANSACTION
C:\TEMP\TMP4TEST.FDB (ATT_3, SYSDBA:NONE, NONE, TCPv6:::1/61195)
C:\FB\40SS\isql.exe:7044
(TRA_8, CONCURRENCY | WAIT | READ_WRITE)
0 ms, 1 fetch(es), 1 mark(s)
2021-01-19T07:53:11.6960 (2360:00000000061C0640) DETACH_DATABASE
C:\TEMP\TMP4TEST.FDB (ATT_3, SYSDBA:NONE, NONE, TCPv6:::1/61195)
C:\FB\40SS\isql.exe:7044
=======
One can guess that something happen about session only by watching for Tx
numbers (TRA_7 rolled back and TRA_8 appeared - without explicit command to
finish 1st of them).
It will be good to see explicitly mentioned session-level statement between
ROLLBACK and START Tx statements.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
