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.