Rare memory corruption involving big IN lists and query cache leads to session crashes
Details
| Detail name | Value |
|---|---|
| Changelog Number | 8500 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 6.1.0 |
| Fix Versions | Exasol 7.0.0, Exasol 6.1.7, Exasol 6.2.2 |
| Resolution Date | 2019-09-16 |
Problem
While accessing the internal query cache, queries may crash when they contain very large IN lists (>150,000 elements). The cause of this is a bug in internal memory garbage collection in context of the query cache.
Workaround
Disabling the query cache avoids this problem (see ALTER SESSION and ALTER SYSTEM)