-
Bug
-
Resolution: Fixed
-
High
-
6.0.0
-
Severity 2 - Major
-
In Data Center, most heavily used caches have default size limit of 25,000. Due to a typo, Hibernate query cache is set to have just 1000 maximum entries. This might increase pressure on Database in busy instances.
To make matter worse, because of https://jira.atlassian.com/browse/CONFSERVER-54777, the size of this cache cannot be increased via Cache Management UI in Confluence versions prior to 6.7.1
Expected behavior
Hibernate query cache to have default limit of 25,000
Current behavior
Hibernate query cache has a default limit of just 1000
Workaround
For Confluence versions prior to 6.7.1
- Modify the cache override file at <shared-home>/config/cache-settings-overrides.properties, make sure that this line exists:
cache.maxEntriesLocalHeap.org.hibernate.cache.internal.StandardQueryCache=25000
- Restart Confluence
For Confluence versions 6.7.1 and later
- Access Cache Management UI at <confluence-base-url>/admin/cache/showStatistics.action#fullView, adjust size of org.hibernate.cache.internal.StandardQueryCache_v5 to be 25000.
- Restart Confluence
| Form Name | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
[CONFSERVER-57963] Size of Hibernate query cache is initially set to an insufficient value in Data Center
If you're running the Confluence 6.6 Enterprise release, a fix for this issue is now available in Confluence 6.6.13, which you can find in the Download Archives.
A fix for this issue is available to Server and Data Center customers in Confluence 6.13.5
Upgrade now or check out the Release Notes to see what other issues are resolved.
If you're running the Confluence 6.6 Enterprise release, a fix for this issue is now available in Confluence 6.6.14, which you can find in the Download Archives.
If you're running the Confluence 6.13 Enterprise release, a fix for this issue is now available in Confluence 6.13.5, which you can find in the Download Archives.