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 年9 月 16 日 11:13 5

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

话题		回复	浏览量
Stuck on “bundle exec rake multisite:migrate”..help Support	3	624	2018 年9 月 20 日
'bundle exec rake db:migrate' taking a long time due to calendar migration Self-hosting	33	909	2023 年12 月 5 日
PostgreSQL 13 update Announcements	3	11121	2025 年5 月 12 日
Long runtime moving posts / timeout errors Support	3	74	2025 年2 月 9 日
Upgrade failed: ERROR: relation "idx_regular_post_search_data" already exists Self-hosting	3	667	2020 年9 月 20 日

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

相关话题