Uploaded image for project: 'Bitbucket Data Center'
  1. Bitbucket Data Center
  2. BSERV-8888

Caching of groups insufficient for very large user directories

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Low Low
    • 4.8.0
    • 4.7.1
    • None

      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.

          Form Name

            [BSERV-8888] Caching of groups insufficient for very large user directories

            Owen made changes -
            Workflow Original: Stash Workflow - Restricted [ 1446113 ] New: JAC Bug Workflow v3 [ 3134484 ]
            Christian made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: In Progress [ 3 ] New: Closed [ 6 ]
            Adam Ahmed (Inactive) made changes -
            Rank New: Ranked lower
            Adam Ahmed (Inactive) made changes -
            Sprint New: Lemonheads 4.8 Sprint 2 [ 3266 ]
            Owen made changes -
            Workflow Original: Stash Workflow [ 1423710 ] New: Stash Workflow - Restricted [ 1446113 ]
            Christian made changes -
            Fix Version/s New: 4.8.0 [ 62178 ]
            Adam Ahmed (Inactive) made changes -
            Status Original: Open [ 1 ] New: In Progress [ 3 ]
            Adam Ahmed (Inactive) made changes -
            Labels New: lemonheads
            Adam Ahmed (Inactive) made changes -
            Status Original: Needs Triage [ 10030 ] New: Open [ 1 ]
            Christian made changes -
            Remote Link New: This issue links to "Bitbucket Server › Pull Request Build › bugfix-BSERV-8888-caching-of-groups (server-syd-bamboo)" [ 181543 ]

              crolf Christian
              crolf Christian
              Affected customers:
              0 This affects my team
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: