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