Boards displaying "ERROR Failed to execute search" and unable to query the DB

XMLWordPrintable

    • Severity 3 - Minor

      Summary

      Boards displaying "ERROR Failed to execute search".

      Environment

      • Jira Cloud

      Steps to Reproduce

      1. Open a Software board

      Expected Results

      Boards are loaded

      Actual Results

      Logs

      message: Foreground search threw Exception [ http://tkp.to/qcc372iRYZhr ]	
	logger: com.atlassian.jira.issue.search.providers.SearchModeExecutor	
 err: {	[-]	
     class: [	[+]	
     ]	
     msg: com.querydsl.core.QueryException: Caught PSQLException for /* query_source:"JQL SEARCH ABOVE THRESHOLD" */ 
select "ISSUE"."id", /* com.atlassian.jira.jql.dbquery.StringCustomFieldClauseDbQueryFactory */ case when exists (select 1
from "public"."fieldscope" "FIELD_SCOPE"
where "FIELD_SCOPE"."project_id" = "ISSUE"."project" and "FIELD_SCOPE"."issue_type_id" = "ISSUE"."issuetype" and "FIELD_SCOPE"."field_id" = ?) then "cfv10011"."stringvalue" else null end, /* com.atlassian.jira.jql.dbquery.AssigneeDbQueryFactory */ case when exists (select 1
from "public"."fieldscope" "FIELD_SCOPE"
where "FIELD_SCOPE"."project_id" = "ISSUE"."project" and "FIELD_SCOPE"."issue_type_id" = "ISSUE"."issuetype" and "FIELD_SCOPE"."field_id" = ?) then "ISSUE"."assignee" else null end, /* com.atlassian.jira.jql.dbquery.IssueKeyDbQueryFactory */ "ISSUE"."pkey" || '-' || "ISSUE"."issuenum", /* com.atlassian.jira.jql.dbquery.PriorityClauseDbQueryFactory */ case when exists ***************

      UI (error is intermittent)

      ERROR Failed to execute search

      Console

      batch.js?agile_global_admin_condition=true&devsummary=true&is-system-admin=true&jag=true&jaguser=true&jcap=true&jira-nps-enabled=true&locale=en-US&nps-not-opted-out=true&sd_operational=true&simplifiedUxOptinAvailable=true:6310 Uncaught TypeError: Cannot read property 'getIssueList' of null
    at D (batch.js?agile_global_admin_condition=true&devsummary=true&is-system-admin=true&jag=true&jaguser=true&jcap=true&jira-nps-enabled=true&locale=en-US&nps-not-opted-out=true&sd_operational=true&simplifiedUxOptinAvailable=true:6310)
    at Object.<anonymous> (batch.js?agile_global_admin_condition=true&devsummary=true&is-system-admin=true&jag=true&jaguser=true&jcap=true&jira-nps-enabled=true&locale=en-US&nps-not-opted-out=true&sd_operational=true&simplifiedUxOptinAvailable=true:6310)
    at j (batch.js?locale=en-US:76)
    at Object.fireWith (batch.js?locale=en-US:77)
    at Object.fire [as resolve] (batch.js?locale=en-US:77)
    at batch.js?agile_global_admin_condition=true&devsummary=true&is-system-admin=true&jag=true&jaguser=true&jcap=true&jira-nps-enabled=true&locale=en-US&nps-not-opted-out=true&sd_operational=true&simplifiedUxOptinAvailable=true:5829
    at j (batch.js?locale=en-US:76)
    at Object.fireWith [as rejectWith] (batch.js?locale=en-US:77)
    at Object.<anonymous> (batch.js?agile_global_admin_condition=true&devsummary=true&is-system-admin=true&jag=true&jaguser=true&jcap=true&jira-nps-enabled=true&locale=en-US&nps-not-opted-out=true&sd_operational=true&simplifiedUxOptinAvailable=true:5050)
    at j (batch.js?locale=en-US:76)

      Notes

      Workaround

            Assignee:
            Unassigned
            Reporter:
            Paula Silveira (Inactive)
            Votes:
            2 Vote for this issue
            Watchers:
            18 Start watching this issue

              Created:
              Updated:
              Resolved: