springboot整合flyway数据库迁移

最新推荐文章于 2025-10-14 10:39:48 发布

原创

最新推荐文章于 2025-10-14 10:39:48 发布 · 890 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#springboot #flyway

在执行SpringBoot集成Flyway的数据库迁移时遇到错误，提示用户表已经存在。错误信息包括SQL状态42S01和错误代码42101。解决方法是删除或更新冲突的迁移文件V1__Create_user_table.sql中的用户表创建语句。

[ERROR] Failed to execute goal org.flywaydb:flyway-maven-plugin:6.0.8:migrate (default-cli) on project nice-community: org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
[ERROR] Migration V1__Create_user_table.sql failed
[ERROR] ------------------------------------------
[ERROR] SQL State : 42S01
[ERROR] Error Code : 42101
[ERROR] Message : Table "USER" already exists; SQL statement:
[ERROR] create table USER
[ERROR] (
[ERROR] ID INTEGER auto_increment,
[ERROR] ACCOUNT_ID VARCHAR(100),
[ERROR] NAME VARCHAR(50),
[ERROR] TOKEN CHAR(36),
[ERROR] GMT_CREATE BIGINT,
[ERROR] GMT_MODIFIED BIGINT,
[ERROR] constraint USER_PK
[ERROR] prim