In very rare cases, using the query cache can result in a system deadlock
Details
| Detail name | Value |
|---|---|
| Changelog Number | 6636 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASOL 6.0.0 |
| Fix Versions | Exasol 6.0.12 |
| Resolution Date | 2018-08-27 |
Description:
The query cache of the database speeds up sql requests that occur more frequently. Some of these query cache operations are executed synchronously on all nodes. Under very rare circumstances, it is possible that a synchronous request will not be performed on all nodes. This leads to a system deadlock.
Workaround:
This problem seems to occur very rarely. However, if this problem does happen more often, you can fix it by disabling the query cache.