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.