Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-10990

Slow response times for non-admin Jira users when querying Insight objects via REST API

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Medium Medium
    • None
    • 4.20.0, 4.20.11

      Issue Summary

      When loading objects by REST API, non-admin users may see a slower response time (1.5x to 3x as long on average) than Jira Administrators.

      This behavior also occurs when searching for and loading objects in the Insight UI.

      Steps to Reproduce

      Although this behavior occurs in the Jira UI as well, it is easy to demonstrate via the REST API. Query 5,000 issues via REST, for example:

      curl '<jira_base_url>/rest/insight/1.0/iql/objects?iql=Id%20LIKE%20%22CVE%22%20ORDER%20BY%20Updated%20DESC&resultPerPage=5000' -H 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:95.0) Gecko/20100101 Firefox/95.0' -H 'Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8' -H 'Accept-Language: en-US,en;q=0.5' -H 'Accept-Encoding: gzip, deflate, br' -H 'Connection: keep-alive' -H 'Upgrade-Insecure-Requests: 1' -H 'Sec-Fetch-Dest: document' -H 'Sec-Fetch-Mode: navigate' -H 'Sec-Fetch-Site: none' -H 'Sec-Fetch-User: ?1' -H 'Cache-Control: max-age=0' --output result.json
      
      1. Using a REST client, first specify credentials for a user with Jira Administrators permission.
      2. Perform the same query with credentials for a user without that permission, but with the same Insight Object Schema and Object Type permission levels.

      Expected Results

      The time taken to complete the queries should be similar in both cases.

      Actual Results

      The total request time takes 1.5x to 3x longer for the user without Jira Administrators permission.

      This is particularly noticeable on environments where there are many object references.

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available.

              Unassigned Unassigned
              nparks@atlassian.com Nathan Parks
              Affected customers:
              18 This affects my team
              Watchers:
              16 Start watching this issue

                Created:
                Updated: