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 )

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via qiita.com by Unknown author, 1 year ago
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
via GitHub by eranmizrahi
, 10 months ago
## 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 ```
via GitHub by hohwille
, 1 year ago
Migration V9001_1__Delete_data.sql failed ----------------------------------------- SQL State : 42S02 Error Code : 42102 Message : Table "RESTAURANTTABLE" not found; SQL statement: DELETE FROM RESTAURANTTABLE [42102-190] Location : AllTests
via GitHub by kubo44
, 1 year ago
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"
via GitHub by wgillett
, 1 year ago
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"
via Stack Overflow by Walter Gillett
, 1 year ago
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"
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(SqlScript.java:117)
at org.flywaydb.core.internal.metadatatable.MetaDataTableImpl.createIfNotExists(MetaDataTableImpl.java:93)
at org.flywaydb.core.internal.metadatatable.MetaDataTableImpl.lock(MetaDataTableImpl.java:100)
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:158)
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:1059)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:1006)
at org.flywaydb.core.Flyway.execute(Flyway.java:1418)

Users with the same issue

3 times, 5 months ago

Know the solutions? Share your knowledge to help other developers to debug faster.