failed to create mysql table

[melin]

Whether the primary key of the table is id

[admin@dp0653 hortonworks-registry-0.5.4]$ ./bootstrap/bootstrap-storage.sh create
Using Configuration file: ./bootstrap/../conf/registry.yaml
[main] INFO org.flywaydb.core.internal.util.VersionPrinter - Flyway Community Edition 5.1.4 by Boxfuse
[main] INFO org.flywaydb.core.internal.database.DatabaseFactory - Database: jdbc:mysql://10.57.17.125:3306/schema_registry (MySQL 5.6)
[main] INFO org.flywaydb.core.internal.command.DbValidate - Successfully validated 4 migrations (execution time 00:00.011s)
[main] INFO org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory - Creating Schema History table: `schema_registry`.`DATABASE_CHANGE_LOG`
[main] INFO org.flywaydb.core.internal.command.DbMigrate - Current version of schema `schema_registry`: << Empty Schema >>
[main] INFO org.flywaydb.core.internal.command.DbMigrate - Migrating schema `schema_registry` to version 001 - create tables
[main] WARN org.flywaydb.core.internal.database.ExecutableSqlScript - DB: Specified key was too long; max key length is 767 bytes (SQL State: 42000 - Error Code: 1071)
[main] ERROR org.flywaydb.core.internal.command.DbMigrate - Migration of schema `schema_registry` to version 001 - create tables failed! Please restore backups and roll back database and code!
"create" option failed : org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Migration v001__create_tables.sql failed
----------------------------------------
SQL State  : 42000
Error Code : 1071
Message    : Specified key was too long; max key length is 767 bytes
Location   : ./bootstrap/sql/mysql/v001__create_tables.sql (/home/admin/hortonworks-registry-0.5.4/./bootstrap/sql/mysql/v001__create_tables.sql)
Line       : 21
Statement  : CREATE TABLE IF NOT EXISTS schema_metadata_info (
  id              BIGINT AUTO_INCREMENT NOT NULL,
  type            VARCHAR(255)          NOT NULL,
  schemaGroup     VARCHAR(255)          NOT NULL,
  name            VARCHAR(255)          NOT NULL,
  compatibility   VARCHAR(255)          NOT NULL,
  validationLevel VARCHAR(255)          NOT NULL,
  description     TEXT,
  evolve          BOOLEAN               NOT NULL,
  timestamp       BIGINT                NOT NULL,
  PRIMARY KEY (name),
  UNIQUE KEY (id)
)

[satishd]

@melin Which registry version are you using? Pl send mysql server details including storage engine.

[melin]

@melin Which registry version are you using? Pl send mysql server details including storage engine.

hortonworks-registry version: 0.5.4 mysql version: 5.6.35

[gcsaba2]

Closed due to inactivity.