ioanah reports their Discourse forum has been down for over 24 hours after a failed update, stuck at the message database system is ready to accept connections. They attempted a fix from a meta.discourse.org post but encountered errors including locale generation failures and missing files like 8-FTU.SU_ne and 8691-4.3X_ISNA. The logs show Docker version 20.10.7 is deprecated, and pfaffman advises upgrading Docker and the OS. The rebuild fails during PostgreSQL setup, with locale settings misconfigured and critical files not found, preventing the container from starting properly.
Hi everyone,
Our Discourse forum has been down for over 24 hours.
I was trying to update Discourse to the latest version, but the rebuild seems to be stuck with the message:
database system is ready to accept connections
I tried applying the solution from this post, but when I run apt install ``docker.io, it fails with this error:
The following packages have unmet dependencies:
containerd.io : Conflicts: containerd
E: Error, pkgProblemResolver::Resolve generated breaks, this may be caused by held packages.
WARNING: Docker version 20.10.7 deprecated, recommend upgrade to 24.0.7 or newer.
x86_64 arch detected.
Ensuring launcher is up to date
Fetching origin
Launcher is up-to-date
2.0.20251003-1437: Pulling from discourse/base
Digest: sha256:0db7c9b4598e2a1806658391669d791fd779aa4301fdfbed6a7f322bf64e66ab
Status: Image is up to date for discourse/base:2.0.20251003-1437
docker.io/discourse/base:2.0.20251003-1437
/usr/local/lib/ruby/gems/3.3.0/gems/pups-1.3.0/lib/pups.rb
/usr/local/bin/pups --stdin
I, [2025-10-29T21:17:42.016158 #1] INFO -- : Reading from stdin
I, [2025-10-29T21:17:42.033764 #1] INFO -- : File > /etc/service/postgres/run chmod: +x chown:
I, [2025-10-29T21:17:42.040454 #1] INFO -- : File > /etc/service/postgres/log/run chmod: +x chown:
I, [2025-10-29T21:17:42.047119 #1] INFO -- : File > /etc/runit/3.d/99-postgres chmod: +x chown:
I, [2025-10-29T21:17:42.053406 #1] INFO -- : File > /root/install_postgres chmod: +x chown:
I, [2025-10-29T21:17:42.060253 #1] INFO -- : File > /root/upgrade_postgres chmod: +x chown:
I, [2025-10-29T21:17:42.060804 #1] INFO -- : Replacing data_directory = '/var/lib/postgresql/15/main' with data_directory = '/shared/postgres_data' in /etc/postgresql/15/main/postgresql.conf
I, [2025-10-29T21:17:42.062792 #1] INFO -- : Replacing (?-mix:#?listen_addresses *=.*) with listen_addresses = '*' in /etc/postgresql/15/main/postgresql.conf
I, [2025-10-29T21:17:42.064051 #1] INFO -- : Replacing (?-mix:#?synchronous_commit *=.*) with synchronous_commit = $db_synchronous_commit in /etc/postgresql/15/main/postgresql.conf
I, [2025-10-29T21:17:42.069245 #1] INFO -- : Replacing (?-mix:#?shared_buffers *=.*) with shared_buffers = $db_shared_buffers in /etc/postgresql/15/main/postgresql.conf
I, [2025-10-29T21:17:42.070261 #1] INFO -- : Replacing (?-mix:#?work_mem *=.*) with work_mem = $db_work_mem in /etc/postgresql/15/main/postgresql.conf
I, [2025-10-29T21:17:42.071276 #1] INFO -- : Replacing (?-mix:#?default_text_search_config *=.*) with default_text_search_config = '$db_default_text_search_config' in /etc/postgresql/15/main/postgresql.conf
I, [2025-10-29T21:17:42.071873 #1] INFO -- : Replacing (?-mix:#?checkpoint_segments *=.*) with checkpoint_segments = $db_checkpoint_segments in /etc/postgresql/15/main/postgresql.conf
I, [2025-10-29T21:17:42.072598 #1] INFO -- : Replacing (?-mix:#?logging_collector *=.*) with logging_collector = $db_logging_collector in /etc/postgresql/15/main/postgresql.conf
I, [2025-10-29T21:17:42.073127 #1] INFO -- : Replacing (?-mix:#?log_min_duration_statement *=.*) with log_min_duration_statement = $db_log_min_duration_statement in /etc/postgresql/15/main/postgresql.conf
I, [2025-10-29T21:17:42.073774 #1] INFO -- : Replacing (?-mix:^#local +replication +postgres +peer$) with local replication postgres peer in /etc/postgresql/15/main/pg_hba.conf
I, [2025-10-29T21:17:42.074315 #1] INFO -- : Replacing (?-mix:^host.*all.*all.*127.*$) with host all all 0.0.0.0/0 md5 in /etc/postgresql/15/main/pg_hba.conf
I, [2025-10-29T21:17:42.074841 #1] INFO -- : Replacing (?-mix:^host.*all.*all.*::1\/128.*$) with host all all ::/0 md5 in /etc/postgresql/15/main/pg_hba.conf
I, [2025-10-29T21:17:42.075291 #1] INFO -- : > if [ -f /root/install_postgres ]; then
/root/install_postgres && rm -f /root/install_postgres
elif [ -e /shared/postgres_run/.s.PGSQL.5432 ]; then
socat /dev/null UNIX-CONNECT:/shared/postgres_run/.s.PGSQL.5432 || exit 0 && echo postgres already running stop container ; exit 1
fi
failed to set locale!
[error] character map file `UTF-8' not found: No such file or directory
failed to set locale!
[error] default character map file `ANSI_X3.4-1968' not found: No such file or directory
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = "en_US.UTF-8",
LC_ALL = "en_US.UTF-8",
LANG = "en_US.UTF-8"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
/bin/bash: warning: setlocale: LC_ALL: cannot change locale (en_US.UTF-8)
I, [2025-10-29T21:17:43.405389 #1] INFO -- : Generating locales (this might take a while)...
en_US.UTF-8... done
Generation complete.
I, [2025-10-29T21:17:43.405986 #1] INFO -- : > HOME=/var/lib/postgresql USER=postgres exec chpst -u postgres:postgres:ssl-cert -U postgres:postgres:ssl-cert /usr/lib/postgresql/15/bin/postmaster -D /etc/postgresql/15/main
I, [2025-10-29T21:17:43.409259 #1] INFO -- : Terminating async processes
2025-10-29 21:17:43.688 UTC [44] LOG: starting PostgreSQL 15.14 (Debian 15.14-1.pgdg12+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14+deb12u1) 12.2.0, 64-bit
2025-10-29 21:17:43.689 UTC [44] LOG: listening on IPv4 address "0.0.0.0", port 5432
2025-10-29 21:17:43.689 UTC [44] LOG: listening on IPv6 address "::", port 5432
2025-10-29 21:17:43.915 UTC [44] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-10-29 21:17:44.115 UTC [47] LOG: database system was interrupted; last known up at 2025-10-29 20:31:48 UTC
2025-10-29 21:17:44.454 UTC [47] LOG: database system was not properly shut down; automatic recovery in progress
2025-10-29 21:17:44.616 UTC [47] LOG: redo starts at 150/A40074A0
2025-10-29 21:17:44.616 UTC [47] LOG: invalid record length at 150/A40074D8: wanted 24, got 0
2025-10-29 21:17:44.616 UTC [47] LOG: redo done at 150/A40074A0 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2025-10-29 21:17:44.742 UTC [45] LOG: checkpoint starting: end-of-recovery immediate wait
2025-10-29 21:17:45.453 UTC [45] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.207 s, sync=0.254 s, total=0.722 s; sync files=3, longest=0.177 s, average=0.085 s; distance=0 kB, estimate=0 kB
2025-10-29 21:17:45.490 UTC [44] LOG: database system is ready to accept connections