Crashed queries may be missing in EXA_DBA_AUDIT_SQL

Details

Detail name Value
Changelog Number 10957
Type Bug
Status Resolved
Affected Versions Exasol 7.0.0, Exasol 7.1.0
Fix Versions Exasol 8.0.0
Resolution Date 2022-04-20

Description

In some cases, crashed queries may not show up in EXA_DBA_AUDIT_SQL. Whether this bug occurs or not depends on which node the session is connected to.

Notes

  • Crashed queries are queries that end for unexpected reasons (internal server errors). These do not include exceptions (e.g. division by zero, query timeouts)
  • Queries that do not crash are unaffected - their entries are always present in EXA_DBA_AUDIT_SQL

Workaround

There is no workaround.

Fix

All queries will be displayed in EXA_DBA_AUDIT_SQL.