java.sql.SQLException: Flyway migration error occurred

Google Groups | Sean Carte | 3 months ago
  1. 0

    DSpace-CRIS Database Update Failure

    Google Groups | 3 months ago | Sean Carte
    java.sql.SQLException: Flyway migration error occurred
  2. 0

    [Dspace-tech] Upgrading dspace database, getting constraint errors

    Google Groups | 1 year ago | Anton Angelo
    org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException: Error > executing statement at line 84: alter table community drop column > introductory_text, drop column short_description, drop column > side_bar_text, drop column copyright_text, drop column name at > org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:91) at > org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:73) at > org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:287) at > org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:285) at > org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) at > org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:285) at > org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46) at > org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207) 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)
  3. 0

    Flyway + H2 with MySQL Compatibility Mode - Qiita

    qiita.com | 2 months ago
    org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException: Migration V1__hoge.sql failed ------------------------------ SQL State : 42000 Error Code : 42000 Message : SQLステートメントに文法エラーがあります "CREATE TABLE ""HOGES"" ( ""HOGE_ID"" BIGINT NOT NULL AUTO_INCREMENT, ""NAME"" VARCHAR(255) NOT NULL, ""EMAIL"" VARCHAR(255) NOT NULL, ""URL"" VARCHAR(255) DEFAULT NULL, ""COMMENT"" TEXT DEFAULT NULL, ""CREATED_AT"" DATETIME DEFAULT NULL, ""UPDATED_AT"" DATETIME DEFAULT NULL, PRIMARY KEY (""HOGE_ID""), UNIQUE KEY ""INDEX_HOGES_ON_EMAIL"" (""EMAIL"") ) ENGINE=INNODB DEFAULT CHARSET=UTF8 COLLATE[*]=UTF8_GENERAL_CI " Syntax error in SQL statement "CREATE TABLE ""HOGES"" ( ""HOGE_ID"" BIGINT NOT NULL AUTO_INCREMENT, ""NAME"" VARCHAR(255) NOT NULL, ""EMAIL"" VARCHAR(255) NOT NULL, ""URL"" VARCHAR(255) DEFAULT NULL, ""COMMENT"" TEXT DEFAULT NULL, ""CREATED_AT"" DATETIME DEFAULT NULL, ""UPDATED_AT"" DATETIME DEFAULT NULL, PRIMARY KEY (""HOGE_ID""), UNIQUE KEY ""INDEX_HOGES_ON_EMAIL"" (""EMAIL"") ) ENGINE=INNODB DEFAULT CHARSET=UTF8 COLLATE[*]=UTF8_GENERAL_CI "; SQL statement: CREATE TABLE `hoges` ( `hoge_id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `url` varchar(255) DEFAULT NULL, `comment` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`hoge_id`), UNIQUE KEY `index_hoges_on_email` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci [42000-190] Location : db/migration/V1__hoge.sql (/Users/niwashun/Workspaces/hogemoge/target/dev/scala-2.11/classes/db/migration/V1__hoge.sql) Line : 1 Statement : CREATE TABLE `hoges` ( `hoge_id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `url` varchar(255) DEFAULT NULL, `comment` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`hoge_id`), UNIQUE KEY `index_hoges_on_email` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Flyway baselines new schemas, since they always have a schema_version table.

    GitHub | 2 years ago | benheilers
    org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException: Migration V2__AddColumn.sql failed ---------------------------------- SQL State : 42P01 Error Code : 0 Message : ERROR: relation "test_table" does not exist Location : db/migration/V2__AddColumn.sql (/home/heilers/perforce/ben-linux/main/twopi/overlord/event-channel/realtime-processing/db/migration/V2__AddColumn.sql) Line : 1 Statement : ALTER TABLE test_table ADD date_created timestamp
  6. 0

    Flyway 4.0 upgrade failed on Amazon Redshift database - FlywaySqlScriptException

    Stack Overflow | 9 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

      Error executing statement at line 9: alter table cris_do_wpointer add column urlPath varchar(255)

      at org.flywaydb.core.internal.dbsupport.SqlScript.execute()
    2. ${project.artifactId}
      SqlMigrationExecutor.execute
      1. org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:91)
      2. org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:73)
      2 frames