ERROR: invalid locale name: "English_United States" on Postgres 9.6 K8S

[henri9813]

Hello,

I have this error for PostgreSQL 9.6 on a kubernetes cluster:

LOG:  database system was shut down at 2020-04-20 21:25:08 UTC
LOG:  MultiXact member wraparound protections are now enabled
LOG:  autovacuum launcher started
LOG:  database system is ready to accept connections
LOG:  incomplete startup packet
FATAL:  database "fusionauth" does not exist
LOG:  incomplete startup packet
FATAL:  database "fusionauth" does not exist
LOG:  incomplete startup packet
ERROR:  duplicate key value violates unique constraint "pg_database_datname_index"
DETAIL:  Key (datname)=(fusionauth) already exists.
STATEMENT:  CREATE DATABASE fusionauth ENCODING 'UTF-8' LC_CTYPE 'en_US.UTF-8' LC_COLLATE 'en_US.UTF-8' TEMPLATE template0
ERROR:  invalid locale name: "English_United States"
STATEMENT:  CREATE DATABASE fusionauth ENCODING 'UTF-8' LC_CTYPE 'English_United States' LC_COLLATE 'English_United States' TEMPLATE template0
LOG:  incomplete startup packet
ERROR:  relation "version" does not exist at character 21
STATEMENT:  select version from version
LOG:  incomplete startup packet
LOG:  incomplete startup packet

Do you have an idea to how can i fix it ? Or maybe a workaround ?

[wglambert]

Can you give all the commands you ran and any relevant files or logs for reproducing the issue

Are you using a helm chart?

[henri9813]

Hello

No i don't use helm chart, i create my own deployment

apiVersion: apps/v1
kind: Deployment
metadata:
  name: postgresql-deployment
  labels:
    app: postgresql
spec:
  replicas: 1
  selector:
    matchLabels:
      app: postgresql
  template:
    metadata:
      labels:
        app: postgresql
    spec:
      containers:
        - name: postgresql
          image: postgres:9.6
          imagePullPolicy: Always
          ports:
            - containerPort: 5432
              name: db
              protocol: TCP

May should i had some environment values for this ?

Here is the logs:

The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/lib/postgresql/data/pgdata ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default timezone ... Etc/UTC
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

Success. You can now start the database server using:

    pg_ctl -D /var/lib/postgresql/data/pgdata -l logfile start


WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
waiting for server to start....LOG:  database system was shut down at 2020-04-21 07:06:06 UTC
LOG:  MultiXact member wraparound protections are now enabled
LOG:  autovacuum launcher started
LOG:  database system is ready to accept connections
 done
server started

/usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*

LOG:  received fast shutdown request
LOG:  aborting any active transactions
LOG:  autovacuum launcher shutting down
waiting for server to shut down....LOG:  shutting down
LOG:  database system is shut down
 done
server stopped

PostgreSQL init process complete; ready for start up.

LOG:  database system was shut down at 2020-04-21 07:06:26 UTC
LOG:  MultiXact member wraparound protections are now enabled
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started


LOG:  incomplete startup packet
LOG:  incomplete startup packet
FATAL:  database "fusionauth" does not exist
FATAL:  database "fusionauth" does not exist
LOG:  incomplete startup packet
ERROR:  duplicate key value violates unique constraint "pg_database_datname_index"
DETAIL:  Key (datname)=(fusionauth) already exists.
STATEMENT:  CREATE DATABASE fusionauth ENCODING 'UTF-8' LC_CTYPE 'en_US.UTF-8' LC_COLLATE 'en_US.UTF-8' TEMPLATE template0
ERROR:  invalid locale name: "English_United States"
STATEMENT:  CREATE DATABASE fusionauth ENCODING 'UTF-8' LC_CTYPE 'English_United States' LC_COLLATE 'English_United States' TEMPLATE template0
LOG:  incomplete startup packet
ERROR:  relation "version" does not exist at character 21
STATEMENT:  select version from version
LOG:  incomplete startup packet
LOG:  incomplete startup packet
LOG:  incomplete startup packet

[henri9813]

My problem seems to have been solved, it seems to be a fusionauth issue
FusionAuth/fusionauth-issues#567

[wglambert]

Cool, closing since this is resolved then