search

nextcloud / all-in-one

📦 The official Nextcloud installation method. Provides easy deployment and maintenance with most features included in this one Nextcloud instance.
https://hub.docker.com/r/nextcloud/all-in-one
GNU Affero General Public License v3.0
5.45k stars 629 forks source link

Borg Backup's fail after 8.1 automatic update. #4534

Closed madman2012 closed 6 months ago

madman2012 commented 6 months ago

Ever since containers were updated to 8.1 latest, I am getting the following errors on automatic overnight Borg backups. Unraid host.:

Borg reports: Cannot create a backup now. Reason is that the database export failed the last time. Most likely was the database container not correctly shut down via the AIO interface.

You might want to try the database export again manually by running the three commands: sudo docker start nextcloud-aio-database sleep 10 sudo docker stop nextcloud-aio-database -t 1800

Afterwards try to create a backup again and it should hopefully work. If it should still fail, feel free to report this to https://github.com/nextcloud/all-in-one/issues and post the database container logs and the borgbackup container logs into the thread. Thanks!

nextcloud-aio-database reports: text error warn system array login

chmod: /var/run/postgresql: Operation not permitted 2024-04-11 00:02:16.667 EDT [14] LOG: starting PostgreSQL 15.6 on x86_64-pc-linux-musl, compiled by gcc (Alpine 13.2.1_git20231014) 13.2.1 20231014, 64-bit 2024-04-11 00:02:16.667 EDT [14] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-04-11 00:02:16.667 EDT [14] LOG: listening on IPv6 address "::", port 5432 2024-04-11 00:02:16.690 EDT [14] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2024-04-11 00:02:16.803 EDT [24] LOG: database system was interrupted; last known up at 2024-04-10 23:58:26 EDT 2024-04-11 00:02:16.842 EDT [24] LOG: database system was not properly shut down; automatic recovery in progress 2024-04-11 00:02:16.867 EDT [24] LOG: redo starts at 1E/F098B480 2024-04-11 00:02:16.928 EDT [24] LOG: invalid record length at 1E/F106CBB8: wanted 24, got 0 2024-04-11 00:02:16.928 EDT [24] LOG: redo done at 1E/F106CB90 system usage: CPU: user: 0.03 s, system: 0.02 s, elapsed: 0.06 s 2024-04-11 00:02:20.237 EDT [14] LOG: database system is ready to accept connections Setting postgres values...

PostgreSQL Database directory appears to contain a database; Skipping initialization

szaimen commented 6 months ago

Hi, can you do this as recommended?

You might want to try the database export again manually by running the three commands:
sudo docker start nextcloud-aio-database
sleep 10
sudo docker stop nextcloud-aio-database -t 1800

Afterwards try to create a backup again and it should hopefully work.