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

qiita.com | 5 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 | 5 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

    Root Cause Analysis

    1. 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

      at org.flywaydb.core.internal.dbsupport.SqlScript.execute()
    2. ${project.artifactId}
      TransactionTemplate.execute
      1. org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
      2. org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
      3. org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:284)
      4. org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:282)
      5. org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
      6. org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:282)
      7. org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46)
      8. org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207)
      9. org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
      10. org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
      10 frames