EXA_*_SESSIONS may contain phantom session which failed to log in
Details
| Detail name | Value |
|---|---|
| Changelog Number | 14718 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.0.0, Exasol 7.1.0 |
| Fix Versions | Exasol 7.1.12 |
| Resolution Date | 2022-07-13 |
Description
Failed logins to Exasol may inadvertently create a phantom entry in the EXA_*_SESSIONS tables. Since the logins actually failed, such sessions were never used, but still remain in the tables.
Workaround
Restart the database to remove the phantom entries
Fix
Sessions that fail to log in are not listed in EXA_*_SESSIONS
