Wrong duration in EXA_DBA_TRANSACTION_CONFLICTS for blocking commits
Details
| Detail name | Value |
|---|---|
| Changelog Number | 15064 |
| Type | Bug |
| Status | Open |
| Affected Versions | Exasol 7.1.0, Exasol 8.0.0 |
Description
The duration of a transaction conflict is displayed as too short in EXA_DBA_TRANSACTION_CONFLICTS if the blocking transaction is a COMMIT.
Workaround
If the transaction occurred in the last day, use the profiling system tables (for example EXA_DBA_PROFILE_LAST_DAY) to determine the correct conflict duration.
Fix
EXA_DBA_TRANSACTION_CONFLICTS displays the correct conflict duration.