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…

[صورة] 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 li…

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

[صورة] 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?

[صورة] 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?

[صورة] Wingtip: is the switching method documented? You can check out Move from standalone container to separate web and data containers [صورة] 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 c…

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.

مشكلة في إعادة البناء بسبب بطء إغلاق قاعدة البيانات

الدعم تثبيت

pfaffman (Jay Pfaffman) 25 أبريل 2023، 2:59م 21

إذًا، هل تريد الانتقال بسرعة إلى حاويات ويب وبيانات منفصلة

الموضوع		الردود	مرات العرض
Upgrade failed due to unclean database shutdown Self-hosting	21	4309	9 نوفمبر 2017
Discourse update doesn't wait for Postgress DB to shut down Self-hosting	5	1064	28 يناير 2022
Database system was not properly shut down error when rebuilding Self-hosting	4	7012	19 سبتمبر 2019
2.6.0 Beta4 update failed with what looks like db errors Self-hosting	7	728	18 نوفمبر 2020
Bootstrap failed, please help :( Self-hosting	6	1015	3 يناير 2023

مشكلة في إعادة البناء بسبب بطء إغلاق قاعدة البيانات

الموضوعات ذات الصلة