org.flywaydb.core.api.FlywayException: Validate failed. Migration Checksum mismatch for migration xxx 解决办法


项目使用了Flyway作为数据库管理,在一次启动项目的时候,连接了其他同事初始化过的数据库,但是到一半的时候,启动报错

Caused by: org.flywaydb.core.api.FlywayException: Validate failed. Migration Checksum mismatch for migration 1.5
-> Applied to database : -602935793
-> Resolved locally    : -204613028
	at org.flywaydb.core.Flyway.doValidate(Flyway.java:1108)
	at org.flywaydb.core.Flyway.access$300(Flyway.java:62)
	at org.flywaydb.core.Flyway$1.execute(Flyway.java:1012)
	at org.flywaydb.core.Flyway$1.execute(Flyway.java:1006)
	at org.flywaydb.core.Flyway.execute(Flyway.java:1418)
	at org.flywaydb.core.Flyway.migrate(Flyway.java:1006)
	at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:66)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1687)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624)
	... 38 common frames omitted
Disconnected from the target VM, address: '127.0.0.1:64535', transport: 'socket'

原因是我们初始化的数据库换行符不对应导致checksum值不相同,flyway就卡在这里不动了,于是修改了
换行符修改位置如下:
Alt
修改后再次启动就正常了

Logo

鸿蒙生态一站式服务平台。

更多推荐