springboot整合flyway数据库迁移

最新推荐文章于 2025-03-23 23:06:06 发布

niceguy_smile

最新推荐文章于 2025-03-23 23:06:06 发布

阅读量852

点赞数 1

分类专栏： springboot flyway 文章标签： springboot flyway

本文链接：https://blog.youkuaiyun.com/smile_foreach/article/details/103049818

版权

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[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] primary key (ID)
[ERROR] ) [42101-196]
[ERROR] Location : D:\ideapro\nice-community\src\main\resources\db\migration\V1__Create_user_table.sql (D:\ideapro\nic