[JSWSERVER-25334] Scrum board backlog may load all issues and potentially trigger a DB query for each issue

Type: Bug
Resolution: Duplicate
Priority: Medium (View bug fix roadmap)
Fix Version/s: 9.15.0, 10.0.0
Affects Version/s: 8.20.0, 9.4.0, 9.11.0, 9.12.0
Component/s: (Advanced Roadmaps) Plan - Teams
Labels:
- whl-fy24q4
- whl-fy25q1

Introduced in Version:
8.2
Support reference count:
5
Symptom Severity:
Severity 2 - Major
UIS:
35
Bug Fix Policy:
View Atlassian Server bug fix policy

Issue Summary

This is reproducible on Data Center: yes

Steps to Reproduce

Create a 1k issues in a project (TEST) with non-empty "team" (Advanced Roadmaps for Jira) field
Create a scrum board (TEST-BOARD) with the following filter: "project = TEST ORDER BY Rank ASC"
Add "team" to "Card Layout"
Open TEST-BOARD backlog

Expected Results

Board should open in a reasonable time and only load issues (and custom filed values) presented in the board

Actual Results

Board loads all (1000k) issues (including custom field values) where for "team" field this will trigger 2 sql query to the DB for every issue.

"http-nio-8090-exec-15 url: /jira/rest/greenhopper/1.0/xboard/plan/backlog/data.json; user: admin@76309" daemon prio=5 tid=0x23 nid=NA runnable
  java.lang.Thread.State: RUNNABLE
      at com.atlassian.rm.common.env.issues.JiraIssuePropertyService.get(JiraIssuePropertyService.java:48)
      at com.atlassian.rm.common.env.issues.JiraIssuePropertyService.get(JiraIssuePropertyService.java:36)
      at com.atlassian.rm.teams.customfields.team.TeamIssuePropertyService.getTeamId(TeamIssuePropertyService.java:25)
      at com.atlassian.rm.teams.customfields.team.IssueTeamService.getTeamForIssue(IssueTeamService.java:60)
      at com.atlassian.rm.teams.customfields.team.IssueTeamService.getTeam(IssueTeamService.java:44)
      at com.atlassian.rm.teams.customfields.team.TeamCustomFieldTypeHelper.getTeam(TeamCustomFieldTypeHelper.java:179)
      at com.atlassian.rm.teams.customfields.team.TeamCustomFieldType.getValueFromIssue(TeamCustomFieldType.java:142)
      at com.atlassian.rm.teams.customfields.team.TeamCustomFieldType.getValueFromIssue(TeamCustomFieldType.java:34)
      at com.atlassian.jira.issue.fields.ImmutableCustomField.getValue(ImmutableCustomField.java:354)
      at com.atlassian.jira.issue.DocumentIssueImpl.getCustomFieldValue(DocumentIssueImpl.java:350)
      at com.atlassian.jira.issue.fields.ImmutableCustomField.getRendererCustomFieldValue(ImmutableCustomField.java:820)
      at com.atlassian.jira.issue.fields.ImmutableCustomField.getColumnViewHtml(ImmutableCustomField.java:815)
      at com.atlassian.greenhopper.web.rapid.list.ExtraFieldsHelper.createColumnViewEntry(ExtraFieldsHelper.java:143)
      at com.atlassian.greenhopper.web.rapid.list.ExtraFieldsHelper.renderField(ExtraFieldsHelper.java:123)
      at com.atlassian.greenhopper.web.rapid.list.ExtraFieldsHelper.renderFields(ExtraFieldsHelper.java:81)
      at com.atlassian.greenhopper.web.rapid.list.ExtraFieldsCallbackComponent.processFieldData(ExtraFieldsCallbackComponent.java:33)
      at com.atlassian.greenhopper.web.rapid.list.RapidIssueEntryCallback.createVisibleEntry(RapidIssueEntryCallback.java:222)
      at com.atlassian.greenhopper.web.rapid.list.RapidIssueEntryCallback.fieldData(RapidIssueEntryCallback.java:189)
      at com.atlassian.greenhopper.service.issue.callback.AbstractCompoundDataCallback.issueComplete(AbstractCompoundDataCallback.java:41)
      at com.atlassian.greenhopper.service.issue.callback.ComposedIssueDataCallback.issueComplete(ComposedIssueDataCallback.java:64)
      at com.atlassian.greenhopper.service.issue.IssueDataLoader.collect(IssueDataLoader.java:65)
      at com.atlassian.greenhopper.service.issue.IssueDataLoader.collect(IssueDataLoader.java:38)
      at com.atlassian.greenhopper.service.issue.IssueDataServiceImpl$$Lambda$5007.486276621.accept(Unknown Source:-1)
      at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
      at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)
      at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1382)
      at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481)
      at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)
      at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
      at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
      at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
      at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:418)
      at com.atlassian.greenhopper.service.issue.IssueDataServiceImpl.findImpl(IssueDataServiceImpl.java:170)
      at com.atlassian.greenhopper.service.issue.IssueDataServiceImpl.findAndSortWithServiceOutcome(IssueDataServiceImpl.java:93)
      at com.atlassian.greenhopper.web.rapid.list.RapidIssueEntryQueryServiceImpl.collectIssues(RapidIssueEntryQueryServiceImpl.java:823)
      at com.atlassian.greenhopper.web.rapid.list.RapidIssueEntryQueryServiceImpl.collectPlanModeIssues(RapidIssueEntryQueryServiceImpl.java:373)
      at com.atlassian.greenhopper.web.rapid.plan.PlanningModeServiceImpl.getBacklogIssuesAndSprintAssignment(PlanningModeServiceImpl.java:92)
      at com.atlassian.greenhopper.web.rapid.plan.PlanningModeHelper.loadNewBacklogData(PlanningModeHelper.java:130)
      at com.atlassian.greenhopper.web.rapid.plan.PlanningModeResource.lambda$getBacklogData$0(PlanningModeResource.java:106)
      at com.atlassian.greenhopper.web.rapid.plan.PlanningModeResource$$Lambda$4972.214327275.call(Unknown Source:-1)
      at com.atlassian.greenhopper.web.util.RestCall.response(RestCall.java:38)
      at com.atlassian.greenhopper.web.AbstractResource.createResponse(AbstractResource.java:87)
      at com.atlassian.greenhopper.web.AbstractResource.response(AbstractResource.java:69)
      at com.atlassian.greenhopper.web.rapid.plan.PlanningModeResource.getBacklogData(PlanningModeResource.java:96)
      at sun.reflect.GeneratedMethodAccessor1694.invoke(Unknown Source:-1)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:498)
      at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$ResponseOutInvoker.lambda$_dispatch$0(DispatchProviderHelper.java:181)
      at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$ResponseOutInvoker$$Lambda$3597.2133231141.invoke(Unknown Source:-1)
      at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper.lambda$invokeMethodWithInterceptors$0(DispatchProviderHelper.java:81)
      at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$$Lambda$3598.1160152725.intercept(Unknown Source:-1)
      at com.atlassian.plugins.rest.common.interceptor.impl.DefaultMethodInvocation.invoke(DefaultMethodInvocation.java:53)
      at com.atlassian.plugins.rest.common.expand.interceptor.ExpandInterceptor.intercept(ExpandInterceptor.java:42)
      at com.atlassian.plugins.rest.common.interceptor.impl.DefaultMethodInvocation.invoke(DefaultMethodInvocation.java:53)
      at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper.invokeMethodWithInterceptors(DispatchProviderHelper.java:106)
      at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$ResponseOutInvoker._dispatch(DispatchProviderHelper.java:180)
...
      at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)
      at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
      at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
      at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
      at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
      at java.lang.Thread.run(Thread.java:748)

Workaround

Remove expensive custom fields (example: team) form Card Layout

is caused by

JSWSERVER-25517 Retrieving the value of Advanced Roadmap's Team custom field executes multiple slow SQL queries

Closed

relates to

JSWSERVER-25248 Portfolio Team field should be a fully supported JIRA field

Gathering Interest

is related to: PS-144174 You do not have permission to view this issue; WCAT-362 You do not have permission to view this issue

mentioned in: Page Failed to load; Page Loading...; Page Loading...; Page Loading...

(3 mentioned in)

Marc Dacanay made changes - 31/Oct/2024 6:22 AM

Labels

Original: ltsr whl-fy24q4 whl-fy25q1

New: whl-fy24q4 whl-fy25q1

Aryan Chaubal made changes - 04/Sep/2024 6:40 PM

Fix Version/s

New: 10.0.0 [ 107402 ]

Aryan Chaubal made changes - 04/Sep/2024 6:39 PM

Fix Version/s

New: 9.15.0 [ 106821 ]

Aryan Chaubal made changes - 04/Sep/2024 6:39 PM

Resolution		New: Duplicate [ 3 ]
Status	Original: Short Term Backlog [ 12074 ]	New: Closed [ 6 ]

Marc Dacanay made changes - 02/Sep/2024 12:24 AM

Status

Original: Gathering Impact [ 12072 ]

New: Short Term Backlog [ 12074 ]

Divyanshi made changes - 16/Aug/2024 5:47 AM

Remote Link

Original: This issue links to "Page (Confluence)" [ 936529 ]

Aryan Chaubal made changes - 16/Aug/2024 5:25 AM

Assignee

New: Aryan Chaubal [ 71bdbafbe765 ]

Divyanshi made changes - 13/Aug/2024 7:42 AM

Remote Link

New: This issue links to "Page (Confluence)" [ 936529 ]

Stasiu made changes - 07/Aug/2024 11:01 AM

Component/s

Original: AgileBoard [ 14190 ]

Aryan Chaubal made changes - 07/Aug/2024 5:15 AM

Remote Link

New: This issue links to "Page (Confluence)" [ 934741 ]

Assignee:: Aryan Chaubal

Reporter:: Maciej Swinarski (Inactive)

Affected customers:: 3 This affects my team

Watchers:: 10 Start watching this issue

Created:: 18/Oct/2023 9:02 AM

Updated:: 31/Oct/2024 6:22 AM

Resolved:: 04/Sep/2024 6:39 PM

Details

Description

Issue Summary

Steps to Reproduce

Expected Results

Actual Results

Workaround

Attachments

Issue Links

Forms

Activity

People

Dates