I just did the weekly update for our Discourse site and found that instead of taking the regular 1-2 minutes, this time about 20 minutes were needed. Also, progress update temporarily broke with timeout errors in the Chrome console at step $ SKIP_POST_DEPLOYMENT_MIGRATIONS=1 bundle exec rake multisi…

I am not sure there is anything we can do now. We need to drop the index and if your forum happened to be super busy at the time it can take a while. Assume all is well now?

Yes, things are back to normal now, so no immediate problem. The main reason I reported it here was that the progress indicator was temporarily broken, and that’s maybe something that could lead people to believe the update has crashed (not sure how much can really be done here). [圖片] Sam Saffr…

Dropping that index on a server with only 6k users should take milliseconds, even on a spinning metal disk; it’s a strong indicator that your DB is starved for resources

Ok, thanks! I wasn’t aware that DB tuning would be required (we’re using the single container setup) and there’s not much else running on the machine (Discourse, Mailcow, Traefik, Crowdsec). But I’ll have a closer look. Any pointers to relevant documentation in this regard? The only thing I’m aware…

I suspect this is because we didn’t drop the index concurrently. A normal DROP INDEX acquires an ACCESS EXCLUSIVE lock on the table, blocking other accesses until the index drop can be completed. This should be fixed in PERF: Update migration to drop index concurrently. by tgxworld · Pull Reques…

更新大约需要20分钟，进度更新在 multisite:migrate 步骤暂时中断

支持

sam (Sam Saffron) 2024年九月16日 00:05 3

我现在不确定我们还能做什么。

我们需要删除索引，如果您的论坛当时非常繁忙，可能需要一段时间。

假设现在一切都好？

話題		回覆	觀看
Stuck on “bundle exec rake multisite:migrate”..help Support	2	659	2018年九月20日
'bundle exec rake db:migrate' taking a long time due to calendar migration Self-hosting	33	1132	2023年十二月5日
PostgreSQL 13 update Announcements	2	11288	2023年九月13日
Long runtime moving posts / timeout errors Support	3	145	2025年二月9日
Upgrade failed: ERROR: relation "idx_regular_post_search_data" already exists Self-hosting	2	732	2020年八月21日

更新大约需要20分钟，进度更新在 multisite:migrate 步骤暂时中断

相關主題