Migrations Often Fail When liquibase.datasources.default.async: true

[JasonTypesCodes]

When liquibase.datasources.default.async is true, migrations often (but not always) fail. Usually with an error referencing locks or a failure to transition to a state when another is still open. Something like:

Caused by: java.lang.RuntimeException: Cannot end scope omefbvcocj when currently at scope cnlydevtnl

For an example app, please see: https://github.com/JasonTypesCodes/mn-liquibase-259

Starting the app with ./gradlew run will likely illustrate the error. If your change liquibase.datasources.default.async to false, the issues go away.

Environment Information

• Operating System: Debian 10
• Micronaut Version: 2.5.9
• JDK Version: 11.0.8

Example Application

https://github.com/JasonTypesCodes/mn-liquibase-259

[ilopmar]

TBH I think introducing the async migrations wasn't a good idea. I haven't seen this error before until I've tried to upgrade to Liquibase 4.4.x. Now a couple of tests fail (sometimes) with that error.

[TheoMuffin]

I have the same problem using Micronaut v3.1.4. I need liquibase to run asynchronously because multirow inserts for lots of test data (divided into manageable changeset batches) take a long time to run and the microservice should be up and running quite a bit sooner