After upgrade to Jira 7.6.4 customers with 10k+ users see major performance degradation. Jira is hitting propertyentry table up to 10x times more causing DB overload.
Problem is amplified in correlation with another issue -
- Jira 7.6.4/7.6.5 (please note that only these versions are affected from 7.6 branch) or other Affected versions
The number of requests to the propertyentry table is the same as before.
The number of requests to the propertyentry table increased 10 times.
As part of a fix for
JRASERVER-67041 users attributes cache was switched to short leaving one to eliminate the need for cluster cache replication. Some features like user picker or Jira service desk iterate many users' attributes entries and as a result DB load is increased significantly as user attributes cache is usually empty.
Set system property to revert the changes (code will work as pre-7.6.4):
- add to JVM_SUPPORT_RECOMMENDED_ARGS: