redsocks157
Cadet
- Joined
- Jan 12, 2024
- Messages
- 2
Hoping someone can help me out here, because I am not sure exactly what's gone wrong.
This morning, Nextcloud (TrueNAS official version) recommended that I use Redis for file locking. I installed Redis (TrueNAS official version) and then added the env variables for Redis to Nextcloud through the GUI. I clicked "Update", but the app couldn't restart. I managed to get logs which point to a postgresql issue:
If I'm reading this correctly, the postgres database is corrupted! I have no idea how that happened - all I did was add 3 env variables.
I've tried getting into the postgres container shell, but I can't access it. That means I can't run any commands that might recover the database from whatever has happened here. In the nextcloud app settings, it says there is a "Postgres Backup Volume" but I have no idea how to use that to restore my database.
Really hoping someone has an idea here!
This morning, Nextcloud (TrueNAS official version) recommended that I use Redis for file locking. I installed Redis (TrueNAS official version) and then added the env variables for Redis to Nextcloud through the GUI. I clicked "Update", but the app couldn't restart. I managed to get logs which point to a postgresql issue:
Code:
2024-01-12 10:46:20.058369-05:002024-01-12T10:46:20.058369068-05:00 2024-01-12 10:46:20.058423-05:00PostgreSQL Database directory appears to contain a database; Skipping initialization 2024-01-12 10:46:20.058441-05:002024-01-12T10:46:20.058441396-05:00 2024-01-12 10:46:20.094628-05:002024-01-12 15:46:20.094 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 2024-01-12 10:46:20.094839-05:002024-01-12 15:46:20.094 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-01-12 10:46:20.094868-05:002024-01-12 15:46:20.094 UTC [1] LOG: listening on IPv6 address "::", port 5432 2024-01-12 10:46:20.096844-05:002024-01-12 15:46:20.096 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2024-01-12 10:46:20.100899-05:002024-01-12 15:46:20.100 UTC [26] LOG: database system was shut down at 2024-01-12 13:00:12 UTC 2024-01-12 10:46:20.101250-05:002024-01-12 15:46:20.101 UTC [26] LOG: invalid resource manager ID 101 at 2/858258C0 2024-01-12 10:46:20.101285-05:002024-01-12 15:46:20.101 UTC [26] LOG: invalid primary checkpoint record 2024-01-12 10:46:20.101312-05:002024-01-12 15:46:20.101 UTC [26] PANIC: could not locate a valid checkpoint record 2024-01-12 10:46:20.102390-05:002024-01-12 15:46:20.102 UTC [1] LOG: startup process (PID 26) was terminated by signal 6: Aborted 2024-01-12 10:46:20.102415-05:002024-01-12 15:46:20.102 UTC [1] LOG: aborting startup due to startup process failure 2024-01-12 10:46:20.104057-05:002024-01-12 15:46:20.103 UTC [1] LOG: database system is shut down
If I'm reading this correctly, the postgres database is corrupted! I have no idea how that happened - all I did was add 3 env variables.
I've tried getting into the postgres container shell, but I can't access it. That means I can't run any commands that might recover the database from whatever has happened here. In the nextcloud app settings, it says there is a "Postgres Backup Volume" but I have no idea how to use that to restore my database.
Really hoping someone has an idea here!