JIRA throws "JIRA is having difficulty contacting <application name>. If this condition persists, please contact your JIRA administrators." in the Development Panel
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
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.
- Shut down JIRA
- Make a full backup of your database.
Run the following command against the database:
ALTER USER jirauser SET search_path TO jira,public;Remember to replace 'jirauser' with your actual JIRA database username and replace 'jira' with your actual JIRA database schema name
Restart JIRA
Last modified on Dec 17, 2020
Powered by Confluence and Scroll Viewport.