View Issue Details

IDProjectCategoryView StatusLast Update
0001827FB TraceManagerGeneralpublic2020-10-26 13:35
ReporterThomas Steinmaurer Assigned ToThomas Steinmaurer  
PrioritynormalSeverityfeatureReproducibilityalways
Status closedResolutionfixed 
Fixed in Version3.7.0 
Summary0001827: Trace data/parser: Full support for init/new transaction id information in RETAINING scenarios
Description- Extend trace record for COMMIT/ROLLBACK RETAINING to show old/new transaction IDs (CORE-6095). Available since Firebird 3.0.5

2020-10-22T16:31:06.9120 (4596:022E6FE0) PREPARE_STATEMENT
    tourism.fdb (ATT_427, TOURISM:NONE, UNICODE_FSS, TCPv6:::1/50228)
    C:\Program Files (x86)\Upscene Productions\Database Workbench 5 Pro\DBW5Pro.exe:8504
        (TRA_758, INIT_756, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
Statement 133:
-------------------------------------------------------------------------------
UPDATE "ACCOMMODATION"
SET
  "STREET" = ?
WHERE
  "ID" = ?
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Select Expression
    -> Filter
        -> Table "ACCOMMODATION" Access By ID
            -> Bitmap
                -> Index "RDB$PRIMARY17" Unique Scan
      0 ms

2020-10-22T16:31:06.9130 (4596:022E6FE0) EXECUTE_STATEMENT_START
    tourism.fdb (ATT_427, TOURISM:NONE, UNICODE_FSS, TCPv6:::1/50228)
    C:\Program Files (x86)\Upscene Productions\Database Workbench 5 Pro\DBW5Pro.exe:8504
        (TRA_758, INIT_756, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
Statement 133:
-------------------------------------------------------------------------------
UPDATE "ACCOMMODATION"
SET
  "STREET" = ?
WHERE
  "ID" = ?
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Select Expression
    -> Filter
        -> Table "ACCOMMODATION" Access By ID
            -> Bitmap
                -> Index "RDB$PRIMARY17" Unique Scan
param0 = varchar(120), "Untere Donaulände 9"
param1 = bigint, "1"

2020-10-22T16:31:06.9130 (4596:022E6FE0) EXECUTE_STATEMENT_FINISH
    tourism.fdb (ATT_427, TOURISM:NONE, UNICODE_FSS, TCPv6:::1/50228)
    C:\Program Files (x86)\Upscene Productions\Database Workbench 5 Pro\DBW5Pro.exe:8504
        (TRA_758, INIT_756, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
Statement 133:
-------------------------------------------------------------------------------
UPDATE "ACCOMMODATION"
SET
  "STREET" = ?
WHERE
  "ID" = ?
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Select Expression
    -> Filter
        -> Table "ACCOMMODATION" Access By ID
            -> Bitmap
                -> Index "RDB$PRIMARY17" Unique Scan
param0 = varchar(120), "Untere Donaulände 9"
param1 = bigint, "1"
0 records fetched
      0 ms, 9 fetch(es), 2 mark(s)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
ACCOMMODATION 1 1

2020-10-22T16:31:08.1890 (4596:022E6FE0) FREE_STATEMENT
    tourism.fdb (ATT_427, TOURISM:NONE, UNICODE_FSS, TCPv6:::1/50228)
    C:\Program Files (x86)\Upscene Productions\Database Workbench 5 Pro\DBW5Pro.exe:8504
Statement 133:
-------------------------------------------------------------------------------
UPDATE "ACCOMMODATION"
SET
  "STREET" = ?
WHERE
  "ID" = ?
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Select Expression
    -> Filter
        -> Table "ACCOMMODATION" Access By ID
            -> Bitmap
                -> Index "RDB$PRIMARY17" Unique Scan

2020-10-22T16:31:08.1920 (4596:022E6FE0) COMMIT_RETAINING
    tourism.fdb (ATT_427, TOURISM:NONE, UNICODE_FSS, TCPv6:::1/50228)
    C:\Program Files (x86)\Upscene Productions\Database Workbench 5 Pro\DBW5Pro.exe:8504
        (TRA_758, INIT_756, READ_COMMITTED | REC_VERSION | NOWAIT | READ_WRITE)
    New number 759
      1 ms, 3 write(s), 2 fetch(es), 2 mark(s)
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2020-10-22 16:29 Thomas Steinmaurer New Issue
2020-10-22 16:35 Thomas Steinmaurer Summary Trace data/parser: Support for new transaction id information for COMMIT / ROLLBACK RETAINING => Trace data/parser: Support for init/new transaction id information in COMMIT / ROLLBACK RETAINING context
2020-10-22 16:35 Thomas Steinmaurer Description Updated
2020-10-23 08:37 Thomas Steinmaurer Summary Trace data/parser: Support for init/new transaction id information in COMMIT / ROLLBACK RETAINING context => Trace data/parser: Full support for init/new transaction id information in RETAINING scenarios
2020-10-23 08:44 Thomas Steinmaurer Status new => assigned
2020-10-23 08:44 Thomas Steinmaurer Assigned To => Thomas Steinmaurer
2020-10-23 08:44 Thomas Steinmaurer Status assigned => resolved
2020-10-23 08:44 Thomas Steinmaurer Fixed in Version => 3.7.0
2020-10-23 08:44 Thomas Steinmaurer Resolution open => fixed
2020-10-26 13:35 Thomas Steinmaurer Status resolved => closed