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日 11:13 5

在只有 6k 用户的服务器上删除该索引应该只需要几毫秒，即使是在旋转的物理磁盘上；这强烈表明您的数据库资源不足。

話題		回覆	觀看
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	11290	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 步骤暂时中断

相關主題