org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException: Script failed ------------- SQL State : 90079 Error Code : 90079 Message : スキーマ "public" が見つかりません Schema "public" not found; SQL statement: CREATE TABLE "public"."schema_version" ( "version_rank" INT NOT NULL, "installed_rank" INT NOT NULL, "version" VARCHAR(50) NOT NULL, "description" VARCHAR(200) NOT NULL, "type" VARCHAR(20) NOT NULL, "script" VARCHAR(1000) NOT NULL, "checksum" INT, "installed_by" VARCHAR(100) NOT NULL, "installed_on" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, "execution_time" INT NOT NULL, "success" BOOLEAN NOT NULL ) [90079-190] Line : 17 Statement : CREATE TABLE "public"."schema_version" ( "version_rank" INT NOT NULL, "installed_rank" INT NOT NULL, "version" VARCHAR(50) NOT NULL, "description" VARCHAR(200) NOT NULL, "type" VARCHAR(20) NOT NULL, "script" VARCHAR(1000) NOT NULL, "checksum" INT, "installed_by" VARCHAR(100) NOT NULL, "installed_on" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, "execution_time" INT NOT NULL, "success" BOOLEAN NOT NULL )

qiita.com | 6 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Flyway + H2 with MySQL Compatibility Mode - Qiita

    qiita.com | 6 months ago
    org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException: Script failed ------------- SQL State : 90079 Error Code : 90079 Message : スキーマ "public" が見つかりません Schema "public" not found; SQL statement: CREATE TABLE "public"."schema_version" ( "version_rank" INT NOT NULL, "installed_rank" INT NOT NULL, "version" VARCHAR(50) NOT NULL, "description" VARCHAR(200) NOT NULL, "type" VARCHAR(20) NOT NULL, "script" VARCHAR(1000) NOT NULL, "checksum" INT, "installed_by" VARCHAR(100) NOT NULL, "installed_on" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, "execution_time" INT NOT NULL, "success" BOOLEAN NOT NULL ) [90079-190] Line : 17 Statement : CREATE TABLE "public"."schema_version" ( "version_rank" INT NOT NULL, "installed_rank" INT NOT NULL, "version" VARCHAR(50) NOT NULL, "description" VARCHAR(200) NOT NULL, "type" VARCHAR(20) NOT NULL, "script" VARCHAR(1000) NOT NULL, "checksum" INT, "installed_by" VARCHAR(100) NOT NULL, "installed_on" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, "execution_time" INT NOT NULL, "success" BOOLEAN NOT NULL )

    Root Cause Analysis

    1. org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException

      Script failed ------------- SQL State : 90079 Error Code : 90079 Message : スキーマ "public" が見つかりません Schema "public" not found; SQL statement: CREATE TABLE "public"."schema_version" ( "version_rank" INT NOT NULL, "installed_rank" INT NOT NULL, "version" VARCHAR(50) NOT NULL, "description" VARCHAR(200) NOT NULL, "type" VARCHAR(20) NOT NULL, "script" VARCHAR(1000) NOT NULL, "checksum" INT, "installed_by" VARCHAR(100) NOT NULL, "installed_on" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, "execution_time" INT NOT NULL, "success" BOOLEAN NOT NULL ) [90079-190] Line : 17 Statement : CREATE TABLE "public"."schema_version" ( "version_rank" INT NOT NULL, "installed_rank" INT NOT NULL, "version" VARCHAR(50) NOT NULL, "description" VARCHAR(200) NOT NULL, "type" VARCHAR(20) NOT NULL, "script" VARCHAR(1000) NOT NULL, "checksum" INT, "installed_by" VARCHAR(100) NOT NULL, "installed_on" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, "execution_time" INT NOT NULL, "success" BOOLEAN NOT NULL )

      at org.flywaydb.core.internal.dbsupport.SqlScript.execute()
    2. ${project.artifactId}
      Flyway.execute
      1. org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
      2. org.flywaydb.core.internal.metadatatable.MetaDataTableImpl.createIfNotExists(MetaDataTableImpl.java:93)
      3. org.flywaydb.core.internal.metadatatable.MetaDataTableImpl.lock(MetaDataTableImpl.java:100)
      4. org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:158)
      5. org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
      6. org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
      7. org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156)
      8. org.flywaydb.core.Flyway$1.execute(Flyway.java:1059)
      9. org.flywaydb.core.Flyway$1.execute(Flyway.java:1006)
      10. org.flywaydb.core.Flyway.execute(Flyway.java:1418)
      10 frames