-
Bug
-
Resolution: Fixed
-
Medium (View bug fix roadmap)
-
6.7.12, 7.2.3, 7.2.8, 7.13.0, 7.6.10
-
None
-
JIRA 6.3.14
-
6.07
-
22
-
Severity 2 - Major
-
94
-
Summary
Loading time for Kanban board with default work subfilter is longer.
Default work subfilter with UnreleasedVersions():
fixVersion in unreleasedVersions() OR fixVersion is EMPTY
Calls to /rest/greenhopper/1.0/xboard/work/allData.json are more slow with default work subfilter.
Environment
- Instances with large number of Versions are affected, example: 10k+
Steps to Reproduce
- Load board
Expected Results
Loading board doesn't degrade with number of version in other project (in whole JIRA)
Actual Results
Loading board takes longer when there is a higher number of version in other project (in whole JIRA).
Notes
See related KB: Kanban board loading is slow
Some improvements have already been done in GHS-9611, JRA-38883, JRASERVER-62666
Original data from user
Here are some system stats
Total versions: 23792 Of the total, 20616 are *unreleased*. JIRA issues: 1.5 million Projects: 660
Here's a before and after load time in seconds when we delete the work subfilter:
11.7050 https://jira/rest/greenhopper/1.0/xboard/work/allData.json 11.3350 https://jira/rest/greenhopper/1.0/xboard/work/allData.json --- delete work subfilter --- 3.0680 https://jira/rest/greenhopper/1.0/xboard/work/allData.json 3.1440 https://jira/rest/greenhopper/1.0/xboard/work/allData.json 3.0290 https://jira/rest/greenhopper/1.0/xboard/work/allData.json 3.1320 https://jira/rest/greenhopper/1.0/xboard/work/allData.json
Workaround
- Delete Kanban board sub-filter if you don't need versions
- If you need version, add specific project(s) related to JQL filter for the board into unreleasedVersions function
fixVersion in unreleasedVersions(ProjA, ProjB) OR fixVersion is EMPTY
- is caused by
-
JRASERVER-69009 DeterminedProjectsInQueryVisitor doesn't work for default Kanban sub-query
-
- Closed
-
- is related to
-
JSWSERVER-11807 No Sub-Filter on New Kanban Board Creation
- Closed
- relates to
-
JSWSERVER-16401 Having a huge set of versions causes Boards to break
-
- Closed
-
- mentioned in
-
Page Failed to load
-
Page Failed to load
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
Hi everyone!
I'm glad to announce that we've made a significant progress regarding performance of unreleasedVersions().
We've resolved following issues during our work on Jira 8.4:
We believe these fixes will address majority of causes for the described problem. As this issue is pretty broad we are closing this issue. If you keep witnessing the problem please comment on this ticket or create a new one describing your specific case
–
Ilya Zinoviev
Jira Development