This was a issue apart of another thread but I figure I would make a separate one since they aren’t the same issue (i think). (previous thread: Attempted to upgrade and I think I messed something up - installation - Discourse Meta) This is the error I am getting: [image]

[image] Headless: Seems like issues relating to the database? I’m guessing, but it seems possible that the database was uncleanly shutdown, needs to do a recover, and isn’t quite being given enough time to finish that. In fact, see this previous thread: [image]Discourse update doesn't wait for Postgress DB to shut down Whenever this happens, we usually (temporarily, as otherwise Git gets confused when updating the next time) replace the sleep 5 with a few more seconds so that Postgres has more time to settle/recover. discourse_docker/templates/postgres.template.yml at 4cd6a5d96ab1efee9b6893d781c8af9d3d2f56e2 · discourse/discourse_docker · GitHub and perhaps see also this much earlier thread: [image]FATAL: the database system is starting up Try increasing the sleep in templates/postgres.template.yml locally. Is your server slow? Database too big?

the alternative being maybe data corruption/loss, I guess I rather find out there have been some weird dependency issue between an old kernel and docker 20.10 that in turn kept psql to start… but I agree that’s a looong shot :roll_eyes: and that would beg the question “why now?”

I really doubt this, I feel like it has to be I must have stopped and uninstalled/reinstalled docker during the shutdown process of the database, im not entirely sure though.

What is the contents of /var/discourse/shared/standalone?

find that using ls /var/discourse/shared/standalone

I moved that to a different volume the contents are shown below: root@discourse:/var/discourse# ls /mnt/volume-2/standalone/ -al total 64 drwxr-xr-x 16 root root 4096 Feb 5 2021 . drwxr-xr-x 3 root root 4096 Aug 30 2020 .. drwxr-xr-x 3 1000 www-data 4096 Aug 30 2020 backups drwxr-xr-x 10 root root 4096 Nov 20 08:35 letsencrypt drwxr-xr-x 4 root root 4096 Aug 30 2020 log drwxr-xr-x 2 systemd-resolve input 4096 Aug 30 2020 postgres_backup drwx------ 19 systemd-resolve input 4096 Nov 20 12:01 postgres_data drwx------ 20 uuidd uuidd 4096 Feb 5 2021 postgres_data_old drwxrwxr-x 5 systemd-resolve input 4096 Nov 20 12:01 postgres_run drwxr-xr-x 2 messagebus syslog 4096 Nov 20 08:38 redis_data drwxr-xr-x 2 root root 4096 Dec 1 2020 ssl drwxr-xr-x 3 root root 4096 Aug 30 2020 standalone drwxr-xr-x 4 root root 4096 Aug 30 2020 state drwxr-xr-x 4 1000 www-data 4096 Nov 20 08:36 tmp drwxr-xr-x 2 root root 4096 Aug 30 2020 uploads drwxr-xr-x 4 root root 4096 Aug 30 2020 uploads.orig

So even without the container, it appears you have some state of the database potentially intact. Whatever you experiment with, keep a copy of this safe. The way things are set up you can normally access the DB from within container as it sits on a docker volume. If you can get a container built again you may be able to access this again, or else you would need to install postgres on the server (but that will be redundant once you get things working again).

Yeah the hardest part is just getting the rebuild to even work. Without that Im basically screwed as it seems. But ill def copy the contents of this folder to my local machien just in case

Updated as in pulling and rebuilding? I do it every few months or so.

what is the most recent backup? ls /var/discourse/shared/standalone/backups ?

Building bootstrap error

Product Support Self-hosting

itsbhanusharma (Bhanu Sharma) November 20, 2022, 11:37am 35

It looks like a failed postgres update to me. @Headless what is the last time you updated your site from command line?

Topic		Replies	Views
Pups::ExecError: su postgres -c 'psql discourse -c "alter schema public owner to discourse;"' failed with return Self-hosting	29	2242	February 12, 2023
Latest site upgrade not working Self-hosting	10	1989	February 22, 2022
Can't rebuild due to failed postgres 12 upgrade Self-hosting	44	4659	July 13, 2020
Postgres Errors on Rebuild Self-hosting	2	1753	September 16, 2015
Discourse update error Self-hosting	35	2682	January 30, 2023

Building bootstrap error

Related topics