Update takes ~20 minutes and progress update breaks (temporarily) at step multisite:migrate

Support
7

I suspect this is because we didn鈥檛 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 Request #28955 路 discourse/discourse 路 GitHub.

@schneeland Thank you for taking the time to report the issue :+1:

2 Likes