Misleading warnings about high active session slot usage in EXAoperation

Details

Detail name Value
Changelog Number 10470
Type Bug
Status Resolved
Affected Versions Exasol 6.1.0, Exasol 6.2.0
Fix Versions Exasol 6.2.13, Exasol 7.0.7
Resolution Date 2021-02-09

Description

Exasol's Session Management is described here. Once the number of active sessions reaches 80 active sessions, the following message is logged in EXAoperation:

Query queue limit of active sessions nearly reached

At 100 active sessions, this message is logged:

Limit of active sessions has been reached.

In some situations, these warnings might be logged erroneously because active slots occupied by idle sessions can be cleaned up. This means the message may appear, despite not actually having 80 + active sessions.

You can contact Exasol Support to confirm if the bug has occurred or not. 

Workaround

The messages in EXAoperation can be ignored. 

Fix

The warnings in EXAoperation will only be shown if there are truly 80+ active sessions.