Duplicate (session_id, stmt_id) pairs in statistics system tables upon abnormal process termination
Details
| Detail name | Value |
|---|---|
| Changelog Number | 7376 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASOL 6.0.0, Exasol 6.1.0 |
| Fix Versions | Exasol 6.1.2 |
| Resolution Date | 2019-01-24 |
Synopsis
Under certain conditions (see description below) it is possible that duplicate (session_id, stmt_id) pairs are generated in some system tables in the EXA_STATISTICS schema.
Details
Preconditions
For this behavior to occur both of the following conditions must be met:
- No running query in the sql process
- The sql process is killed outside Exasol's control, for instance via explicit kill using an operating system signal
Effects
The last executed statement in the session appears twice in the affected system tables, with the second entry as a crashed query.
Affected system tables
The affected system tables are:
- EXA_DBA_AUDIT_SQL
- EXA_SQL_LAST_DAY
- EXA_SQL_HOURLY
- EXA_SQL_DAILY
- EXA_SQL_MONTHLY
