org.flywaydb.core.api.FlywayException: Validate failed: Migration checksum mismatch for mgration ver

完整错误信息如下：

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
[2020-05-13 14:36:45,155][ERROR][main][SpringApplication][reportFailure] - Application run failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.api.FlywayException: Validate failed: Migration description mismatch for migration version 8
-> Applied to database : init machine
-> Resolved locally    : init machine status
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1694)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:573)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:495)
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:317)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:304)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
	at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1087)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:857)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:548)
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:140)
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:754)
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:386)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:307)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1242)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1230)
	at com.saicmotor.watchdog.service.Application.main(Application.java:25)
Caused by: org.flywaydb.core.api.FlywayException: Validate failed: Migration description mismatch for migration version 8
-> Applied to database : init machine
-> Resolved locally    : init machine status
	at org.flywaydb.core.Flyway.doValidate(Flyway.java:1482)
	at org.flywaydb.core.Flyway.access$100(Flyway.java:85)
	at org.flywaydb.core.Flyway$1.execute(Flyway.java:1364)
	at org.flywaydb.core.Flyway$1.execute(Flyway.java:1356)
	at org.flywaydb.core.Flyway.execute(Flyway.java:1711)
	at org.flywaydb.core.Flyway.migrate(Flyway.java:1356)
	at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:66)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1753)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1690)
	... 18 common frames omitted
Disconnected from the target VM, address: '127.0.0.1:64235', transport: 'socket'

这是项目的结构

我需要新建一张表，所以创建了V8_init_machine.sql的文件，项目启动后，查看数据库，新表已经创建成功。

后来觉得文件名称不合适，修改文件名为V8_init_machine_status.sql，再次启动项目时报错。

报错显示 Version 8 描述校验不一致

Caused by: org.flywaydb.core.api.FlywayException: Validate failed: Migration description mismatch for migration version 8
-> Applied to database : init machine
-> Resolved locally    : init machine status

包括像checksum校验不一致，两者的问题是一样的

Caused by: org.flywaydb.core.api.FlywayException: Validate failed: Migration checksum mismatch for migration version 8
-> Applied to database : -429572953
-> Resolved locally    : -1324546919

解决方法：
进入FlyWay配置的数据库，找到flyway_schema_history这张表，它是用来记录FlyWay的执行历史。

最直接的方法就是把第8条记录删掉，然后项目就可以成功启动并且执行V8这条SQL。
也可以手动修改记录，init machine 改为 init machine status,-429572953 改为 -1324546919。

当然，如果你的目的是修改表，如字段名、类型等，可以直接新建SQL文件，利用FlyWay去执行，不会报此错误。我这里是要修改SQL文件名称才采用这种方式解决。

希望对你有用！