我试图使用天桥作为我现有数据库的迁移工具,使用:
天桥V5.2.4 & Mysql V8.0.16
但是当迁移给我这个错误时:
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.internal.exception.FlywaySqlException:
Error while retrieving the list of applied migrations from Schema History table `allexpress`.`flyway_schema_history`
------------------------------------------------------------------------------
SQL State : HY000
Error Code : 1100
Message : Table 'flyway_schema_history' was not locked with LOCK TABLES
Caused by: org.flywaydb.core.internal.exception.FlywaySqlException:
Error while retrieving the list of applied migrations from Schema History table `allexpress`.`flyway_schema_history`
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.internal.exception.FlywaySqlException:
Error while retrieving the list of applied migrations from Schema History table `allexpress`.`flyway_schema_history`
发布于 2020-03-02 16:48:16
我最近遇到了这个错误。检查日志中的天桥警告。我收到了同样的错误消息,但问题来自一个缺少值的insert。
发布于 2021-09-22 06:49:43
检查您的DML sql,高概率应该是语法错误
https://stackoverflow.com/questions/57338913
复制相似问题