Slowness for non-admin users after upgrading Bamboo to 5.15 or above

Summary

Bamboo is slow for non-admin users when they try to perform certain actions such as:

• Log in to the application.
• Access the Bamboo dashboard (allPlans.action).
• View personal dashboard (myBamboo.action).

Environment

• Bamboo 5.15 or above.
• MySQL server (5.6.x, 5.7.x) or Oracle.
• MySQL JDBC driver version (5.1.39, 5.1.41).

Steps to Reproduce

1. Install Bamboo 5.15.5.
2. Download and install the MySQL JDBC driver.
3. Connect Bamboo to MySQL server.
4. Create ~6.000 plans and ~200 deployments in Bamboo.
5. Try navigating around with 2 different users (admin vs non-admin).

Expected Results

Pages should load in a timely fashion for both users.

Actual Results

The more we add plans, the more time it takes to load the dashboard for regular users because Bamboo has to read users permissions. For admin users Bamboo runs one single validation query.

Notes