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.