High memory usage may lead to continuous start and stop of prestarted SQL processes
Details
| Detail name | Value |
|---|---|
| Changelog Number | 8246 |
| Type | Bug |
| Status | Open |
| Affected Versions | Exasol 6.1.0, Exasol 6.2.beta1 |
In some scenarios with high memory usage resource management may try to reduce memory usage by stopping prestarted SQL processes. After this new SQL processes can be started (depending on the settings for the prestart) just to be stopped shortly after if there are no sessions waiting for a SQL process.
This may impact system performance in a negative way (e.g. slower transaction handling).