View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001827 | FB TraceManager | General | public | 2020-10-22 16:29 | 2020-10-26 13:35 |
Reporter | Thomas Steinmaurer | Assigned To | Thomas Steinmaurer | ||
Priority | normal | Severity | feature | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Fixed in Version | 3.7.0 | ||||
Summary | 0001827: 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) | ||||
Tags | No tags attached. | ||||
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 |