Stuck on update

Hello,
I didn’t find the information so I open that topic. I’m currently stuck on update after launching .

./launcher rebuild app

The process stopped at “database system is ready to accept connections” without exiting.

Here the complete log:

root@ubuntu-s-1vcpu-1gb-ams3-01:/var/discourse# ./launcher rebuild app
x86_64 arch detected.
Ensuring launcher is up to date
Fetching origin
remote: Enumerating objects: 22, done.
remote: Counting objects: 100% (22/22), done.
remote: Compressing objects: 100% (6/6), done.
remote: Total 22 (delta 15), reused 22 (delta 15), pack-reused 0 (from 0)
Unpacking objects: 100% (22/22), done.
From https://github.com/discourse/discourse_docker
 * [new branch]      generate-locales -> origin/generate-locales
 * [new branch]      pnpm-compat      -> origin/pnpm-compat
Launcher is up-to-date
Stopping old container
+ /usr/bin/docker stop -t 600 app
app
2.0.20240825-0027: Pulling from discourse/base
Digest: sha256:6de68cb49198b5281f79ed9401b3fe818c854d220dcf0238549fe2f2adb19146
Status: Image is up to date for discourse/base:2.0.20240825-0027
docker.io/discourse/base:2.0.20240825-0027
/usr/local/lib/ruby/gems/3.3.0/gems/pups-1.2.1/lib/pups.rb
/usr/local/bin/pups --stdin
I, [2024-08-31T19:13:01.712232 #1]  INFO -- : Reading from stdin
I, [2024-08-31T19:13:01.725698 #1]  INFO -- : File > /etc/service/postgres/run  chmod: +x  chown:
I, [2024-08-31T19:13:01.731139 #1]  INFO -- : File > /etc/service/postgres/log/run  chmod: +x  chown:
I, [2024-08-31T19:13:01.736195 #1]  INFO -- : File > /etc/runit/3.d/99-postgres  chmod: +x  chown:
I, [2024-08-31T19:13:01.741423 #1]  INFO -- : File > /root/install_postgres  chmod: +x  chown:
I, [2024-08-31T19:13:01.746890 #1]  INFO -- : File > /root/upgrade_postgres  chmod: +x  chown:
I, [2024-08-31T19:13:01.747680 #1]  INFO -- : Replacing data_directory = '/var/lib/postgresql/13/main' with data_directory = '/shared/postgres_data' in /etc/postgresql/13/main/postgresql.conf
I, [2024-08-31T19:13:01.751377 #1]  INFO -- : Replacing (?-mix:#?listen_addresses *=.*) with listen_addresses = '*' in /etc/postgresql/13/main/postgresql.conf
I, [2024-08-31T19:13:01.752317 #1]  INFO -- : Replacing (?-mix:#?synchronous_commit *=.*) with synchronous_commit = $db_synchronous_commit in /etc/postgresql/13/main/postgresql.conf
I, [2024-08-31T19:13:01.753223 #1]  INFO -- : Replacing (?-mix:#?shared_buffers *=.*) with shared_buffers = $db_shared_buffers in /etc/postgresql/13/main/postgresql.conf
I, [2024-08-31T19:13:01.753826 #1]  INFO -- : Replacing (?-mix:#?work_mem *=.*) with work_mem = $db_work_mem in /etc/postgresql/13/main/postgresql.conf
I, [2024-08-31T19:13:01.754477 #1]  INFO -- : Replacing (?-mix:#?default_text_search_config *=.*) with default_text_search_config = '$db_default_text_search_config' in /etc/postgresql/13/main/postgresql.conf
I, [2024-08-31T19:13:01.755195 #1]  INFO -- : Replacing (?-mix:#?checkpoint_segments *=.*) with checkpoint_segments = $db_checkpoint_segments in /etc/postgresql/13/main/postgresql.conf
I, [2024-08-31T19:13:01.756536 #1]  INFO -- : Replacing (?-mix:#?logging_collector *=.*) with logging_collector = $db_logging_collector in /etc/postgresql/13/main/postgresql.conf
I, [2024-08-31T19:13:01.763719 #1]  INFO -- : Replacing (?-mix:#?log_min_duration_statement *=.*) with log_min_duration_statement = $db_log_min_duration_statement in /etc/postgresql/13/main/postgresql.conf
I, [2024-08-31T19:13:01.764882 #1]  INFO -- : Replacing (?-mix:^#local +replication +postgres +peer$) with local replication postgres  peer in /etc/postgresql/13/main/pg_hba.conf
I, [2024-08-31T19:13:01.765738 #1]  INFO -- : Replacing (?-mix:^host.*all.*all.*127.*$) with host all all 0.0.0.0/0 md5 in /etc/postgresql/13/main/pg_hba.conf
I, [2024-08-31T19:13:01.766445 #1]  INFO -- : Replacing (?-mix:^host.*all.*all.*::1\/128.*$) with host all all ::/0 md5 in /etc/postgresql/13/main/pg_hba.conf
I, [2024-08-31T19:13:01.767059 #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

2024/08/31 19:13:01 socat[28] E connect(, AF=1 "/shared/postgres_run/.s.PGSQL.5432", 36): Connection refused
I, [2024-08-31T19:13:01.838981 #1]  INFO -- : Generating locales (this might take a while)...
Generation complete.

I, [2024-08-31T19:13:01.839815 #1]  INFO -- : > HOME=/var/lib/postgresql USER=postgres exec chpst -u postgres:postgres:ssl-cert -U postgres:postgres:ssl-cert /usr/lib/postgresql/13/bin/postmaster -D /etc/postgresql/13/main
I, [2024-08-31T19:13:01.843166 #1]  INFO -- : Terminating async processes
2024-08-31 19:13:01.923 UTC [30] LOG:  starting PostgreSQL 13.16 (Debian 13.16-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-08-31 19:13:01.923 UTC [30] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-08-31 19:13:01.923 UTC [30] LOG:  listening on IPv6 address "::", port 5432
2024-08-31 19:13:01.929 UTC [30] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-08-31 19:13:01.937 UTC [31] LOG:  database system was interrupted; last known up at 2024-08-31 05:57:05 UTC
2024-08-31 19:13:02.153 UTC [31] LOG:  database system was not properly shut down; automatic recovery in progress
2024-08-31 19:13:02.162 UTC [31] LOG:  redo starts at 9/ED2E4968
2024-08-31 19:13:02.162 UTC [31] LOG:  invalid record length at 9/ED2E49A0: wanted 24, got 0
2024-08-31 19:13:02.163 UTC [31] LOG:  redo done at 9/ED2E4968
2024-08-31 19:13:02.182 UTC [30] LOG:  database system is ready to accept connections

Any help is welcome. Thank you in advance.

See this open issue:

4 Likes

See

for the solution.

1 Like