CODEWITHSUNDEEP
databaseflyway
Gwen
Gwen

Reputation: 321

flyway exception, detected failed migration

I've got a Flyway exception:

FlywayException: Detected failed migration to version 1.0

I looked for on documentation and forums but I didn't found what mean this exception. Please someone can tell me what can be the reasons of these exception ! Thanks

Upvotes: 32

Views: 68743

Answers (3)

K. Gol
K. Gol

Reputation: 1616

You can also do it by manual update by changing value of column success from 0 to 1 in corresponding row. Of course it cause that the corresponding script will not execute again, so You have to make sure that all the changes applied to database. I'm not recommend it to do on production. It shouldn't happen on production rather on developing environments.

Upvotes: 0

Isidro Vásquez
Isidro Vásquez

Reputation: 281

Make 

select * from your_database_name.flyway_schema_history

you will get something like this:

Query to flyway_schema_history table query to flyway_schema_history table]

Then find the entry that corresponds to the migration that is failing and delete it, it should work.

Upvotes: 28

SudhirR
SudhirR

Reputation: 779

"FlywayException: Detected failed migration to version 1.0"

it means that you ran migrate before and it failed at 1.0 for some reason. You need to identify why the previous migration failed at 1.0 and solve it if you have already not done so. Once solved you need to run flyway repair to tell flyway that whatever failed is now out of the way.

Then run flyway migrate again. If it fails again, you are back on step 1. Good luck with the migration.

Upvotes: 42

Related Questions