COLLATE' is set to 'c'. Should be 'C'

[wrenix]

Description

Synapse has an collate and ctype check which does not work correct.

Steps to reproduce

• create database with sql
• start synapse

Homeserver

my

Synapse Version

v1.100.0

Installation Method

Docker (matrixdotorg/synapse)

Database

postgres

Workers

Single process

Platform

K3s single node

Configuration

Database was created with this SQL:

CREATE DATABASE "matrix-synapse" LC_COLLATE='C' LC_CTYPE='C' ENCODING=UTF8 TEMPLATE=template0

Relevant log output

synapse.storage.engines._base.IncorrectDatabaseSetup: Database is incorrectly configured:                                              
                                                                                                                                            
         - 'COLLATE' is set to 'c'. Should be 'C'                                                                                           
         - 'CTYPE' is set to 'c'. Should be 'C'                                                                                             
                                                                                                                                            
     See docs/postgres.md for more information.

Anything else that would be useful to know?

No response

[reivilibre]

What platform is your Postgres database running on? Over many years I don't think we've seen this. And indeed it seems like you created it with an uppercase C so it's sort of odd that it'd report it back as lowercase.

[wrenix]

that depends on how you create the database, by commandline createdb it is uppercase on sql CREATE DATABASE "matrix-synapse" LC_COLLATE='C' LC_CTYPE='C' ENCODING=UTF8 TEMPLATE=template0 it is lowercase.

---

the answer of your question is Kubernetes and the version 16.3

[reivilibre]

Is it a specific docker image that it's running in, that is public/you can share?

I can't reproduce at all locally; if I create with CREATE DATABASE it comes out uppercase, SELECT datcollate, datctype FROM pg_database WHERE datname = current_database();

If I try to create it lowercase, I even get told it's an invalid locale.

[wrenix]

hmm, okay my init database script was dirty and it call:

CREATE DATABASE "matrix-synapse" LC_COLLATE="c" LC_CTYPE="c" ENCODING=UTF8 TEMPLATE=template0

do you like to check that in your script either? Or just close that issue?

[devonh]

It seems like we can close this issue since the database was being created using the lowercase c.