Race condition in IMPERSONATE on systems with many concurrent sessions

Details

Detail name Value
Changelog Number 12967
Type Bug
Status Resolved
Affected Versions Exasol 7.0.0, Exasol 7.1.0
Fix Versions Exasol 7.0.14, Exasol 7.1.3
Resolution Date 2021-11-26

Problem

Due to a race condition, the permissions for a user using IMPERSONATE may not be correctly set.
The issue occurs under heavy load--specifically if the system has many active parallel sessions or a high memory load.

Workarounds

  • Reduce the number of parallel sessions or the memory load.
  • Execute the IMPERSONATE statement as the first statement in a session.

Fix

The issue has been fixed.