עדכון 2.7.0.beta3 -> beta4 נכשל

סיכום מבוסס בינה מלאכותית

User TBauer is experiencing issues updating their Discourse forum from 2.7.0.beta3 to beta4. The update failed, and the forum is now offline. The error message suggests a problem with the ssl-cert-snakeoil.key file. TBauer has tried rebuilding the container multiple times and copying the key file to the ssl/private directory, but the issue persists. The error log indicates a failure to execute a PostgreSQL command, specifically altering the schema owner.

I tried to update my forum from 2.7.0beta3 to beta4 yesterday. This failed and since that the forum is offline. I tried the rebuild multiple times, but nothing changed.

If I unterstand this correctly, it looks like there is a problem with the ssl-cert-snakeoil.key. I copied this in the ssl/private cert, but this did not help…

What can I do?

/var/discourse# ./launcher rebuild app
Ensuring launcher is up to date
Fetching origin
Launcher is up-to-date
Stopping old container
+ /usr/bin/docker stop -t 60 app
app
cd /pups && git pull && /pups/bin/pups --stdin
Already up to date.
I, [2021-02-20T13:37:23.183058 #1]  INFO -- : Loading --stdin
I, [2021-02-20T13:37:23.189847 #1]  INFO -- : > locale-gen $LANG && update-locale
I, [2021-02-20T13:37:23.222699 #1]  INFO -- : Generating locales (this might take a while)...
Generation complete.

I, [2021-02-20T13:37:23.222846 #1]  INFO -- : > mkdir -p /shared/postgres_run
I, [2021-02-20T13:37:23.225283 #1]  INFO -- : 
I, [2021-02-20T13:37:23.225472 #1]  INFO -- : > chown postgres:postgres /shared/postgres_run
I, [2021-02-20T13:37:23.227685 #1]  INFO -- : 
I, [2021-02-20T13:37:23.227857 #1]  INFO -- : > chmod 775 /shared/postgres_run
I, [2021-02-20T13:37:23.229931 #1]  INFO -- : 
I, [2021-02-20T13:37:23.230119 #1]  INFO -- : > rm -fr /var/run/postgresql
I, [2021-02-20T13:37:23.232352 #1]  INFO -- : 
I, [2021-02-20T13:37:23.232530 #1]  INFO -- : > ln -s /shared/postgres_run /var/run/postgresql
I, [2021-02-20T13:37:23.234556 #1]  INFO -- : 
I, [2021-02-20T13:37:23.234716 #1]  INFO -- : > socat /dev/null UNIX-CONNECT:/shared/postgres_run/.s.PGSQL.5432 || exit 0 && echo postgres already running stop container ; exit 1
2021/02/20 13:37:23 socat[27] E connect(6, AF=1 "/shared/postgres_run/.s.PGSQL.5432", 36): No such file or directory
I, [2021-02-20T13:37:23.239302 #1]  INFO -- : 
I, [2021-02-20T13:37:23.239467 #1]  INFO -- : > rm -fr /shared/postgres_run/.s*
I, [2021-02-20T13:37:23.242307 #1]  INFO -- : 
I, [2021-02-20T13:37:23.242445 #1]  INFO -- : > rm -fr /shared/postgres_run/*.pid
I, [2021-02-20T13:37:23.245206 #1]  INFO -- : 
I, [2021-02-20T13:37:23.245397 #1]  INFO -- : > mkdir -p /shared/postgres_run/13-main.pg_stat_tmp
I, [2021-02-20T13:37:23.247628 #1]  INFO -- : 
I, [2021-02-20T13:37:23.247840 #1]  INFO -- : > chown postgres:postgres /shared/postgres_run/13-main.pg_stat_tmp
I, [2021-02-20T13:37:23.250108 #1]  INFO -- : 
I, [2021-02-20T13:37:23.254647 #1]  INFO -- : File > /etc/service/postgres/run  chmod: +x  chown: 
I, [2021-02-20T13:37:23.259061 #1]  INFO -- : File > /etc/service/postgres/log/run  chmod: +x  chown: 
I, [2021-02-20T13:37:23.263496 #1]  INFO -- : File > /etc/runit/3.d/99-postgres  chmod: +x  chown: 
I, [2021-02-20T13:37:23.267834 #1]  INFO -- : File > /root/upgrade_postgres  chmod: +x  chown: 
I, [2021-02-20T13:37:23.268175 #1]  INFO -- : > chown -R root /var/lib/postgresql/13/main
I, [2021-02-20T13:37:37.130043 #1]  INFO -- : 
I, [2021-02-20T13:37:37.130217 #1]  INFO -- : > [ ! -e /shared/postgres_data ] && install -d -m 0755 -o postgres -g postgres /shared/postgres_data && sudo -E -u postgres /usr/lib/postgresql/13/bin/initdb -D /shared/postgres_data || exit 0
I, [2021-02-20T13:37:37.132704 #1]  INFO -- : 
I, [2021-02-20T13:37:37.132787 #1]  INFO -- : > chown -R postgres:postgres /shared/postgres_data
I, [2021-02-20T13:37:37.145885 #1]  INFO -- : 
I, [2021-02-20T13:37:37.146042 #1]  INFO -- : > chown -R postgres:postgres /var/run/postgresql
I, [2021-02-20T13:37:37.148661 #1]  INFO -- : 
I, [2021-02-20T13:37:37.148864 #1]  INFO -- : > /root/upgrade_postgres
I, [2021-02-20T13:37:37.153667 #1]  INFO -- : 
I, [2021-02-20T13:37:37.153843 #1]  INFO -- : > rm /root/upgrade_postgres
I, [2021-02-20T13:37:37.155830 #1]  INFO -- : 
I, [2021-02-20T13:37:37.156189 #1]  INFO -- : Replacing data_directory = '/var/lib/postgresql/13/main' with data_directory = '/shared/postgres_data' in /etc/postgresql/13/main/postgresql.conf
I, [2021-02-20T13:37:37.156795 #1]  INFO -- : Replacing (?-mix:#?listen_addresses *=.*) with listen_addresses = '*' in /etc/postgresql/13/main/postgresql.conf
I, [2021-02-20T13:37:37.157169 #1]  INFO -- : Replacing (?-mix:#?synchronous_commit *=.*) with synchronous_commit = $db_synchronous_commit in /etc/postgresql/13/main/postgresql.conf
I, [2021-02-20T13:37:37.157504 #1]  INFO -- : Replacing (?-mix:#?shared_buffers *=.*) with shared_buffers = $db_shared_buffers in /etc/postgresql/13/main/postgresql.conf
I, [2021-02-20T13:37:37.157873 #1]  INFO -- : Replacing (?-mix:#?work_mem *=.*) with work_mem = $db_work_mem in /etc/postgresql/13/main/postgresql.conf
I, [2021-02-20T13:37:37.158232 #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, [2021-02-20T13:37:37.158619 #1]  INFO -- : > install -d -m 0755 -o postgres -g postgres /shared/postgres_backup
I, [2021-02-20T13:37:37.161251 #1]  INFO -- : 
I, [2021-02-20T13:37:37.161572 #1]  INFO -- : Replacing (?-mix:#?checkpoint_segments *=.*) with checkpoint_segments = $db_checkpoint_segments in /etc/postgresql/13/main/postgresql.conf
I, [2021-02-20T13:37:37.161876 #1]  INFO -- : Replacing (?-mix:#?logging_collector *=.*) with logging_collector = $db_logging_collector in /etc/postgresql/13/main/postgresql.conf
I, [2021-02-20T13:37:37.162217 #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, [2021-02-20T13:37:37.162602 #1]  INFO -- : Replacing (?-mix:^#local +replication +postgres +peer$) with local replication postgres  peer in /etc/postgresql/13/main/pg_hba.conf
I, [2021-02-20T13:37:37.162912 #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, [2021-02-20T13:37:37.163149 #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, [2021-02-20T13:37:37.164636 #1]  INFO -- : > sleep 5
2021-02-20 13:37:37.197 UTC [50] FATAL:  could not access private key file "/etc/ssl/private/ssl-cert-snakeoil.key": Permission denied
2021-02-20 13:37:37.197 UTC [50] LOG:  database system is shut down
I, [2021-02-20T13:37:42.166961 #1]  INFO -- : 
I, [2021-02-20T13:37:42.167363 #1]  INFO -- : > su postgres -c 'createdb discourse' || true
createdb: error: could not connect to database template1: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
I, [2021-02-20T13:37:42.218126 #1]  INFO -- : 
I, [2021-02-20T13:37:42.218344 #1]  INFO -- : > su postgres -c 'psql discourse -c "create user discourse;"' || true
psql: error: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
I, [2021-02-20T13:37:42.275239 #1]  INFO -- : 
I, [2021-02-20T13:37:42.275461 #1]  INFO -- : > su postgres -c 'psql discourse -c "grant all privileges on database discourse to discourse;"' || true
psql: error: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
I, [2021-02-20T13:37:42.332060 #1]  INFO -- : 
I, [2021-02-20T13:37:42.332325 #1]  INFO -- : > su postgres -c 'psql discourse -c "alter schema public owner to discourse;"'
psql: error: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
I, [2021-02-20T13:37:42.386846 #1]  INFO -- : 
I, [2021-02-20T13:37:42.387190 #1]  INFO -- : Terminating async processes


FAILED
--------------------
Pups::ExecError: su postgres -c 'psql discourse -c "alter schema public owner to discourse;"' failed with return #<Process::Status: pid 76 exit 2>
Location of failure: /pups/lib/pups/exec_command.rb:112:in `spawn'
exec failed with the params "su postgres -c 'psql $db_name -c \"alter schema public owner to $db_user;\"'"
a3db105ffb0ece834083479085db37dcae8c0baaa6dc4691dc9057a82baf2a11
** FAILED TO BOOTSTRAP ** please scroll up and look for earlier error messages, there may be more than one.
./discourse-doctor may help diagnose the problem.
# ls -lah shared/standalone/ssl/private/
total 12K
drwxr-xr-x 2 root root 4.0K Feb 19 20:13 .
drwxr-xr-x 3 root root 4.0K Feb 19 20:13 ..
-rw-r--r-- 1 root root 1.7K Feb 19 20:11 ssl-cert-snakeoil.key
לייק 1