This recommended upgrade failed and didn’t get my forum back up after breaking. I’m running discourse-doctor now to try to fix it, and if that fails too, I took a VM snapshot. Output: 2023-04-19 18:28:31.298 UTC [42] LOG: received fast shutdown request 2023-04-19 18:28:33.651 UTC [65] LOG: shutt…

[image] Jay Pfaffman: How big is your database? Is it on ssd? How much ram do you have? When was 60s decided on for a safe shutdown? How many installations are now much bigger than was then normal? Ideally this 60s wait should be more of a closed-loop wait, with a limit. It sounds like the l…

It’s 105GB, on SSD, 16GB VM, and I gave postgres an 8GB buffer pool.

[image] Ed S: When was 60s decided on for a safe shutdown? I think I saw that it was at least as long ago as 2016. But things have changed. EDIT: Here’s a new commit. DEV: Wait up to 10 minutes for safe PG stop (#709) committed 08…

We’ll consider it, is the switching method documented? And are there any other advantages that increasing the 60s timer wouldn’t provide?

[image] Wingtip: that increasing the 60s timer wouldn’t provide? I increased it to 10 minutes yesterday

Oh great, I assumed he was posting the original commit back in 2016. So any advantages for us at all?

[image] Wingtip: is the switching method documented? You can check out Move from standalone container to separate web and data containers [image] Wingtip: And are there any other advantages that increasing the 60s timer wouldn’t provide? You can build a new container while the old one…

Oh that guy just built a completely new two container instance then restored from backup. We definitely aren’t doing that without a good reason, I just had to do it to avoid the PG13 upgrade disk space requirements like 2 months ago.

If you’re not on PG13 then you should fix that. I’d spin up a new server and move to it.

We are now, that one was ultimately unavoidable! Beyond the DB, we also needed to upgrade from the desupported 18.04LTS.

Problème de reconstruction à cause d'un arrêt lent de la base de données

Soutien Installation

pfaffman (Jay Pfaffman) Avril 25, 2023, 2:59 21

Vous voulez donc migrer rapidement vers des conteneurs web et de données séparés

Sujet		Réponses	Vues
Upgrade failed due to unclean database shutdown Self-hosting	21	4277	Novembre 9, 2017
Discourse update doesn't wait for Postgress DB to shut down Self-hosting	5	1022	Janvier 28, 2022
Database system was not properly shut down error when rebuilding Self-hosting	4	7005	Septembre 19, 2019
2.6.0 Beta4 update failed with what looks like db errors Self-hosting	7	725	Novembre 18, 2020
Bootstrap failed, please help :( Self-hosting	6	995	Janvier 3, 2023

Problème de reconstruction à cause d'un arrêt lent de la base de données

Sujets connexes