Uploaded image for project: 'Jira Software Cloud'
  1. Jira Software Cloud
  2. JSWCLOUD-19230

Selecting multiple filtering options at once throws an exception

    XMLWordPrintable

Details

    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

      1. Open your Portfolio plan
      2. 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.

      Attachments

        1. Screen Shot1.png
          Screen Shot1.png
          182 kB
        2. Screen Shot2.png
          Screen Shot2.png
          484 kB

        Issue Links

          Activity

            People

              Unassigned Unassigned
              akasper André K. (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: