Log server uses too much memory
Details
| Detail name | Value |
|---|---|
| Changelog Number | 19213 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 8.0.0 |
| Fix Versions | Exasol 8.25.0 |
| Resolution Date | 2024-02-15 |
Description
The log server is one of the server processes running in the database. Over time, the memory consumption of the log server steadily increases to very high values. As a result, the system may run into a low-memory state where queries fail with “System out of memory” errors and the overall performance is degraded.
The memory usage of the log server can be viewed using the following query:
select measure_time, mem_logsrv_avg, mem_logsrv_max from "$EXA_MONITOR_LAST_DAY" order by 1;
Workaround
Restart the database regularly to clear out the memory.
Fix
The log server’s memory usage remains consistent and does not steadily grow over time.