Huge log file output for aggregated query over a UNION ALL subselect

Details

Detail name Value
Changelog Number 31043
Type Bug
Status Resolved
Affected Versions Exasol 2026.1.0
Fix Versions Exasol 2026.1.1
Resolution Date 2026-08-06

Description

In rare cases an aggregated query over a UNION ALL subselect can cause huge log file output exceeding 1 GB for the default log level "notice".

Workarounds

  • Run the statement CONTROL SET TRACE LEVEL QUIET before affected statements and enable the normal logging afterwards again using CONTROL SET TRACE LEVEL NOTICE. This only affects one session but requires DBA privileges.
  • Start the database with the database parameter -traceLevel=0 (see Add database parameters) to reduce the log level globally (not recommended).

Fix

We removed the huge log output.