Summary

When a licensed user is member of thousands of groups, nested or otherwise, the database load can become unacceptably high for some operations.

Steps to Reproduce

1. Create a user
2. Associate the user with many groups (directly or through a user management system, e.g. JIRA, Crowd)
3. Perform any operation with that user

Expected Results

The load on the database is fine.

Actual Results

The load on the database is high. This can be checked on the Bitbucket Server side by enabling the SQL debug log level.

Workaround

Make sure that only the number of required users are available in Bitbucket Server.