Uploaded image for project: 'Jira Software Data Center'
  1. Jira Software Data Center
  2. JSWSERVER-13701

JIRA "View on Board" link GHGoToBoard response time degrades with number of boards

XMLWordPrintable

    • 6.07
    • 132
    • Severity 2 - Major
    • 176
    • Hide

      Hey Jira folks,

      We are glad to announce that this issue will be addressed in one of the incoming releases -> 9.0. We’ve replaced the old way of viewing issues on boards with an entirely new experience aimed at improving the responsiveness of searching for boards that display a particular issue.
      Now, instead of searching through every board in the system, Jira will only search the boards that make explicit mention of an issue’s project key and the boards you viewed recently. This way, you’ll get more meaningful results much quicker than before.

      Thanks, 

      Andrzej Kotas

      Product Manager
      Jira Data Center

      Show
      Hey Jira folks, We are glad to announce that this issue will be addressed in one of the incoming releases -> 9.0. We’ve replaced the old way of viewing issues on boards with an entirely new experience aimed at improving the responsiveness of searching for boards that display a particular issue. Now, instead of searching through every board in the system, Jira will only search the boards that make explicit mention of an issue’s project key and the boards you viewed recently. This way, you’ll get more meaningful results much quicker than before. Thanks,  Andrzej Kotas Product Manager Jira Data Center

      NOTE: This bug report is for JIRA Software Server. Using JIRA Software Cloud? See the corresponding bug report.

      Summary

      View on board call (GHGoToBoard.jspa) iterates over all boards the user performing the lookup has access to and executes them one by one to check if given issue belongs to it. So by design View on board performance will degrade with increasing numbers of boards. This is also multiplied by the complexity of each Board's JQL.

      Steps to Reproduce

      1. Create Jira with many issues (> 500k)
      2. Create many boards (> 1000)
      3. Go to View on board link at any issue.

      Expected Results

      Call executed within 1 minute. It's JScript timeout.

      Actual Results

      Call times out with Communications breakdown error. If you open the link in a new tab it might take 200 secs.

      Note on fix

      A new "Find on Board" functionality had been introduced.
      We’ve replaced the old way of viewing issues on boards with an entirely new experience aimed at improving the responsiveness of searching for boards that display a particular issue.

      Now, instead of searching through every board in the system, Jira will only search the boards that make explicit mention of an issue’s project key and the boards you viewed recently. This way, you’ll get more meaningful results much quicker than before.

      What has changed:

      • We are not searching through all of boards that user has access to
      • Search is limited to:
        • Boards that make explicit mention of an issue’s project key (project-centric);
        • Recently viewed boards;
        • Maximum amount of 100 boards;

      Workaround

      1. Increase AJAX calls timeout
      2. If possible, reduce the number of boards and their complexity:
        • Check scrum boards. Check the sprint dates for the current/last sprint. If a project is inactive then it is highly likely that sprints have not been planned in the recent few months.
        • Check kanban board. Run the created/resolved chart for the filter/project in that Kanban board and see. Again, if the project is inactive then not many new issues would had been created in recent past.
        • Check empty JQL board.
        • The list of JQL filters associated with all Boards can be retrieved running the below query: 
          select rv."ID", rv."NAME", sr.reqcontent from searchrequest sr, "AO_60DB71_RAPIDVIEW" rv where rv."SAVED_FILTER_ID" = sr.id;
      3. Disable the View on board functionality:
        • Block calls to /secure/GHGoToBoard.jspa at proxy level
        • please see example for Apache Httpd: 
          RewriteEngine On
RewriteRule ^/secure/GHGoToBoard.jspa - [F]
        • for nginx 
            # Blocked GHGoToBoard because of severe performance impact. Links
  # are not supposed to be accessible but people seem to keep find them.
  location = /secure/GHGoToBoard.jspa {
    error_page 403 /403-page-disabled.html;
    return 403;
  }

        1. View_on_board.png
          View_on_board.png
          65 kB
        2. View All Boards.png
          View All Boards.png
          25 kB

              b6cf9181bff6 Krystian M
              ayakovlev@atlassian.com Andriy Yakovlev [Atlassian]
              Votes:
              106 Vote for this issue
              Watchers:
              133 Start watching this issue

                Created:
                Updated:
                Resolved: