Possible statement abort when exporting tables
Details
| Detail name | Value |
|---|---|
| Changelog Number | 6344 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASOL 6.0.8, Exasol 6.1.beta1 |
| Fix Versions | Exasol 6.1.0, Exasol 6.0.11 |
| Resolution Date | 2018-07-05 |
Synopsis
We have discovered a bug in our system which may cause EXPORT statements to fail for certain tables.
In those cases, the export will fail with error message Successfully reconnected after internal server error, transaction was rolled back.
Details
The bug occurs only when the following conditions are simultaneously fulfilled:
- The data per row to be exported is at least 1 KB
- There are rows marked as deleted in the table
- Some unfortunate data layout which triggers this bug
Note that the table data itself is not corrupted or affected in any way, only the export statement is affected.
Workaround
The export statements succeed again after no rows marked as deleted exist in the table. The rows marked as deleted can be removed by running a reorganize statement on the affected table:
reorganize table <AFFECTED_TABLE> enforce
