Jira Core Data Center on AWS - Collation Issue

[Christopher Mundus]

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! 

[Christopher Mundus · Accepted solution]

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"