Query cache may cause database to hang
Details
| Detail name | Value |
|---|---|
| Changelog Number | 16136 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.1.12, Exasol 7.1.14 |
| Fix Versions | Exasol 7.0.0 |
| Resolution Date | 2020-09-11 |
Description
In rare cases, the query cache may trigger a deadlock and cause the database to hang, preventing any further transactions.
Workaround
Restart the database to put the database in a usable state. The problem is prevented by disabling query cache on the system:
ALTER SYSTEM SET QUERY_CACHE='OFF';
Note: This may cause performance degradations.
Fix
The deadlock is fixed, and query cache can be used as expected.
