Jira Core Data Center on AWS - Collation Issue

Christopher Mundus July 29, 2019

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

0 votes
Answer accepted
Christopher Mundus July 31, 2019

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
AUG Leaders

Atlassian Community Events