Smaller logfiles
Details
| Detail name | Value |
|---|---|
| Changelog Number | 9209 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 8.0.0 |
| Resolution Date | 2022-04-20 |
Background
Internal logfiles are written in a background process.
Support cases may require those logfiles.
Improvement
The overall size of the logfiles is reduced.
Due to smaller logfiles the whole process of extracting the logfiles and submitting them to the Exasol support is more efficient.
Details
Log information is discarded if a statement finished without an error and is running faster than 5 seconds. In some support cases, this might not be sufficient for analysis, so the full logging can be enabled temporarily.
If more detailed log information is required, the support team will ask you to:
1. CONTROL SET TRACE LEVEL NOTICE WITH LOG TIMEOUT 0;
2. Rerun SQL statement to investigate
3. CONTROL SET TRACE LEVEL NOTICE WITH LOG TIMEOUT 5;
Please keep in mind to reset the log timeout (step 3 above) to avoid creating unnecessary big logfiles permanently.
