In rare circumstances, transactions may starve on commit or rollback.

Details

Detail name Value
Changelog Number 6282
Type Bug
Status Resolved
Affected Versions EXASOL 6.0.0, Exasol 6.1.0
Fix Versions Exasol 6.0.13, Exasol 6.1.2
Resolution Date 2019-07-15

Problem Description

Transactions may deadlock during commit or rollback; the cause of this problem is not clear yet.

If the affected database is running completely in-memory, the problem is limited to the affected session.
However, if the database is forced to perform db-ram swapping or resizing operations, the session deadlock may escalate into a system deadlock.

Occurrence rate of the problem seems to scale with number of database nodes and amount of transactions per hour.

At this point there is no known workaround