TrueNAS Scale Nextcloud application postgres error

[pavelk]

Hi all! I've been using the TrueNAS scale installation for a few months now, and everything worked correctly until recently. The Nextcloud app from TrueNAS Charts has stopped working, and is stuck on "deployment". Here's what I think is causing the problem, this is the nextcloud-postgres startup log:

2023-09-05 17:43:58.775878+00:002023-09-05T17:43:58.775878760Z 2023-09-05 17:43:58.775937+00:00PostgreSQL Database directory appears to contain a database; Skipping initialization 2023-09-05 17:43:58.775948+00:002023-09-05T17:43:58.775948591Z 2023-09-05 17:43:58.822023+00:002023-09-05 17:43:58.821 UTC [1] LOG: starting PostgreSQL 13.1 (Debian 13.1-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit 2023-09-05 17:43:58.822179+00:002023-09-05 17:43:58.822 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2023-09-05 17:43:58.822199+00:002023-09-05 17:43:58.822 UTC [1] LOG: listening on IPv6 address "::", port 5432 2023-09-05 17:43:58.964849+00:002023-09-05 17:43:58.964 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2023-09-05 17:43:59.017928+00:002023-09-05 17:43:59.017 UTC [27] LOG: database system was interrupted while in recovery at 2023-09-05 17:43:56 UTC 2023-09-05 17:43:59.017994+00:002023-09-05 17:43:59.017 UTC [27] HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery. 2023-09-05 17:43:59.084006+00:002023-09-05 17:43:59.083 UTC [27] LOG: database system was not properly shut down; automatic recovery in progress 2023-09-05 17:43:59.091685+00:002023-09-05 17:43:59.091 UTC [27] LOG: redo starts at 0/6A1F10B8 2023-09-05 17:44:09.979624+00:002023-09-05 17:44:09.979 UTC [35] FATAL: the database system is starting up 2023-09-05 17:44:11.959832+00:002023-09-05 17:44:11.959 UTC [44] FATAL: the database system is starting up 2023-09-05 17:44:12.017056+00:002023-09-05 17:44:12.016 UTC [47] FATAL: the database system is starting up 2023-09-05 17:44:12.216685+00:002023-09-05 17:44:12.213 UTC [27] FATAL: unexpected data beyond EOF in block 35 of relation base/16384/2840 2023-09-05 17:44:12.216745+00:002023-09-05 17:44:12.213 UTC [27] HINT: This has been seen to occur with buggy kernels; consider updating your system. 2023-09-05 17:44:12.216764+00:002023-09-05 17:44:12.213 UTC [27] CONTEXT: WAL redo at 0/B928AD18 for Heap2/CLEAN: remxid 1212457 2023-09-05 17:44:12.217526+00:002023-09-05 17:44:12.217 UTC [1] LOG: startup process (PID 27) exited with exit code 1 2023-09-05 17:44:12.217585+00:002023-09-05 17:44:12.217 UTC [1] LOG: aborting startup due to startup process failure 2023-09-05 17:44:12.227239+00:002023-09-05 17:44:12.225 UTC [1] LOG: database system is shut down

I've tried restoring the datasets and volumes from snapshots, but with no luck. Am i doing something wrong? If so, how to restore operation of the app?