Missing logout times in EXA_DBA_SESSIONS_LAST_DAY, EXA_DBA_SESSIONS_USER_LAST_DAY, and EXA_DBA_AUDIT_SESSIONS
Details
| Detail name | Value |
|---|---|
| Changelog Number | 5600 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | |
| Fix Versions | EXASOL 6.0.9 |
| Resolution Date | 2023-05-09 |
Description
Due to an internal processing problem, Exasol may stop setting the LOGOUT_TIME column in the following tables:
- EXA_DBA_SESSIONS_LAST_DAY
- EXA_DBA_SESSIONS_USER_LAST_DAY
- EXA_DBA_AUDIT_SESSIONS
Workaround
A restart of the database solves the issue for newly created sessions. Previously unhandled sessions will have their LOGOUT_TIME set to the shutdown timestamp.
