java - Flyway 5.0.7 不适用于 cockroach db V.2.0

Question

这是我的场景。

• Cockroach DB 版本 = 2.0
• Flyway Ceriosn = 5.0.7
• 平台 = Docker

我有一个 Java 应用程序，它使用 Flyway 来管理我的架构。

我的配置如下所示:我的 Flyway build.gradle 看起来像:

buildscript {
dependencies {
    classpath "org.postgresql:postgresql:42.1.4"
 }
}
 plugins {
     id "org.flywaydb.flyway" version "5.0.7"
 }

description = "test-app"

flyway {
    url = jdbc:postgresql://localhost:26257/test_dev?sslmode=disable
 user = root
password = 
}

我正在我的本地主机上以不安全模式运行 cockroach v 2.0。

当我运行时:

gradle flywayClean

我明白了

Flyway upgrade recommended: CockroachDB 2.0 is newer than this version of Flyway and support 
has not been tested.
Unable to clean unknown schema: "test_dev"

当我运行时:

gradle flywayMigrate

我得到:

Database: jdbc:postgresql://localhost:26257/test_dev (PostgreSQL 9.5)
Flyway upgrade recommended: CockroachDB 2.0 is newer than this version of Flyway and support has not been tested.
Creating schema "test_dev" ...
Creating schema "test_dev" ...
Creating schema "test_dev" ...
Creating schema "test_dev" ...
Creating schema "test_dev" ...
Creating schema "test_dev" ...
Creating schema "test_dev" ...
Creating schema "test_dev" ...
Creating schema "test_dev" ...
Creating schema "test_dev" ...

:test-migrations:flywayMigrate (Thread[Task worker for ':',5,main]) completed. Took 19.995 secs.

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':test-migrations:flywayMigrate'.
> Error occurred while executing flywayMigrate

  Unable to create schema "test_dev"
  --------------------------------------------------
  SQL State  : 42P04
  Error Code : 0
  Message    : ERROR: database "test_dev" already exists

  ERROR: database "test_dev" already exists

我在这里可能缺少什么？

Answer 1

根据文档，仅支持1.1版本。

https://flywaydb.org/documentation/database/cockroachdb

Flyway 5.1 版本将支持版本 2.0。

https://github.com/flyway/flyway/issues/1970