Flyway - Error when executing locally about banking-kata-java

[valentinacupac]

@eamtalu the following appears when I try to run locally, could you check on your side too. Thanks!

[valentinacupac]

Thanks @eamtalu for the fix.

[valentinacupac]

@eamtalu, it was previously working when I tested it, but I now had another issue after docker-compose down....

docker-compose down -v
. .\env\env.ps1
docker-compose up -d

Then I called the tests:

.\gradlew adapter-persistence-jpa:test

Then I get this error:

PS C:\GitHub\valentinacupac\banking-kata-java> .\gradlew adapter-persistence-jpa:test  
> Task :adapter-persistence-jpa:flywayMigrate FAILED

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':adapter-persistence-jpa:flywayMigrate'.
> Error occurred while executing flywayMigrate
  Unable to obtain connection from database (jdbc:postgresql://localhost:5400/banking_kata_db) for user 'postgres': FATAL: database "banking_kata_db" does not exist
  ------------------------------------------------------------------------------------------------------------------------------------------------------------------
  SQL State  : 3D000
  Error Code : 0
  Message    : FATAL: database "banking_kata_db" does not exist

  FATAL: database "banking_kata_db" does not exist

Could you try the above steps too?

[eamtalu]

Hi @valentinacupac
I am using mac and seems you are using windows, so unable to test it properly.
In my mac, it is working for docker-compose down and docker-compose up -d.
But just on a hindsight - could you see the database is created after docker-compose up -d which should be created by this script ./startup/src/main/resources/postgres which is a shell script?

Seems in CI it is running perfectly in ubuntu machine where it creates database everytime, I believe somehow in windows the database is not being created at the first place, would you confirm ?

Thanks Amin