Database Collation health check fails with PostgreSQL in Jira server

お困りですか?

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

コミュニティに質問

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

About the Health Check

More about this Health Check.

結果の確認 

アイコン

結果

What this means

The database collation '<collation>' and table collation '<collation>' are supported by JIRA. A limited number of circumstances could cause unexpected results.The database is configured using a supported collation.
The database collation '<collation>' and table collation '<collation>' are not supported by JIRA. A limited number of circumstances could cause unexpected results.

The JIRA instance is using an unsupported configuration. See the Resolution section for steps on how to resolve this issue.

The database collation '<collation>' is unsupported by JIRA. The table collation '<collation>' is supported by JIRA. A limited number of circumstances could cause unexpected results.

The JIRA instance is using an unsupported configuration. See the Resolution section for steps on how to resolve this issue.

The table collation '<collation>' is unsupported by JIRA. The database collation '<collation>' is supported by JIRA.  A limited number of circumstances could cause unexpected results.The JIRA instance is using an unsupported configuration. See the Resolution section for steps on how to resolve this issue.

ソリューション 

To fix this, the database collation needs to be corrected. The best and recommended way to achieve this is:

  1. Create a new database with the required collation as per the appropriate documentation in Connecting JIRA to a Database.
  2. Follow our Switching Databases to migrate JIRA from the old databases (with the incorrect collation) to the new one, with the correct collation.

Supported Collations in PostgreSQL Database

Collation(s)How to Verify Table CollationsHow to Verify Database Collations
  • c
  • C.UTF-8
  • POSIX
  • POSIX.UTF-8
  • en_US.UTF-8
  • English_United States:1252
SELECT DISTINCT COALESCE(collation_name, 'DEFAULT') collation_name 
FROM   information_schema.columns 
WHERE  table_schema = Current_schema();

If a table collation is not set, 'DEFAULT' will be returned by this SQL, which the Health Check will accept.

SELECT datcollate 
FROM   pg_database 
WHERE  datname = Current_database(); 

最終更新日: 2020 年 10 月 23 日

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

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