Possible query abort when materializing fixed-size columns
Details
| Detail name | Value |
|---|---|
| Changelog Number | 5635 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASOL 6.0.3 |
| Fix Versions | EXASOL 6.0.7 |
| Resolution Date | 2018-01-22 |
Problem
A race condition 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.