Caused by: org.flywaydb.core.api.FlywayException: Validate failed: Migration checksum mismatch for m

Caused by: org.flywaydb.core.api.FlywayException: Validate failed: Migration checksum mismatch for migration version 700013

When spring boot integrates flyway for database version management, the startup service reports an error org.flywaydb.core.api.flywayexception: validate failed: detected failed migration to version 1.1 (fixusername)

reason:

Because I modified SQL in the original version, this error is mainly due to flyway_ schema_ The recorded data in history affects the startup and needs to be checked

Solution 1:

If you don’t want to recreate a version,
you need to find the relevant table in the database, delete the data related to this version, modify and restore the fields related to this version, and then reload it

Solution 2

Create a new version, write the relevant data changes to the version, and restart the project

Read More: