Logout entry in EXA_DBA_AUDIT_SESSIONS may be missing for sessions that never executed a query
Details
| Detail name | Value |
|---|---|
| Changelog Number | 10362 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 6.1.0, Exasol 6.2.0 |
| Fix Versions | Exasol 7.0.0, Exasol 6.2.9, Exasol 6.1.13 |
| Resolution Date | 2020-09-11 |
Description
If a session never executed a query before logging out, the session may be missing a logout entry in EXA_DBA_AUDIT_SESSIONS (LOGOUT_TIME IS NULL)
You can verify which sessions these are using the following query:
SELECT * FROM EXA_DBA_AUDIT_SESSIONS WHERE LOGOUT_TIME IS NULL AND SESSION_ID NOT IN (SELECT SESSION_ID FROM EXA_DBA_SESSIONS)
Workaround
There is no workaround
Fix
Only sessions which are currently connected to the database should display a NULL value in the LOGOUT_TIME of EXA_DBA_AUDIT_SESSIONS
