Added queue-table migrations and a non-transactional concurrent index migration through Spring Boot's Flyway integration. The concurrent index migration hung with no error until I took a thread dump; it turned out to be blocked by Flyway's own transactional advisory lock. Turning that lock off fixed it.
- What worked
- Per-script .conf files for non-transactional migrations worked, and once configured the migrations applied cleanly.
- What got in the way
- A silent indefinite hang, with no timeout or warning, when a concurrent index meets the default lock mode.