cant start peertube after updateing latest cloudron
-
error log
Mar 24 07:37:21 2025-03-24 00:37:21.628 UTC [1762] userf8ee153b7f89431b8a74be747b18e88c@dbf8ee153b7f89431b8a74be747b18e88c ERROR: temporary file size exceeds temp_file_limit (4194304kB) Mar 24 07:37:21 2025-03-24 00:37:21.628 UTC [1762] userf8ee153b7f89431b8a74be747b18e88c@dbf8ee153b7f89431b8a74be747b18e88c STATEMENT: CREATE UNIQUE INDEX "local_video_viewer_url" ON "localVideoViewer" ("url") Mar 24 07:37:21 2025-03-24 00:37:21.633 UTC [1763] FATAL: terminating background worker "parallel worker" due to administrator command Mar 24 07:37:21 2025-03-24 00:37:21.633 UTC [1763] STATEMENT: CREATE UNIQUE INDEX "local_video_viewer_url" ON "localVideoViewer" ("url") Mar 24 07:37:23 2025-03-24 00:37:23.380 UTC [47] LOG: background worker "parallel worker" (PID 1763) exited with exit code 1
-
after create custom custom.conf in /home/yellowtent/platformdata/postgresql/16/main# error message is gone.
my peertube still not responding.
error log
2025/03/24 02:04:50 [error] 316#316: *357 connect() failed (111: Connection refused) while connecting to upstream, client: 172.18.0.1, server: default_server, request: "GET / HTTP/1.1", upstream: "http://127.0.0.1:9000/", host:from htop showing process postges create index.
-
@awnzky looks like temp_file_limit is set to 4GB by default. What did you raise this to? How big is your peertube database dump ? you can check
/home/yellowtent/appsdata/<appid>/postgresqldump
. Maybe we can increase the default size even more in the code. -
here some error log 2025-03-24T13:21:29Z server started 2025-03-24T13:21:29Z ==> Waiting for Postgres 2025-03-24T13:21:29Z pg_ctl: server is running (PID: 15) 2025-03-24T13:21:29Z /usr/lib/postgresql/16/bin/postgres "-D" "/var/lib/postgresql/16/main" 2025-03-24T13:21:29Z ==> Postgres is running 2025-03-24T13:21:29Z ==> Resetting root password 2025-03-24T13:21:29Z ALTER ROLE 2025-03-24T13:21:29Z ==> Upgrading pgvectors 2025-03-24T13:21:29Z ERROR: database "cloudronpgvectorupdate" already exists 2025-03-24T13:21:29Z 2025-03-24 13:21:29.801 UTC [30] root@postgres ERROR: database "cloudronpgvectorupdate" already exists 2025-03-24T13:21:29Z 2025-03-24 13:21:29.801 UTC [30] root@postgres STATEMENT: CREATE DATABASE cloudronpgvectorupdate 2025-03-24T13:22:30Z ==> Detected existing installation 2025-03-24T13:22:30Z ==> Copying updated config 2025-03-24T13:22:30Z ==> Updating existing postgresql 2025-03-24T13:22:30Z waiting for server to start....2025-03-24 13:22:30.157 GMT [15] LOG: skipping missing configuration file "/var/lib/postgresql/16/main/custom.conf" 2025-03-24T13:22:30Z 2025-03-24 13:22:30.157 GMT [15] LOG: skipping missing configuration file "/var/lib/postgresql/16/main/custom.conf" 2025-03-24T13:22:30Z 2025-03-24 13:22:30.186 UTC [15] LOG: starting PostgreSQL 16.6 (Ubuntu 16.6-0ubuntu0.24.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.2.0-23ubuntu4) 13.2.0, 64-bit 2025-03-24T13:22:30Z 2025-03-24 13:22:30.186 UTC [15] LOG: listening on IPv4 address "0.0.0.0", port 5432 2025-03-24T13:22:30Z 2025-03-24 13:22:30.186 UTC [15] LOG: listening on IPv6 address "::", port 5432 2025-03-24T13:22:30Z 2025-03-24 13:22:30.189 UTC [15] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2025-03-24T13:22:30Z 2025-03-24 13:22:30.195 UTC [18] LOG: database system was interrupted; last known up at 2025-03-24 13:21:29 UTC 2025-03-24T13:22:30Z 2025-03-24 13:22:30.315 UTC [18] LOG: database system was not properly shut down; automatic recovery in progress 2025-03-24T13:22:30Z 2025-03-24 13:22:30.318 UTC [18] LOG: redo starts at D/D9A09748 2025-03-24T13:22:30Z 2025-03-24 13:22:30.318 UTC [18] LOG: invalid record length at D/D9A0AE20: expected at least 24, got 0 2025-03-24T13:22:30Z 2025-03-24 13:22:30.318 UTC [18] LOG: redo done at D/D9A0ADC8 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2025-03-24T13:22:30Z 2025-03-24 13:22:30.326 UTC [16] LOG: checkpoint starting: end-of-recovery immediate wait 2025-03-24T13:22:30Z 2025-03-24 13:22:30.337 UTC [16] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s, sync=0.003 s, total=0.013 s; sync files=4, longest=0.001 s, average=0.001 s; distance=5 kB, estimate=5 kB; lsn=D/D9A0AE20, redo lsn=D/D9A0AE20 2025-03-24T13:22:30Z 2025-03-24 13:22:30.342 UTC [15] LOG: database system is ready to accept connections 2025-03-24T13:22:30Z done 2025-03-24T13:22:30Z server started 2025-03-24T13:22:30Z ==> Waiting for Postgres 2025-03-24T13:22:30Z pg_ctl: server is running (PID: 15) 2025-03-24T13:22:30Z /usr/lib/postgresql/16/bin/postgres "-D" "/var/lib/postgresql/16/main" 2025-03-24T13:22:30Z ==> Postgres is running 2025-03-24T13:22:30Z ==> Resetting root password 2025-03-24T13:22:30Z ALTER ROLE 2025-03-24T13:22:30Z ==> Upgrading pgvectors 2025-03-24T13:22:30Z 2025-03-24 13:22:30.509 UTC [30] root@postgres ERROR: database "cloudronpgvectorupdate" already exists 2025-03-24T13:22:30Z 2025-03-24 13:22:30.509 UTC [30] root@postgres STATEMENT: CREATE DATABASE cloudronpgvectorupdate 2025-03-24T13:22:30Z ERROR: database "cloudronpgvectorupdate" already exists
-
its working now. but with a little trick for my server. so i make postgree not start by making wrong custom.conf postgresql. the problem is when postgres start the server immediately crashes and can't do ssh or ping.
then i can enter dashboard and choose postgres recovery mode.thanks for your help.
-
N nebulon marked this topic as a question
-
N nebulon has marked this topic as solved
-
B BrutalBirdie referenced this topic