[BUG] flyway.postgresql.transactional.lock didn't find in flyway

[romankh3]

Describe the bug
After getting a new version of conductor, I've got an error while spring boot app is starting.

As far as I researched, flyway does not find prop flyway.postgresql.transactional.lock

Details
Conductor version:
implementation "org.conductoross:conductor-common:3.18.0"
implementation "org.conductoross:conductor-postgres-persistence:3.18.0"
implementation "org.conductoross:conductor-core:3.18.0"
implementation "org.conductoross:conductor-rest:3.18.0"

To Reproduce
Steps to reproduce the behavior:

1. start Spring boot app
2. See error in logs:
   Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayForPrimaryDb' defined in class path resource [com/netflix/conductor/postgres/config/PostgresConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.flywaydb.core.Flyway]: Factory method 'flywayForPrimaryDb' threw exception; nested exception is org.flywaydb.core.api.FlywayException: Unknown configuration property: flyway.postgresql.transactional.lock

Expected behavior
Spring boot app with conductor runs as expected

[astelmashenko]

I have got the same issue. I see there was an issue and it is in fixed state #92
There are no instructions how to fix that. Can anybody assist with the error?
In my case: conductor version 3.20.0

[dmitry-cherkas]

The error is super-misleading, so it took me a while to figure it out. With Flyway 9 -> 10 upgrade you need to explicitly add org.flywaydb:flyway-database-postgresql dependency to the classpath in addition to the flyway-core, this would solve this issue. More details in flyway/flyway#3780