Uploaded image for project: 'Jira Cloud'
  1. Jira Cloud
  2. JRACLOUD-82260

"Get all labels" endpoint performance problem.

    XMLWordPrintable

Details

    Description

      Issue Summary

      The Get all labels endpoint fails with a 500 status, even when using pagination containing small batches. This is due to a timeout on the backend when an instance has a high number of label associations along with the permission query that it needs to perform as part of the endpoint.

      Steps to Reproduce

      • Execute the API on the site having large number of Labels
      • It has been observed that the search will fail if the number of labels are > 1,00,000 distinct labels

      Expected Results

      The endpoint should bring the referred labels, paginated as expected, or even without pagination.

      Actual Results

      Internal logs show that the 500 status is due to a timeout on the permission query it needs to perform, as it's very complex

      Workaround

      No workaround available.The search is failing even with the maxResults.

      Attachments

        Activity

          People

            Unassigned Unassigned
            d80b1397fd0f Guilherme Barbosa Lima
            Votes:
            16 Vote for this issue
            Watchers:
            14 Start watching this issue

            Dates

              Created:
              Updated: