Rare session crash with filtering optimization
Details
| Detail name | Value |
|---|---|
| Changelog Number | 20792 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.1.0, Exasol 8.0.0 |
| Fix Versions | Exasol 8.29.0, Exasol 7.1.29 |
| Resolution Date | 2024-07-12 |
Description
In rare circumstances a session can be terminated due to a “Internal Server Error” during a filtering operation in a SQL statement. This is the result of a bug which only manifests with a particular internal state of the system - the state is not controllable.
Workaround
There are two workarounds - the best is to restart the database; which will alter the internal state and the problem is unlikely to occur again.
The second workaround is to use the DB parameter -useRawCompare=0. This will eliminate the possibility of encountering this bug; but the database will suffer a performance penalty.
Information on setting DB parameters could be found in our documentation:
- Version 7.1: Edit a Database.
- Version 8: Add Database Parameters.
Fix
The filter operations work without error.
