Details
-
Bug
-
Resolution: Fixed
-
Medium
-
6.3.11, 6.6.0
-
None
-
6.03
-
Description
Steps to reproduce
1. Create one Epic with 135 stories / task
2. Create story using Quick Create Issue from Epic functionality
Analysis
This request ran for ~10 minutes and accumulated 160K+ database requests to jiraissue table, only to render 137 tickets in the epic. Most of these were duplicates, i.e. the details for same 137 tickets were requested 1000 times over. For a smaller epic (5 issues), amplification is smaller (295 requests to database).
See the following profiling log:
2014-10-15 12:48:26,903 http-bio-127.0.0.1-8090-exec-11 DEBUG cpt.ahab 759x385713x1 1gv85xz 10.143.26.217,127.0.0.1 /secure/ViewIssuesInEpic.jspa [atlassian.util.profiling.UtilTimerStack] [559023ms] - /gojira/secure/ViewIssuesInEpic.jspa [38ms] - ViewIssuesInEpicAction.execute() 2014-10-15 12:48:27,073 http-bio-127.0.0.1-8090-exec-11 DEBUG capt.ahab 759x385713x1 1gv85xz 10.143.26.217,127.0.0.1 /secure/ViewIssuesInEpic.jspa [jira.web.filters.ThreadLocalQueryProfiler] RESULT GROUP: OfBizDelegator 2014-10-15 12:48:27,642 http-bio-127.0.0.1-8090-exec-11 DEBUG capt.ahab 759x385713x1 1gv85xz 10.143.26.217,127.0.0.1 /secure/ViewIssuesInEpic.jspa [jira.web.filters.ThreadLocalQueryProfiler] 161471:413001ms findByPrimaryKey [2,3,2,3,2,3,3,2,3,3,2,2,2,2,3,3,2,2,3,3,2,2,2,2,3,2,3,2,3,2 2014-10-15 12:48:27,649 http-bio-127.0.0.1-8090-exec-11 DEBUG capt.ahab 759x385713x1 1gv85xz 10.143.26.217,127.0.0.1 /secure/ViewIssuesInEpic.jspa [jira.web.filters.ThreadLocalQueryProfiler] OfBizDelegator: 161471 keys (1 unique) took 413001ms/561324ms : 73.576225% 413001ms/query avg. 2014-10-15 12:48:27,649 http-bio-127.0.0.1-8090-exec-11 DEBUG capt.ahab 759x385713x1 1gv85xz 10.143.26.217,127.0.0.1 /secure/ViewIssuesInEpic.jspa [jira.web.filters.ThreadLocalQueryProfiler] 2014-10-15 12:48:27,649 http-bio-127.0.0.1-8090-exec-11 DEBUG capt.ahab 759x385713x1 1gv85xz 10.143.26.217,127.0.0.1 /secure/ViewIssuesInEpic.jspa [jira.web.filters.ThreadLocalQueryProfiler] PROFILED : 161471 keys (1 unique) took 413001ms/561324ms : 73.576225% 2ms/query avg.
Workaround
Disable the quick issue from Epic functionality by disabling the Quick Create Issue for Epic plugins module.