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 | 4 months ago
  1. 0

    Flyway + H2 with MySQL Compatibility Mode - Qiita

    qiita.com | 4 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 )
  2. 0

    sbt flywayMigrate throws exception for missing driver, although doing the actual migration

    GitHub | 9 months ago | eranmizrahi
    org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException: ## Script failed SQL State : 42S01 Error Code : 1050 Message : Table 'schema_version' already exists Line : 17 Statement : CREATE TABLE `test123`.`schema_version` ( `execution_time` INT NOT NULL, `success` BOOL NOT NULL ) ENGINE=InnoDB ```
  3. 0

    Upgrading H2 DB from Flyway 2.0.3 to 4.0 failed - couldn't upgrade metadata table

    GitHub | 10 months ago | kubo44
    org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException: Script failed ------------- SQL State : 90057 Error Code : 90057 Message : Constraint "ABC_SCHEMA_VERSION_pk" not found; SQL statement: ALTER TABLE "PUBLIC"."ABC_SCHEMA_VERSION" DROP CONSTRAINT "ABC_SCHEMA_VERSION_pk" [90057-170] Line : 20 Statement : ALTER TABLE "PUBLIC"."ABC_SCHEMA_VERSION" DROP CONSTRAINT "ABC_SCHEMA_VERSION_pk"
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Flyway 4.0 upgrade failed on Amazon Redshift database - FlywaySqlScriptException

    Stack Overflow | 11 months ago | Walter Gillett
    org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException: Script failed ------------- SQL State : XX000 Error Code : 500310 Message : [Amazon](500310) Invalid operation: cannot insert/update into table after dropping non-nullable column; Line : 20 Statement : UPDATE "public"."schema_version" SET "version_temp"="version"

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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