Increased memory usage due to not correctly terminated SQL processes

Detail name	Value
Changelog Number	8719
Type	Bug
Status	Resolved
Affected Versions	Exasol 6.1.0, Exasol 6.2.0
Fix Versions	Exasol 6.1.7, Exasol 6.2.3
Resolution Date	2019-11-12

Background

When the database is running out of memory, idle SQL processes and sessions with high memory usage will be terminated to reduce the memory usage.

Problem

In some cases SQL processes that were just started shortly before the database started to reduce the memory usage won't be terminated correctly. If this happens, the affected processes will continue to use memory but won't be used for executing queries anymore.

Workaround

Restart of the database is needed to terminate these processes.