Database Collation health check fails with PostgreSQL in Jira server
Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.
About the Health Check
More about this Health Check.
Understanding the Results
Icon | Result | 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. |
Resolution
To fix this, the database collation needs to be corrected. The best and recommended way to achieve this is:
- Create a new database with the required collation as per the appropriate documentation in Connecting JIRA to a Database.
- 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 Collations | How to Verify Database Collations |
---|---|---|
|
If a table collation is not set, 'DEFAULT' will be returned by this SQL, which the Health Check will accept. |
|