完整错误信息如下:
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文件名称才采用这种方式解决。
希望对你有用!