Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Jira Core Data Center on AWS - Collation Issue

Hello!
Currently running the Jira Data Center on AWS with the Cloudformation template found here: https://aws.amazon.com/quickstart/architecture/jira/

 

It uses the following playbooks located here: https://bitbucket.org/atlassian/dc-deployments-automation/src

 

The install seemed to be going well until I tested an upgrade from 7.13.3 to 7.13.5. After the node came back up with the new version of 7.13.5 I attempted to login and an error msg appeared (not sure why its displaying postgres72 as we are on postgres96) that said:

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


Along with a button that allowed me to proceed and ignore the error. Is this safe to ignore this msg? Or does the following deployment configuration found in the data center deployments automation repo need to change to a supported collation type? It is currently defaulting to `en_US.UTF-8` which according to documentation and the error msg I received, is unsupported by Jira.


https://bitbucket.org/atlassian/dc-deployments-automation/src/088239cba8c4604fb67179196334ec35a47ce71a/group_vars/aws_node_local.yml?at=master#lines-73


Any help on this would be very much appreciated. Thank you! 

1 answer

1 accepted

I was able to remediate this error by adding the following to the /etc/atl file in the cfn template as these are the settings required for Jira Core according to the above docs and recreating the stack.

- "ATL_JDBC_COLLATION=C"
-
"ATL_JDBC_CTYPE=C"
-
"ATL_JDBC_ENCODING=UNICODE"
-
"ATL_JDBC_TEMPLATE=template0"

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

3,955 views 11 5
Join discussion

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you