Symptoms: Attempting to load many UI page in Artifactory takes longer than 30 seconds, and timeouts can be observed as well as high CPU utilization.
Steps to reproduce:
- Artifactory 6.x (6.5.9 and 6.8.9 were used) Standalone/HA
- External (Oracle/MySQL) database
- Create at least 25,000 Artifactory users
- Create at least 125,000 Artifactory groups
- Create around 30000 permission targets
- Create around 4000 repositories with the above permissions taking affect for them
- Attempt to navigate across the UI pages e.g. --> Build Browser, the Admin -> Security -> Permissions/users/groups page, observe slow loading and high CPU
- This can also occur at a medium level of permissions, around 900.