Possible query abort when materializing fixed-size columns (#2)

Details

Detail name Value
Changelog Number 5972
Type Bug
Status Resolved
Affected Versions EXASOL 6.0.0
Fix Versions EXASOL 6.0.9
Resolution Date 2018-04-13

Problem
A race condition (different from EXASOL-2183) was detected when our query engine materializes fixed-size columns (basically everything except VARCHAR). Affected queries often contain subselects, order by clauses or analytical functions. We expect the occurrence rate for this error to be extremely low.

Workaround
Usually, repeating the query should succeed.
Alternatively the extra database parameter -enableAdaptiveAutoCompress=0 can be set to avoid this problem; note that changing the default value of this parameter is expected to trigger some performance degradation.