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