Unexpected restart of the database on systems with high load and many aborted queries
Details
| Detail name | Value |
|---|---|
| Changelog Number | 15370 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.1.11 |
| Fix Versions | Exasol 7.1.25 |
| Resolution Date | 2023-12-04 |
Description
A race condition may cause the database to restart unexpectedly if the following conditions are met:
- The system is under very heavy load
- The system has a very high concurrency
- There are a high number of SELECT queries without any data changes
- A high number of queries are killed because they can not be executed within a specified timeout
Workaround
Avoid improper termination of queries by setting a higher query timeout.
Fix
In these situations, the database will not restart and will function as expected.