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

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

1 answer

0 vote

Hi Maciej,

Are you, by any chance, using a Postgres database from Amazon RDS? I've seen this message before with another user who had it, because Amazon will default the collation to your location.

If so, it's not possible to change it or choose another one from RDS, but it should work properly and the error is safe to ignore.

If you're not using AWS RDS, you can change it using this procedure:

How to fix the collation of a Postgres Jira Database.

Let us know if you have any questions.

Kind Regards,
Shannon

I installed the Jira and Postgres on Azure VM.

The problem is that i see the page with this warning and there is no way to ignore it?

http://help.itspro.com.pl:8080/secure/errors.jsp

I cannot follow the procedure from link you provided since i dont have access to my jira portal.  First step is to make XML Backup of the database.

 

Is there any way to bypass this warning. If i will get access to jira portal i can follow the procedure to change the collocation.

 

Best Regards

Maciej

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

Hi Shannon,

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

Kind Regards

Maciek

Maciej,

Happy I was able to assist you!

Take care and Kind Regards,
Shannon

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Sarah Schuster
Posted Mar 28, 2018 in Jira Software

Can a company’s culture make or break agile adoption?

Can a new-to-agile team survive and thrive in a non-agile culture? If so, what advice would you give to those trying to be agile in a non-agile culture? What's the key(s) to success? Share your thoug...

12,061 views 15 13
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you