Problem with starting up jira. How to ignore the warning below and start jira.

Question

The following warnings should be fixed, but you can choose to ignore them and continue starting JIRA.

Database: Your database is using an unsupported collation

Your postgres72 database is currently using an unsupported collation: en_US.UTF-8. You should change this to a supported collation:

* POSIX.UTF-8
* C.UTF-8
* C
* POSIX

Review our documentation for more information on supported collations.

Learn more

Shannon S · Answer

Maciej,

Happy I was able to assist you!

Take care and Kind Regards,
Shannon

Maciej Pietrzak · Answer

Hi Shannon,

Thank You for help ! My Jira is up and working again.

Kind Regards

Maciek

Shannon S · Answer

Hi Maciej,

I see the warning but then also the error at the bottom about duplicate records which may be your issue.

Also, Azure is supported for Jira Data Center, and only using Azure SQL. For more information see Getting started with Jira Data Center on Azure. Without this configuration you may find that Jira might not work properly on Azure.

At any rate, I would try removing the duplicate keys using this article:

Jira fails to start due to multiple entries with the same key

* According to the error message above, there are 2 entries with the same key sd.custom.notification.batch.send

You'll want to look in the clusterdjob table to find the id for the job and delete one.

Let me know if you have any trouble.

Kind Regards,
Shannon