Termination of idle session with KILL SESSION command may not be possible
Details
| Detail name | Value |
|---|---|
| Changelog Number | 7334 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASOL 6.0.0, Exasol 6.1.0 |
| Fix Versions | Exasol 6.0.15, Exasol 6.1.2 |
| Resolution Date | 2019-04-04 |
In some cases, the KILL SESSION command may return a success code despite not being able to terminate the specified session. In this case the session will still be displayed in EXA_*_SESSIONS system tables.
As this should only affect sessions that are not currently processing requests, effects on the system should be minimal unless transaction conflicts are involved.
Workaround
Repetition of the KILL SESSION command won't help to terminate this session; to remove an affected session, a restart of the database is required.
