JIRA throws "JIRA is having difficulty contacting <application name>. If this condition persists, please contact your JIRA administrators." in the Development Panel

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

Problem

Development Panel is shows the following error message

JIRA is having difficulty contacting <application name>. If this condition persists, please contact your JIRA administrators.".


The following appears in the atlassian-jira.log

2016-07-01 10:07:34,109 http-nio-8080-exec-20 WARN admin 607x7641x1 c6nx2q <application name>.168.21.50 /rest/dev-status/1.0/issue/summary [c.a.j.p.devstatus.provider.DefaultCoordinator] <application name> (com.mysema.query.QueryException: Caught PSQLException for update "AO_575BF5_PROVIDER_ISSUE"
    set "STALE_AFTER" = ? where "AO_575BF5_PROVIDER_ISSUE"."PROVIDER_SOURCE_ID" = ? and "AO_575BF5_PROVIDER_ISSUE"."ISSUE_ID" = ?)
2016-07-01 10:08:19,601 http-nio-8080-exec-14 WARN admin 608x7647x1 c6nx2q <application name>.168.21.50 /rest/dev-status/1.0/issue/summary [c.a.j.p.devstatus.provider.DefaultCoordinator] <application name> (com.mysema.query.QueryException: Caught PSQLException for update "AO_575BF5_PROVIDER_ISSUE"
    set "STALE_AFTER" = ? where "AO_575BF5_PROVIDER_ISSUE"."PROVIDER_SOURCE_ID" = ? and "AO_575BF5_PROVIDER_ISSUE"."ISSUE_ID" = ?)
2016-07-01 10:09:17,256 http-nio-8080-exec-6 WARN admin 609x7652x1 wkd3d 135.128.216.55,<application name>.168.20.54 /rest/dev-status/1.0/issue/summary [c.a.j.p.devstatus.provider.DefaultCoordinator] <application name> (com.mysema.query.QueryException: Caught PSQLException for update "AO_575BF5_PROVIDER_ISSUE"
    set "STALE_AFTER" = ? where "AO_575BF5_PROVIDER_ISSUE"."PROVIDER_SOURCE_ID" = ? and "AO_575BF5_PROVIDER_ISSUE"."ISSUE_ID" = ?)
2016-07-01 10:09:37,805 http-nio-8080-exec-4 WARN admin 609x7672x1 1cov17f <application name>.168.21.125 /rest/dev-status/1.0/issue/summary [c.a.j.p.devstatus.provider.DefaultCoordinator] <application name> (com.mysema.query.QueryException: Caught PSQLException for update "AO_575BF5_PROVIDER_ISSUE"
    set "STALE_AFTER" = ? where "AO_575BF5_PROVIDER_ISSUE"."PROVIDER_SOURCE_ID" = ? and "AO_575BF5_PROVIDER_ISSUE"."ISSUE_ID" = ?)
2016-07-01 10:09:40,364 http-nio-8080-exec-12 WARN admin 609x7710x1 1cov17f <application name>.168.21.125 /rest/dev-status/1.0/issue/summary [c.a.j.p.devstatus.provider.DefaultCoordinator] <application name> (com.mysema.query.QueryException: Caught PSQLException for update "AO_575BF5_PROVIDER_ISSUE"
    set "STALE_AFTER" = ? where "AO_575BF5_PROVIDER_ISSUE"."PROVIDER_SOURCE_ID" = ? and "AO_575BF5_PROVIDER_ISSUE"."ISSUE_ID" = ?)
2016-07-01 10:09:40,458 http-nio-8080-exec-20 WARN admin 609x7715x1 1cov17f <application name>.168.21.125 /rest/dev-status/1.0/issue/summary [c.a.j.p.devstatus.provider.DefaultCoordinator] <application name> (com.mysema.query.QueryException: Caught PSQLException for update "AO_575BF5_PROVIDER_ISSUE"
    set "STALE_AFTER" = ? where "AO_575BF5_PROVIDER_ISSUE"."PROVIDER_SOURCE_ID" = ? and "AO_575BF5_PROVIDER_ISSUE"."ISSUE_ID" = ?)
2016-07-01 10:10:51,465 http-nio-8080-exec-3 WARN admin 610x7787x1 rce4u0 153.57.226.194 /rest/dev-status/1.0/issue/summary [c.a.j.p.devstatus.provider.DefaultCoordinator] <application name> (com.mysema.query.QueryException: Caught PSQLException for update "AO_575BF5_PROVIDER_ISSUE"
    set "STALE_AFTER" = ? where "AO_575BF5_PROVIDER_ISSUE"."PROVIDER_SOURCE_ID" = ? and "AO_575BF5_PROVIDER_ISSUE"."ISSUE_ID" = ?)
2016-07-01 10:10:56,903 http-nio-8080-exec-18 WARN admin 610x7821x1 rce4u0 153.57.226.194 /rest/dev-status/1.0/issue/summary [c.a.j.p.devstatus.provider.DefaultCoordinator] <application name> (com.mysema.query.QueryException: Caught PSQLException for update "AO_575BF5_PROVIDER_ISSUE"
    set "STALE_AFTER" = ? where "AO_575BF5_PROVIDER_ISSUE"."PROVIDER_SOURCE_ID" = ? and "AO_575BF5_PROVIDER_ISSUE"."ISSUE_ID" = ?)
2016-07-01 10:11:01,613 http-nio-8080-exec-7 WARN admin 611x7856x1 rce4u0 153.57.226.194 /rest/dev-status/1.0/issue/summary [c.a.j.p.devstatus.provider.DefaultCoordinator] <application name> (com.mysema.query.QueryException: Caught PSQLException for update "AO_575BF5_PROVIDER_ISSUE"
    set "STALE_AFTER" = ? where "AO_575BF5_PROVIDER_ISSUE"."PROVIDER_SOURCE_ID" = ? and "AO_575BF5_PROVIDER_ISSUE"."ISSUE_ID" = ?)
2016-07-01 10:11:51,422 http-nio-8080-exec-14 WARN admin 611x7867x1 c6nx2q <application name>.168.21.50 /rest/dev-status/1.0/issue/summary [c.a.j.p.devstatus.provider.DefaultCoordinator] <application name> (com.mysema.query.QueryException: Caught PSQLException for update "AO_575BF5_PROVIDER_ISSUE"
    set "STALE_AFTER" = ? where "AO_575BF5_PROVIDER_ISSUE"."PROVIDER_SOURCE_ID" = ? and "AO_575BF5_PROVIDER_ISSUE"."ISSUE_ID" = ?)

Cause

The JIRA DB user was excluded from the database search scope.

Resolution

Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.

  1. Shut down JIRA
  2. Make a full backup of your database.
  3. Run the following command against the database:

    ALTER USER jirauser SET search_path TO jira,public;
    tip/resting Created with Sketch.

    Remember to replace 'jirauser' with your actual JIRA database username and replace 'jira' with your actual JIRA database schema name

  4. Restart JIRA



Last modified on Dec 17, 2020

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.