postgresql - flyway 后的 Flyway 迁移错误:基线
问题描述
我在我的宠物项目中使用了 Java+Spring+Maven+Flyway+Postgres。这里 db/migration 中有两个 sql 文件。当我第一次运行应用程序时
mvn spring-boot:run
或在应用程序开始使用之前
mvn flyway:migrate -Dflyway.url=jdbc:postgresql://localhost:5432/university -Dflyway.user=tester -Dflyway.password=test
Db 是正确创建的,没有任何错误,但是当我想首先创建 V1 时
mvn flyway:baseline -Dflyway.url=jdbc:postgresql://localhost:5432/university -Dflyway.user=tester -Dflyway.password=test
在那之后:
mvn flyway:migrate -Dflyway.url=jdbc:postgresql://localhost:5432/university -Dflyway.user=tester -Dflyway.password=test
我发现错误:
[ERROR] Failed to execute goal org.flywaydb:flyway-maven-plugin:6.4.4:migrate (default-cli) on project universityschedule: org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
[ERROR] Migration V2__add_email_and_phone_to_person.sql failed
[ERROR] ------------------------------------------------------
[ERROR] SQL State : 42P01
[ERROR] Error Code : 0
[ERROR] Message : ERROR: relation "public.teacher" does not exist
为什么会发生?怎么修?
解决方案
Flyway 基线将与非空数据库一起使用。在这种情况下,假设第一次迁移代表将数据库创建到当前状态所需的 sql。因此,它假设您的V1
迁移不打算执行,只是将其标记为baseline
.
如果您只是迁移,跳过基线步骤,它应该可以正常工作。
推荐阅读
- apache-nifi - 如何读取 NIFI 进程指标?
- git - Failed to init source control in vscode
- flutter - Accidentally deleted flutter default widget code, how do I fix it?
- databricks - Databricks - How to remove files , directories based on regular expression
- reactjs - Unable to run jest tests in React typescript. Jest encountered an unexpected token
- python - Connect Django to Azure Analysis Services
- css - CSS Grid:内容在错误的行中
- spring-security - How to override the OAuth2AuthorizationServerSecurity's config?
- c++ - GPU with OpenCL is slower than CPU. Why?
- mongodb - Getting indices of distinct value in an array for each document