Rare race condition during query execution
Details
| Detail name | Value |
|---|---|
| Changelog Number | 20709 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 8.0.0 |
| Fix Versions | Exasol 8.29.0 |
| Resolution Date | 2024-07-12 |
Description
There is a race condition inside the query execution pipeline in Exasol.
As a consequence, SQL statements sometimes crash with “Internal Server Error”.
Database may become unable to receive client connections for up to several minutes if one of internal components hits this error.
Systems with a single database node are unaffected.
Workaround
Execute the affected statement the second time. As this is a race condition, most of the time the execution is successful.
Fix
There are no longer crashes due to this race condition.