FUMO FUNGUS on Nostr: I hate PostgreSQL, who suddenly decided to no longer for absolutely no reason # ...
I hate PostgreSQL, who suddenly decided to no longer for absolutely no reason
# PostgreSQL logs
2023-12-09 07:33:45.200 CET [719090] pleroma@pleroma LOG: statement: BEGIN
2023-12-09 07:33:45.200 CET [719090] pleroma@pleroma LOG: execute ecto_388: UPDATE "public"."oban_jobs" AS o0 SET "state" = $1, "attempted_at" = $2, "attempted_by" = $3, "attempt" = o0."attempt" + $4 WHERE (o0."id" IN (SELECT so0."id" FR
OM "public"."oban_jobs" AS so0 WHERE (so0."state" = 'available') AND (so0."queue" = $5) AND (so0."attempt" < so0."max_attempts") ORDER BY so0."priority", so0."scheduled_at", so0."id" LIMIT $6 FOR UPDATE SKIP LOCKED)) RETURNING o0."id", o0
."state", o0."queue", o0."worker", o0."args", o0."meta", o0."tags", o0."errors", o0."attempt", o0."attempted_by", o0."max_attempts", o0."priority", o0."attempted_at", o0."cancelled_at", o0."completed_at", o0."discarded_at", o0."inserted_a
t", o0."scheduled_at"
2023-12-09 07:33:45.200 CET [719090] pleroma@pleroma DETAIL: parameters: $1 = 'executing', $2 = '2023-12-09 06:33:45.200165', $3 = '{udongein}', $4 = '1', $5 = 'federator_outgoing', $6 = '2'
2023-12-09 07:33:45.200 CET [719090] pleroma@pleroma LOG: statement: COMMIT
2023-12-09 07:33:45.203 CET [1573] LOG: aborting any active transactions
2023-12-09 07:33:45.203 CET [731865] pleroma@pleroma FATAL: terminating connection due to administrator command
[...]
2023-12-09 07:33:51.492 CET [733588] pleroma@pleroma FATAL: the database system is shutting down
2023-12-09 07:33:51.833 CET [1573] LOG: database system is shut down
2023-12-09 07:33:56.457 CET [733804] LOG: invalid value for parameter "lc_messages": "en_US.UTF-8"
2023-12-09 07:33:56.458 CET [733804] LOG: invalid value for parameter "lc_monetary": "en_US.UTF-8"
2023-12-09 07:33:56.458 CET [733804] LOG: invalid value for parameter "lc_numeric": "en_US.UTF-8"
2023-12-09 07:33:56.458 CET [733804] LOG: invalid value for parameter "lc_time": "en_US.UTF-8"
2023-12-09 07:33:56.458 CET [733804] FATAL: configuration file "/etc/postgresql/12/main/postgresql.conf" contains errors
2023-12-09 16:43:14.305 CET [905924] LOG: database system was shut down at 2023-12-09 07:33:48 CET
and how to fix it:
localedef -i en_US -f UTF-8 en_US.UTF-8
systemctl restart postgresql
no reboot occured, but something asked PostgreSQL to restart, I don't understand why (I think I was sleeping at that time)
# PostgreSQL logs
2023-12-09 07:33:45.200 CET [719090] pleroma@pleroma LOG: statement: BEGIN
2023-12-09 07:33:45.200 CET [719090] pleroma@pleroma LOG: execute ecto_388: UPDATE "public"."oban_jobs" AS o0 SET "state" = $1, "attempted_at" = $2, "attempted_by" = $3, "attempt" = o0."attempt" + $4 WHERE (o0."id" IN (SELECT so0."id" FR
OM "public"."oban_jobs" AS so0 WHERE (so0."state" = 'available') AND (so0."queue" = $5) AND (so0."attempt" < so0."max_attempts") ORDER BY so0."priority", so0."scheduled_at", so0."id" LIMIT $6 FOR UPDATE SKIP LOCKED)) RETURNING o0."id", o0
."state", o0."queue", o0."worker", o0."args", o0."meta", o0."tags", o0."errors", o0."attempt", o0."attempted_by", o0."max_attempts", o0."priority", o0."attempted_at", o0."cancelled_at", o0."completed_at", o0."discarded_at", o0."inserted_a
t", o0."scheduled_at"
2023-12-09 07:33:45.200 CET [719090] pleroma@pleroma DETAIL: parameters: $1 = 'executing', $2 = '2023-12-09 06:33:45.200165', $3 = '{udongein}', $4 = '1', $5 = 'federator_outgoing', $6 = '2'
2023-12-09 07:33:45.200 CET [719090] pleroma@pleroma LOG: statement: COMMIT
2023-12-09 07:33:45.203 CET [1573] LOG: aborting any active transactions
2023-12-09 07:33:45.203 CET [731865] pleroma@pleroma FATAL: terminating connection due to administrator command
[...]
2023-12-09 07:33:51.492 CET [733588] pleroma@pleroma FATAL: the database system is shutting down
2023-12-09 07:33:51.833 CET [1573] LOG: database system is shut down
2023-12-09 07:33:56.457 CET [733804] LOG: invalid value for parameter "lc_messages": "en_US.UTF-8"
2023-12-09 07:33:56.458 CET [733804] LOG: invalid value for parameter "lc_monetary": "en_US.UTF-8"
2023-12-09 07:33:56.458 CET [733804] LOG: invalid value for parameter "lc_numeric": "en_US.UTF-8"
2023-12-09 07:33:56.458 CET [733804] LOG: invalid value for parameter "lc_time": "en_US.UTF-8"
2023-12-09 07:33:56.458 CET [733804] FATAL: configuration file "/etc/postgresql/12/main/postgresql.conf" contains errors
2023-12-09 16:43:14.305 CET [905924] LOG: database system was shut down at 2023-12-09 07:33:48 CET
and how to fix it:
localedef -i en_US -f UTF-8 en_US.UTF-8
systemctl restart postgresql
no reboot occured, but something asked PostgreSQL to restart, I don't understand why (I think I was sleeping at that time)