Deadlock in log server may prevent updating auditing and statistics tables
Details
| Detail name | Value |
|---|---|
| Changelog Number | 12476 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.0.0, Exasol 7.1.0 |
| Fix Versions | Exasol 8.0.0, Exasol 7.0.17, Exasol 7.1.7 |
| Resolution Date | 2022-03-15 |
Description
In rare cases, the logserver may run into a deadlock preventing it from inserting data into system tables. As a result, auditing entries and statistics tables are not updated and do not show the latest data.
You can identify this by querying any *_LAST_DAY tables and checking the timestamp of the most recent entry.
Workaround
Restart the database.
Fix
Auditing entries and statistics tables always show the latest data.