Details
-
Bug
-
Resolution: Fixed
-
High
-
None
-
Severity 3 - Minor
-
Description
Summary
When selecting multiple filters for the scope view (releases, teams, teams etc..) without waiting for the plan to load the backlog search breaks and an exception is thrown.
Steps to Reproduce
- Open your Portfolio plan
- On the scope view select multiple filters at once (releases, teams, teams etc..)
Expected Results
The scope should reload applying the selected filters.
Actual Results
The backlog calls return a 500 error and an exception is thrown.
Exception:
Caught PSQLException for select "full_query"."issuesources", "full_query"."props_jpo_parent_id", "full_query"."props_team_id", "full_query"."props_later_release", "full_query"."props_earliest_start", "full_query"."props_distribution", "full_query"."props_resources", "full_query"."props_themes", "full_query"."props_excluded_from_plan", "full_query"."props_original_distribution", "full_query"."props_original_storypoints", "full_query"."props_baseline_start", "full_query"."props_baseline_end", "full_query"."jiraissue_id", "full_query"."jiraissue_keynumpart", "full_query"."jiraissue_assignee", "full_query"."jiraissue_description", "full_query"."jiraissue_project_id", "full_query"."jiraissue_resolution_date", "full_query"."jiraissue_status", "full_query"."jiraissue_summary", "full_query"."jiraissue_time_estimate", "full_query"."jiraissue_original_time_estimate", "full_query"."jiraissue_time_spent", "full_query"."jiraissue_type", "full_query"."jiraissue_due_date", "full_query"."issue_external_fix_versions", "full_query"."issue_external_story_points", "full_query"."issue_external_sprint", "full_query"."issue_external_linked_parent", "full_query"."issue_external_components", "full_query"."issue_external_labels", "full_query"."issue_customfields_ids", "full_query"."issue_customfields_string_values", "full_query"."issue_customfields_text_values", "full_query"."issue_customfields_number_values", "full_query"."issue_customfields_date_values", "full_query"."scen_item_key", "full_query"."scen_scenario_id", "full_query"."scen_scenario_type", "full_query"."scen_title", "full_query"."scen_title_changed", "full_query"."scen_description", "full_query"."scen_description_changed", "full_query"."scen_time_estimate", "full_query"."scen_time_estimate_changed", "full_query"."scen_orig_time_estimate", "full_query"."scen_orig_time_estimate_changed", "full_query"."scen_storypoint_estimate", "full_query"."scen_storypoint_estimate_changed", "full_query"."scen_team", "full_query"."scen_team_changed", "full_query"."scen_parent", "full_query"."scen_parent_changed", "full_query"."scen_version", "full_query"."scen_version_changed", "full_query"."scen_project", "full_query"."scen_project_changed", "full_query"."scen_type", "full_query"."scen_type_changed", "full_query"."scen_status", "full_query"."scen_status_changed", "full_query"."scen_later_release", "full_query"."scen_later_release_changed", "full_query"."scen_resources_changed", "full_query"."scen_distribution", "full_query"."scen_distribution_changed", "full_query"."scen_theme", "full_query"."scen_theme_changed", "full_query"."scen_sprint", "full_query"."scen_sprint_changed", "full_query"."scen_earliest_start", "full_query"."scen_earliest_start_changed", "full_query"."scen_resources", "full_query"."scen_components_changed", "full_query"."scen_components", "full_query"."scen_labels_changed", "full_query"."scen_labels", "full_query"."scen_baseline_start", "full_query"."scen_baseline_start_changed", "full_query"."scen_baseline_end", "full_query"."scen_baseline_end_changed", "full_query"."scen_due_date", "full_query"."scen_due_date_changed", "full_query"."scen_original_storypoints", "full_query"."scen_original_storypoints_changed", "full_query"."scen_original_distribution", "full_query"."scen_original_distribution_changed", "full_query"."scen_issue_customfields_ids", "full_query"."scen_issue_customfields_string_values", "full_query"."scen_issue_customfields_text_values", "full_query"."scen_issue_customfields_number_values", "full_query"."scen_issue_customfields_date_values", "full_query"."lexorank_actual", "full_query"."lexorank_original", "full_query"."completed_dependency", "full_query"."completed_parent", "full_query"."valid_filter_condition", "full_query"."issue_links_scenario_to", "full_query"."issue_links_scenario_link_type", "full_query"."issue_links_scenario_type", "full_query"."issue_links_to", "full_query"."issue_links_link_type", "full_query"."assignments_project", "full_query"."assignments_interval_start", "full_query"."assignments_interval_end", "full_query"."assignments_resource", "full_query"."assignments_team", "full_query"."assignments_stage", "full_query"."assignments_skill", "full_query"."assignments_version", "full_query"."assignments_sprint_index", "full_query"."assignments_workload", "full_query"."initial_select_total_count" from (with "complete_backlog" as (with "issue" as (select array_agg("issues_by_source"."issuesource") as "issuesources", "issues_by_source"."jiraissue_id", "issues_by_source"."jiraissue_item_key", "issues_by_source"."jiraissue_keynumpart", "issues_by_source"."jiraissue_assignee", "issues_by_source"."jiraissue_description", "issues_by_source"."jiraissue_project_id", "issues_by_source"."jiraissue_resolution_date", "issues_by_source"."jiraissue_status", "issues_by_source"."jiraissue_summary", "issues_by_source"."jiraissue_time_estimate", "issues_by_source"."jiraissue_original_time_estimate", "issues_by_source"."jiraissue_time_spent", "issues_by_source"."jiraissue_type", "issues_by_source"."jiraissue_due_date" from (select "ISSUE"."id" as "jiraissue_id", "ISSUE"."id"::text as "jiraissue_item_key", "ISSUE"."issuenum" as "jiraissue_keynumpart", "ISSUE"."assignee" as "jiraissue_assignee", "ISSUE"."description" as "jiraissue_description", "ISSUE"."project" as "jiraissue_project_id", "ISSUE"."resolutiondate" as "jiraissue_resolution_date", "ISSUE"."issuestatus" as "jiraissue_status", "ISSUE"."summary" as "jiraissue_summary", "ISSUE"."timeestimate" as "jiraissue_time_estimate", "ISSUE"."timeoriginalestimate" as "jiraissue_original_time_estimate", "ISSUE"."duedate" as "jiraissue_due_date", "ISSUE"."timespent" as "jiraissue_time_spent", "ISSUE"."issuetype"::bigint as "jiraissue_type", "issuesource" from ((select "ISSUE"."id", "ISSUE"."pkey", "ISSUE"."issuenum", "ISSUE"."project", "ISSUE"."reporter", "ISSUE"."assignee", "ISSUE"."creator", "ISSUE"."issuetype", "ISSUE"."summary", "ISSUE"."description", "ISSUE"."environment", "ISSUE"."priority", "ISSUE"."resolution", "ISSUE"."issuestatus", "ISSUE"."created", "ISSUE"."updated", "ISSUE"."duedate", "ISSUE"."resolutiondate", "ISSUE"."votes", "ISSUE"."watches", "ISSUE"."timeoriginalestimate", "ISSUE"."timeestimate", "ISSUE"."timespent", "ISSUE"."workflow_id", "ISSUE"."security", "ISSUE"."denormalised_subtask_parent", "ISSUE"."subtask_parent_id", "ISSUE"."effective_subtask_parent_id", "ISSUE"."fixfor", "ISSUE"."component", 11::bigint as "issuesource" from "public"."jiraissue" "ISSUE" where "ISSUE"."id" in (select "ISSUE"."id" from "public"."jiraissue" "ISSUE" where /* com.atlassian.jira.jql.dbquery.IssueTypeDbQueryFactory */ ("ISSUE"."issuetype" in (?, ?, ?, ?, ?, ?)) and /* .....
Caused by:
Caused by: org.postgresql.util.PSQLException: ERROR: canceling statement due to statement timeout
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2477)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2190)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:169)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:117)
at sun.reflect.GeneratedMethodAccessor399.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.vibur.dbcp.proxy.AbstractInvocationHandler.targetInvoke(AbstractInvocationHandler.java:145)
at org.vibur.dbcp.proxy.StatementInvocationHandler.newProxiedResultSet(StatementInvocationHandler.java:163)
at org.vibur.dbcp.proxy.StatementInvocationHandler.doProcessExecute(StatementInvocationHandler.java:202)
at org.vibur.dbcp.proxy.StatementInvocationHandler.on(StatementInvocationHandler.java:195)
at com.atlassian.jira.connpool.JiraViburConnectionPoolProvider.lambda$null$5(JiraViburConnectionPoolProvider.java:147)
at org.vibur.dbcp.proxy.StatementInvocationHandler.processExecute(StatementInvocationHandler.java:137)
at org.vibur.dbcp.proxy.StatementInvocationHandler.restrictedInvoke(StatementInvocationHandler.java:91)
at org.vibur.dbcp.proxy.StatementInvocationHandler.restrictedInvoke(StatementInvocationHandler.java:41)
at org.vibur.dbcp.proxy.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:81)
at com.sun.proxy.$Proxy4934.executeQuery(Unknown Source)
at com.querydsl.sql.AbstractSQLQuery.fetch(AbstractSQLQuery.java:446)
... 360 more
Notes
The issue is not reproducible in all plans and it may happen just by opening plans depending on the amount of issues.