MySQL Database Collation health check fails in Jira server

お困りですか?

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

コミュニティに質問

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

目的

This page goes through specifics on how to update the collation to the recommended settings for MySQL. For more details about this health check please review Database Collation Health Check fails in Jira Server

結果の確認 

The database collation '<collation>' and table collation '<collation>' are supported by JIRA.

The database is configured using a supported collation.

The database collation '<collation>' and table collation '<collation>' are not supported by JIRA.

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.

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.

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.

For MySQL Database collation issues the collation can be updated as per the steps in How to Fix the Collation and Character Set of a MySQL Database manually for an alternative option.

Supported Collations in MySQL Database

For MySQL 8.0, the supported collations are utf8mb4_bin and utf8mb4_0900_ai_ci.

The database should be configured following the documentation in Connecting JIRA applications to MySQL 8.0.

For MySQL 5.7, the supported collation is utf8mb4_bin.

The database should be configured following the documentation in Connecting JIRA applications to MySQL 5.7.

For MySQL 5.6 and below, the supported collation is utf8_bin.

The database should be configured following the documentation in Connecting JIRA applications to MySQL 5.6. Note that MySQL 5.6 is not supported in Jira 8.12 and later.

How to verify table collations

SELECT DISTINCT C.collation_name, T.table_name 
FROM   information_schema.tables AS T, 
       information_schema.`collation_character_set_applicability` AS C 
WHERE  C.collation_name = T.table_collation 
       AND T.table_schema = DATABASE();

How to verify database collations

SELECT default_collation_name 
FROM   information_schema.schemata S 
WHERE  schema_name = (SELECT DATABASE() 
                      FROM   DUAL);
説明This page goes through specifics on how to update the collation to the recommended settings for MySQL.
製品Jira
プラットフォームサーバー
最終更新日 2020 年 8 月 27 日

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

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