Flyway BigQuer migration synchronisation issues

[liran-p]

Which version and edition of Flyway are you using?

9.10.2

If this is not the latest version, can you reproduce the issue with the latest one as well? (Many bugs are fixed in newer releases and upgrading will often resolve the issue)

reproduction is challenging as requires BigQuery data changes. With emulator there are other issues.

Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin)

Java API

Which database are you using? (Type & version)

BigQuery

Which operating system are you using?

Linux

What did you do? (Please include the content causing the issue, any relevant configuration settings, the SQL statement(s) that failed (if any), and the command you ran)

When there are new migration files, and multiple Flyway migrations running in parallel at different instances, observed multiple entries on Flyway schema version table, meaning the same migration runs multiple times. This can cause some of them to report failure, even though one instance run can succeed.

What did you expect to see?

Each migration file should be executed only once.

What did you see instead?

Multiple entries on Flyway schema version table for same migration file, meaning the same migration runs multiple times.