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.