Problem
The current version of ehcache will cause memory leaks when queries are sent to the
gateway as ehcache will never clear statistics objects it creates about the queries.
There is no way to fix this in the current settings because activeJDBC locks statistis=true
Solution
This solution will update ehcache to use a new version of ehcache and activeJDBC that
does not have this issue. This also requires a change in the ehcache configuration file.
Testing:
We have made the following change in our local version of presto-gateway and have been running it in our production environment for 2 weeks without any issues and heap size has not increased.
Problem The current version of ehcache will cause memory leaks when queries are sent to the gateway as ehcache will never clear statistics objects it creates about the queries.
There is no way to fix this in the current settings because activeJDBC locks
statistis=trueSolution This solution will update ehcache to use a new version of ehcache and activeJDBC that does not have this issue. This also requires a change in the ehcache configuration file.
Testing: We have made the following change in our local version of presto-gateway and have been running it in our production environment for 2 weeks without any issues and heap size has not increased.
Issue to track this: 94