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.