App Updates failed with "Error - Error setting up postgresql. Status code: 500 message:"

[perelin]

Description

I have two apps (n8n, mealie) that seem to have failed updating and display the error "Error - Error setting up postgresql. Status code: 500 message:"

Logs

These are the last log lines. Both apps have the same log entries at that point.

Nov 08 20:23:36 box:services setupAddons: setting up addon localstorage with options {}
Nov 08 20:23:36 box:services setupLocalStorage
Nov 08 20:23:36 box:shell services: /usr/bin/sudo --non-interactive /home/yellowtent/box/src/scripts/setupvolume.sh /home/yellowtent/appsdata/4f598cd8-bc25-4d3b-81be-dc2a8940ca88/data
Nov 08 20:23:36 box:services Setting up postgresql
Nov 08 20:23:36 box:services setupAddons: setting up addon postgresql with options {}
Nov 08 20:23:36 box:apptask run: app error for state pending_configure: BoxError: Error setting up postgresql. Status code: 500 message: at Object.setupPostgreSql [as setup] (/home/yellowtent/box/src/services.js:1516:40) at process.processTicksAndRejections (node:internal/process/task_queues:105:5) at async Object.setupAddons (/home/yellowtent/box/src/services.js:630:9) at async configureCommand (/home/yellowtent/box/src/apptask.js:537:5) { reason: 'Addons Error', details: {} }
Nov 08 20:23:36 box:tasks setCompleted - 2374: {"result":null,"error":{"message":"Error setting up postgresql. Status code: 500 message: ","reason":"Addons Error"},"percent":100}
Nov 08 20:23:36 box:tasks updating task 2374 with: {"completed":true,"result":null,"error":{"message":"Error setting up postgresql. Status code: 500 message: ","reason":"Addons Error"},"percent":100}
Nov 08 20:23:36 Exiting with code 0
Nov 08 20:23:36 box:taskworker Task took 0.919 seconds
Nov 08 20:23:36 BoxError: Error setting up postgresql. Status code: 500 message:

Troubleshooting Already Performed

System was restarted.

System Details

https://paste.cloudron.io/iwujeqobay.yaml

Output of cloudron-support --troubleshoot

perelin@p2-main-htz:~$ sudo cloudron-support --troubleshoot
Vendor: Hetzner Product: vServer
Linux: 6.8.0-87-generic
Ubuntu: noble 24.04
Processor: AMD EPYC-Milan Processor
BIOS NotSpecified  CPU @ 2.0GHz x 4
RAM: 15985364KB
Disk: /dev/sda1        42G
[OK]	node version is correct
[OK]	IPv6 is enabled and public IPv6 address is working
[OK]	docker is running
[OK]	docker version is correct
[OK]	MySQL is running
[OK]	nginx is running
[OK]	dashboard cert is valid
[OK]	dashboard is reachable via loopback
[OK]	box v9.0.12 is running
[OK]	netplan is good
[OK]	DNS is resolving via systemd-resolved
[OK]	Dashboard is reachable via domain name
[OK]	Domain p2lab.com is valid and has not expired
[OK]	unbound is running

[james]

Hello @perelin
Thanks for using the template, this helps a lot.
Can you please check the logs of the PostgreSQL service when trying to update the app and post the logs?

[perelin]

Hi @james !

So, I cant manually trigger the update, the option is disabled. The app shows "error" in the overview.

Here a re the logs from the las restart on...

n8n

Nov 25 11:14:11 13:M 25 Nov 2025 10:14:11.689 * User requested shutdown...
Nov 25 11:14:11 13:M 25 Nov 2025 10:14:11.695 * Saving the final RDB snapshot before exiting.
Nov 25 11:14:11 13:M 25 Nov 2025 10:14:11.713 # Redis is now ready to exit, bye bye...
Nov 25 11:14:11 13:M 25 Nov 2025 10:14:11.713 * DB saved on disk
Nov 25 11:14:11 13:M 25 Nov 2025 10:14:11.713 * Removing the pid file.
Nov 25 11:14:11 13:signal-handler (1764065651) Received SIGTERM scheduling shutdown...
Nov 25 11:14:11 2025-11-25 10:14:11,517 WARN received SIGTERM indicating exit request
Nov 25 11:14:11 2025-11-25 10:14:11,633 INFO waiting for redis, redis-service to die
Nov 25 11:14:11 2025-11-25 10:14:11,665 WARN stopped: redis-service (terminated by SIGTERM)
Nov 25 11:14:46 ==> Starting supervisor
Nov 25 11:14:47 2025-11-25 10:14:47,794 INFO Included extra file "/etc/supervisor/conf.d/redis-service.conf" during parsing
Nov 25 11:14:47 2025-11-25 10:14:47,795 INFO Included extra file "/etc/supervisor/conf.d/redis.conf" during parsing
Nov 25 11:14:47 2025-11-25 10:14:47,795 INFO Set uid to user 0 succeeded
Nov 25 11:14:47 2025-11-25 10:14:47,809 INFO RPC interface 'supervisor' initialized
Nov 25 11:14:47 2025-11-25 10:14:47,812 CRIT Server 'inet_http_server' running without any HTTP authentication checking
Nov 25 11:14:47 2025-11-25 10:14:47,813 INFO supervisord started with pid 1
Nov 25 11:14:48 2025-11-25 10:14:48,820 INFO spawned: 'redis' with pid 13
Nov 25 11:14:48 2025-11-25 10:14:48,940 INFO spawned: 'redis-service' with pid 14
Nov 25 11:14:49 13:C 25 Nov 2025 10:14:49.013 # WARNING Memory overcommit must be enabled! Without it, a background save or replication may fail under low memory condition. Being disabled, it can also cause failures without low memory condition, see https://github.com/jemalloc/jemalloc/issues/1328. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
Nov 25 11:14:49 13:C 25 Nov 2025 10:14:49.013 * Configuration loaded
Nov 25 11:14:49 13:C 25 Nov 2025 10:14:49.013 * Redis version=8.2.2, bits=64, commit=00000000, modified=1, pid=13, just started
Nov 25 11:14:49 13:C 25 Nov 2025 10:14:49.013 * oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
Nov 25 11:14:49 13:M 25 Nov 2025 10:14:49.039 * monotonic clock: POSIX clock_gettime
Nov 25 11:14:49 13:M 25 Nov 2025 10:14:49.161 # Failed to write PID file: Permission denied
Nov 25 11:14:49 13:M 25 Nov 2025 10:14:49.161 * Running mode=standalone, port=6379.
Nov 25 11:14:49 13:M 25 Nov 2025 10:14:49.164 * DB loaded from disk: 0.001 seconds
Nov 25 11:14:49 13:M 25 Nov 2025 10:14:49.164 * Done loading RDB, keys loaded: 0, keys expired: 0.
Nov 25 11:14:49 13:M 25 Nov 2025 10:14:49.164 * Loading RDB produced by version 8.2.2
Nov 25 11:14:49 13:M 25 Nov 2025 10:14:49.164 * RDB age 38 seconds
Nov 25 11:14:49 13:M 25 Nov 2025 10:14:49.164 * RDB memory usage when created 0.69 Mb
Nov 25 11:14:49 13:M 25 Nov 2025 10:14:49.164 * Ready to accept connections tcp
Nov 25 11:14:49 13:M 25 Nov 2025 10:14:49.164 * Server initialized
Nov 25 11:14:50 2025-11-25 10:14:50,748 INFO success: redis entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
Nov 25 11:14:50 2025-11-25 10:14:50,748 INFO success: redis-service entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
Nov 25 11:14:50 Redis service endpoint listening on http://:::3000
Nov 25 13:45:03 [GET] /healthcheck
Nov 25 13:45:03 BoxError: Error setting up postgresql. Status code: 500 message:

Postgres Service

ov 25 11:14:59 waiting for server to shut down....2025-11-25 10:14:59.649 UTC [15] LOG: aborting any active transactions
Nov 25 11:14:59 2025-11-25 10:14:59.673 UTC [15] LOG: background worker "logical replication launcher" (PID 35) exited with exit code 1
Nov 25 11:14:59 2025-11-25 10:14:59.684 UTC [16] LOG: shutting down
Nov 25 11:14:59 2025-11-25 10:14:59.687 UTC [16] LOG: checkpoint starting: shutdown immediate
Nov 25 11:14:59 2025-11-25 10:14:59.704 UTC [16] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.006 s, sync=0.003 s, total=0.020 s; sync files=2, longest=0.003 s, average=0.002 s; distance=7 kB, estimate=40 kB; lsn=4/5B495998, redo lsn=4/5B495998
Nov 25 11:14:59 2025-11-25 10:14:59.716 UTC [15] LOG: database system is shut down
Nov 25 11:14:59 done
Nov 25 11:14:59 server stopped
Nov 25 11:14:59 ==> Starting supervisor
Nov 25 11:15:00 2025-11-25 10:15:00,195 INFO Included extra file "/etc/supervisor/conf.d/postgresql-service.conf" during parsing
Nov 25 11:15:00 2025-11-25 10:15:00,195 INFO Included extra file "/etc/supervisor/conf.d/postgresql.conf" during parsing
Nov 25 11:15:00 2025-11-25 10:15:00,195 INFO Set uid to user 0 succeeded
Nov 25 11:15:00 2025-11-25 10:15:00,202 INFO RPC interface 'supervisor' initialized
Nov 25 11:15:00 2025-11-25 10:15:00,202 CRIT Server 'inet_http_server' running without any HTTP authentication checking
Nov 25 11:15:00 2025-11-25 10:15:00,204 INFO supervisord started with pid 1
Nov 25 11:15:01 2025-11-25 10:15:01,208 INFO spawned: 'postgresql' with pid 42
Nov 25 11:15:01 2025-11-25 10:15:01,226 INFO spawned: 'postgresql-service' with pid 43
Nov 25 11:15:02 PostgreSQL service endpoint listening on http://:::3000
Nov 25 11:15:03 2025-11-25 10:15:03,185 INFO success: postgresql entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
Nov 25 11:15:03 2025-11-25 10:15:03,186 INFO success: postgresql-service entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
Nov 25 11:15:05 2025-11-25 10:15:05.363 UTC [42] LOG: starting PostgreSQL 16.8 (Ubuntu 16.8-0ubuntu0.24.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04) 13.3.0, 64-bit
Nov 25 11:15:05 2025-11-25 10:15:05.363 UTC [42] LOG: listening on IPv4 address "0.0.0.0", port 5432
Nov 25 11:15:05 2025-11-25 10:15:05.363 UTC [42] LOG: listening on IPv6 address "::", port 5432
Nov 25 11:15:05 2025-11-25 10:15:05.369 UTC [42] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
Nov 25 11:15:05 2025-11-25 10:15:05.388 UTC [52] LOG: database system was shut down at 2025-11-25 10:14:59 UTC
Nov 25 11:15:05 [2025-11-25T10:15:05Z INFO service::utils::clean] Find directory "pg_vectors/indexes/82138".
Nov 25 11:15:05 [2025-11-25T10:15:05Z INFO service::utils::clean] Find directory "pg_vectors/indexes/82382".
Nov 25 11:15:05 [2025-11-25T10:15:05Z INFO service::utils::clean] Find directory "pg_vectors/indexes/82382/segments/9c992aa0-9e05-4357-9397-0e134caae02f".
Nov 25 11:15:05 [2025-11-25T10:15:05Z INFO service::utils::clean] Find directory "pg_vectors/indexes/82138/segments/a34eda87-3d03-4b44-8051-8d9d302211e9".
Nov 25 11:15:05 2025-11-25 10:15:05.404 UTC [42] LOG: database system is ready to accept connections
Nov 25 11:15:11 2025-11-25 10:15:11.246 UTC [83] userbf2a2bb5f382456b9199658074a588c5@dbbf2a2bb5f382456b9199658074a588c5 ERROR: invalid input syntax for type json at character 25
Nov 25 11:15:11 2025-11-25 10:15:11.246 UTC [83] userbf2a2bb5f382456b9199658074a588c5@dbbf2a2bb5f382456b9199658074a588c5 DETAIL: Token ""Check the following sentence for grammar and clarity: \"[sentence]" is invalid.
Nov 25 11:15:11 2025-11-25 10:15:11.246 UTC [83] userbf2a2bb5f382456b9199658074a588c5@dbbf2a2bb5f382456b9199658074a588c5 CONTEXT: JSON data, line 1: ...ng sentence for grammar and clarity: \"[sentence]
Nov 25 11:15:11 2025-11-25 10:15:11.246 UTC [83] userbf2a2bb5f382456b9199658074a588c5@dbbf2a2bb5f382456b9199658074a588c5 STATEMENT: UPDATE config SET data= E'{"version":0,"ui":{"default_locale":"","prompt_suggestions":[{"title":["Help me study","vocabulary for a college entrance exam"],"content":"Help me study vocabulary: write a sentence for me to fill in the blank, and I''ll try to pick the correct option."},{"title":["Give me ideas","for what to do with my kids'' art"],"content":"What are 5 creative things I could do with my kids'' art? I don''t want to throw them away, but it''s also so much clutter."},{"title":["Tell me a fun fact","about the Roman Empire"],"content":"Tell me a random fun fact about the Roman Empire"},{"title":["Show me a code snippet","of a website''s sticky header"],"content":"Show me a code snippet of a website''s sticky header in CSS and JavaScript."},{"title":["Explain options trading","if I''m familiar with buying and selling stocks"],"content":"Explain options trading in simple terms if I''m familiar with buying and selling stocks."},{"title":["Overcome procrastination","give me tips"],"content":"Could you start by asking me about instances when I procrastinate the most and then give me some suggestions to overcome it?"},{"title":["Grammar check","rewrite it for better readability "],"content":"Check the following sentence for grammar and clarity: \\"[sentence]' WHERE id=1;
Nov 25 11:15:38 [POST] /init-vector-chord
Nov 25 11:15:38 init: disconnected
Nov 25 11:15:38 [POST] /init-vector-chord
Nov 25 11:15:38 init: disconnected
Nov 25 11:20:05 2025-11-25 10:20:05.484 UTC [50] LOG: checkpoint starting: time
Nov 25 11:20:09 2025-11-25 10:20:09.918 UTC [50] LOG: checkpoint complete: wrote 46 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.417 s, sync=0.010 s, total=4.435 s; sync files=38, longest=0.004 s, average=0.001 s; distance=84 kB, estimate=84 kB; lsn=4/5B4AACE8, redo lsn=4/5B4AACB0
Nov 25 11:25:06 2025-11-25 10:25:06.018 UTC [50] LOG: checkpoint starting: time
Nov 25 11:25:06 2025-11-25 10:25:06.328 UTC [50] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.302 s, sync=0.002 s, total=0.310 s; sync files=4, longest=0.001 s, average=0.001 s; distance=5 kB, estimate=76 kB; lsn=4/5B4AC428, redo lsn=4/5B4AC3F0
Nov 25 11:30:06 2025-11-25 10:30:06.428 UTC [50] LOG: checkpoint starting: time
Nov 25 11:30:08 2025-11-25 10:30:08.143 UTC [50] LOG: checkpoint complete: wrote 18 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.706 s, sync=0.004 s, total=1.716 s; sync files=17, longest=0.001 s, average=0.001 s; distance=75 kB, estimate=76 kB; lsn=4/5B4BF108, redo lsn=4/5B4BF0D0
Nov 25 11:35:06 2025-11-25 10:35:06.243 UTC [50] LOG: checkpoint starting: time
Nov 25 11:35:12 2025-11-25 10:35:12.375 UTC [50] LOG: checkpoint complete: wrote 62 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=6.117 s, sync=0.010 s, total=6.133 s; sync files=41, longest=0.004 s, average=0.001 s; distance=331 kB, estimate=331 kB; lsn=4/5B512088, redo lsn=4/5B512050
Nov 25 11:40:06 2025-11-25 10:40:06.475 UTC [50] LOG: checkpoint starting: time
Nov 25 11:40:14 2025-11-25 10:40:14.721 UTC [50] LOG: checkpoint complete: wrote 83 buffers (0.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=8.222 s, sync=0.017 s, total=8.247 s; sync files=65, longest=0.006 s, average=0.001 s; distance=409 kB, estimate=409 kB; lsn=4/5B5801C0, redo lsn=4/5B578670
Nov 25 11:45:06 2025-11-25 10:45:06.814 UTC [50] LOG: checkpoint starting: time
Nov 25 11:45:11 2025-11-25 10:45:11.746 UTC [50] LOG: checkpoint complete: wrote 50 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.917 s, sync=0.008 s, total=4.932 s; sync files=39, longest=0.002 s, average=0.001 s; distance=254 kB, estimate=393 kB; lsn=4/5B5B7F18, redo lsn=4/5B5B7EE0
Nov 25 11:50:06 2025-11-25 10:50:06.844 UTC [50] LOG: checkpoint starting: time
Nov 25 11:50:08 2025-11-25 10:50:08.762 UTC [50] LOG: checkpoint complete: wrote 20 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.907 s, sync=0.007 s, total=1.918 s; sync files=18, longest=0.005 s, average=0.001 s; distance=79 kB, estimate=362 kB; lsn=4/5B5CBDB8, redo lsn=4/5B5CBD80
Nov 25 11:55:06 2025-11-25 10:55:06.857 UTC [50] LOG: checkpoint starting: time
Nov 25 11:55:08 2025-11-25 10:55:08.270 UTC [50] LOG: checkpoint complete: wrote 15 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.405 s, sync=0.005 s, total=1.414 s; sync files=14, longest=0.002 s, average=0.001 s; distance=24 kB, estimate=328 kB; lsn=4/5B5D1F60, redo lsn=4/5B5D1F28
Nov 25 12:00:06 2025-11-25 11:00:06.357 UTC [50] LOG: checkpoint starting: time
Nov 25 12:00:08 2025-11-25 11:00:08.072 UTC [50] LOG: checkpoint complete: wrote 18 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.706 s, sync=0.004 s, total=1.715 s; sync files=16, longest=0.001 s, average=0.001 s; distance=78 kB, estimate=303 kB; lsn=4/5B5E5878, redo lsn=4/5B5E5840
Nov 25 12:05:06 2025-11-25 11:05:06.170 UTC [50] LOG: checkpoint starting: time
Nov 25 12:05:08 2025-11-25 11:05:08.500 UTC [50] LOG: checkpoint complete: wrote 24 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.312 s, sync=0.005 s, total=2.331 s; sync files=18, longest=0.001 s, average=0.001 s; distance=85 kB, estimate=281 kB; lsn=4/5B6050B0, redo lsn=4/5B5FAED0
Nov 25 12:10:06 2025-11-25 11:10:06.598 UTC [50] LOG: checkpoint starting: time
Nov 25 12:10:15 2025-11-25 11:10:15.340 UTC [50] LOG: checkpoint complete: wrote 88 buffers (0.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=8.726 s, sync=0.011 s, total=8.742 s; sync files=65, longest=0.002 s, average=0.001 s; distance=365 kB, estimate=365 kB; lsn=4/5B67E168, redo lsn=4/5B6565D8
Nov 25 12:15:06 2025-11-25 11:15:06.420 UTC [50] LOG: checkpoint starting: time
Nov 25 12:15:17 2025-11-25 11:15:17.864 UTC [50] LOG: checkpoint complete: wrote 115 buffers (0.7%); 0 WAL file(s) added, 0 removed, 0 recycled; write=11.431 s, sync=0.009 s, total=11.445 s; sync files=50, longest=0.002 s, average=0.001 s; distance=697 kB, estimate=697 kB; lsn=4/5B711078, redo lsn=4/5B704D80
Nov 25 12:20:06 2025-11-25 11:20:06.954 UTC [50] LOG: checkpoint starting: time
Nov 25 12:20:17 2025-11-25 11:20:17.705 UTC [50] LOG: checkpoint complete: wrote 108 buffers (0.7%); 0 WAL file(s) added, 0 removed, 0 recycled; write=10.739 s, sync=0.008 s, total=10.752 s; sync files=55, longest=0.001 s, average=0.001 s; distance=634 kB, estimate=691 kB; lsn=4/5B7A3870, redo lsn=4/5B7A3838
Nov 25 12:25:06 2025-11-25 11:25:06.799 UTC [50] LOG: checkpoint starting: time
Nov 25 12:25:19 2025-11-25 11:25:19.245 UTC [50] LOG: checkpoint complete: wrote 125 buffers (0.8%); 0 WAL file(s) added, 0 removed, 0 recycled; write=12.431 s, sync=0.009 s, total=12.447 s; sync files=61, longest=0.003 s, average=0.001 s; distance=709 kB, estimate=709 kB; lsn=4/5B85D2E8, redo lsn=4/5B854DF0
Nov 25 12:30:06 2025-11-25 11:30:06.344 UTC [50] LOG: checkpoint starting: time
Nov 25 12:30:16 2025-11-25 11:30:16.788 UTC [50] LOG: checkpoint complete: wrote 105 buffers (0.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=10.429 s, sync=0.009 s, total=10.444 s; sync files=54, longest=0.002 s, average=0.001 s; distance=545 kB, estimate=693 kB; lsn=4/5B8DD548, redo lsn=4/5B8DD4D8
Nov 25 12:35:06 2025-11-25 11:35:06.880 UTC [50] LOG: checkpoint starting: time
Nov 25 12:35:09 2025-11-25 11:35:09.300 UTC [50] LOG: checkpoint complete: wrote 25 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.410 s, sync=0.004 s, total=2.421 s; sync files=21, longest=0.001 s, average=0.001 s; distance=93 kB, estimate=633 kB; lsn=4/5B8F4AB8, redo lsn=4/5B8F4A80
Nov 25 12:40:06 2025-11-25 11:40:06.395 UTC [50] LOG: checkpoint starting: time
Nov 25 12:40:08 2025-11-25 11:40:08.514 UTC [50] LOG: checkpoint complete: wrote 22 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.107 s, sync=0.006 s, total=2.119 s; sync files=22, longest=0.002 s, average=0.001 s; distance=70 kB, estimate=576 kB; lsn=4/5B9065F0, redo lsn=4/5B9065B8
Nov 25 12:45:06 2025-11-25 11:45:06.614 UTC [50] LOG: checkpoint starting: time
Nov 25 12:45:07 2025-11-25 11:45:07.226 UTC [50] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.603 s, sync=0.003 s, total=0.613 s; sync files=5, longest=0.002 s, average=0.001 s; distance=34 kB, estimate=522 kB; lsn=4/5B90F040, redo lsn=4/5B90F008
Nov 25 12:50:06 2025-11-25 11:50:06.326 UTC [50] LOG: checkpoint starting: time
Nov 25 12:50:13 2025-11-25 11:50:13.962 UTC [50] LOG: checkpoint complete: wrote 77 buffers (0.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=7.621 s, sync=0.010 s, total=7.636 s; sync files=64, longest=0.002 s, average=0.001 s; distance=341 kB, estimate=504 kB; lsn=4/5B9660C0, redo lsn=4/5B964680
Nov 25 12:55:07 2025-11-25 11:55:07.055 UTC [50] LOG: checkpoint starting: time
Nov 25 12:55:15 2025-11-25 11:55:15.898 UTC [50] LOG: checkpoint complete: wrote 89 buffers (0.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=8.827 s, sync=0.010 s, total=8.843 s; sync files=44, longest=0.002 s, average=0.001 s; distance=599 kB, estimate=599 kB; lsn=4/5B9FA420, redo lsn=4/5B9FA3E8
Nov 25 13:00:07 2025-11-25 12:00:07.995 UTC [50] LOG: checkpoint starting: time
Nov 25 13:00:15 2025-11-25 12:00:15.830 UTC [50] LOG: checkpoint complete: wrote 79 buffers (0.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=7.822 s, sync=0.010 s, total=7.836 s; sync files=62, longest=0.002 s, average=0.001 s; distance=352 kB, estimate=574 kB; lsn=4/5BA525E8, redo lsn=4/5BA525B0
Nov 25 13:05:07 2025-11-25 12:05:07.930 UTC [50] LOG: checkpoint starting: time
Nov 25 13:05:12 2025-11-25 12:05:12.857 UTC [50] LOG: checkpoint complete: wrote 50 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.915 s, sync=0.008 s, total=4.928 s; sync files=39, longest=0.003 s, average=0.001 s; distance=142 kB, estimate=531 kB; lsn=4/5BA86420, redo lsn=4/5BA75E88
Nov 25 13:10:07 2025-11-25 12:10:07.948 UTC [50] LOG: checkpoint starting: time
Nov 25 13:10:14 2025-11-25 12:10:14.079 UTC [50] LOG: checkpoint complete: wrote 62 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=6.119 s, sync=0.007 s, total=6.132 s; sync files=51, longest=0.001 s, average=0.001 s; distance=291 kB, estimate=507 kB; lsn=4/5BABEC18, redo lsn=4/5BABEBE0
Nov 25 13:15:07 2025-11-25 12:15:07.178 UTC [50] LOG: checkpoint starting: time
Nov 25 13:15:13 2025-11-25 12:15:13.509 UTC [50] LOG: checkpoint complete: wrote 64 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=6.319 s, sync=0.008 s, total=6.332 s; sync files=50, longest=0.002 s, average=0.001 s; distance=303 kB, estimate=487 kB; lsn=4/5BB11CE8, redo lsn=4/5BB0A9B0
Nov 25 13:20:07 2025-11-25 12:20:07.607 UTC [50] LOG: checkpoint starting: time
Nov 25 13:20:13 2025-11-25 12:20:13.135 UTC [50] LOG: checkpoint complete: wrote 56 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.518 s, sync=0.005 s, total=5.528 s; sync files=36, longest=0.001 s, average=0.001 s; distance=260 kB, estimate=464 kB; lsn=4/5BB4BC90, redo lsn=4/5BB4BC20
Nov 25 13:25:07 2025-11-25 12:25:07.232 UTC [50] LOG: checkpoint starting: time
Nov 25 13:25:07 2025-11-25 12:25:07.542 UTC [50] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.303 s, sync=0.003 s, total=0.310 s; sync files=4, longest=0.002 s, average=0.001 s; distance=2 kB, estimate=418 kB; lsn=4/5BB4C7E0, redo lsn=4/5BB4C7A8
Nov 25 13:30:07 2025-11-25 12:30:07.634 UTC [50] LOG: checkpoint starting: time
Nov 25 13:30:18 2025-11-25 12:30:18.981 UTC [50] LOG: checkpoint complete: wrote 114 buffers (0.7%); 0 WAL file(s) added, 0 removed, 0 recycled; write=11.331 s, sync=0.011 s, total=11.347 s; sync files=74, longest=0.002 s, average=0.001 s; distance=472 kB, estimate=472 kB; lsn=4/5BBC2A40, redo lsn=4/5BBC2A08
Nov 25 13:35:08 2025-11-25 12:35:08.077 UTC [50] LOG: checkpoint starting: time
Nov 25 13:35:13 2025-11-25 12:35:13.806 UTC [50] LOG: checkpoint complete: wrote 58 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.715 s, sync=0.008 s, total=5.729 s; sync files=37, longest=0.002 s, average=0.001 s; distance=286 kB, estimate=454 kB; lsn=4/5BC0A638, redo lsn=4/5BC0A600
Nov 25 13:40:08 2025-11-25 12:40:08.906 UTC [50] LOG: checkpoint starting: time
Nov 25 13:40:18 2025-11-25 12:40:18.248 UTC [50] LOG: checkpoint complete: wrote 95 buffers (0.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=9.326 s, sync=0.010 s, total=9.343 s; sync files=63, longest=0.003 s, average=0.001 s; distance=456 kB, estimate=456 kB; lsn=4/5BC7C8A0, redo lsn=4/5BC7C868
Nov 25 13:45:03 [GET] /healthcheck
Nov 25 13:45:03 healthcheck: disconnected
Nov 25 13:45:08 2025-11-25 12:45:08.348 UTC [50] LOG: checkpoint starting: time
Nov 25 13:45:10 2025-11-25 12:45:10.568 UTC [50] LOG: checkpoint complete: wrote 23 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.209 s, sync=0.006 s, total=2.221 s; sync files=21, longest=0.002 s, average=0.001 s; distance=83 kB, estimate=419 kB; lsn=4/5BC91888, redo lsn=4/5BC91850
Nov 25 13:50:08 2025-11-25 12:50:08.660 UTC [50] LOG: checkpoint starting: time
Nov 25 13:50:10 2025-11-25 12:50:10.681 UTC [50] LOG: checkpoint complete: wrote 21 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.011 s, sync=0.005 s, total=2.022 s; sync files=19, longest=0.002 s, average=0.001 s; distance=81 kB, estimate=385 kB; lsn=4/5BCA6078, redo lsn=4/5BCA5FF0
Nov 25 13:55:08 2025-11-25 12:55:08.780 UTC [50] LOG: checkpoint starting: time
Nov 25 13:55:08 2025-11-25 12:55:08.889 UTC [50] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.102 s, sync=0.002 s, total=0.109 s; sync files=2, longest=0.001 s, average=0.001 s; distance=2 kB, estimate=347 kB; lsn=4/5BCA69E8, redo lsn=4/5BCA69B0
Nov 25 14:00:08 2025-11-25 13:00:08.988 UTC [50] LOG: checkpoint starting: time

[perelin]

Ah: all other apps are fine btw.

[joseph]

@perelin have you already tried App -> Repair -> Try task again?

[james]

Hello @perelin
If still erroring.
Let's try giving the N8N app and the PostgreSQL service more memory and try again.

[perelin]

@joseph I just tried "App -> Repair -> Try task again" ... and it fixed both apps. ... Is now a good time to feel stupid? Asking for a friend...