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

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

プラットフォームについて: Server と Data Center のみ - この記事は、サーバーおよびデータセンター プラットフォームのアトラシアン製品にのみ適用されます。

問題

Development Panel is shows the following error message

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


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" = ?)

原因

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

ソリューション

データベースの変更を行う場合は必ず事前にバックアップを取得してください。可能な場合は、まずステージング サーバーで SQL コマンドの変更、挿入、更新、または削除を行うようにします。

  1. 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. Jira を再起動します。



最終更新日: 2020 年 12 月 17 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.