liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE kirlko_xvanmit.DATABASECHANGELOG (ID VARCHAR(63) NOT NULL, AUTHOR VARCHAR(63) NOT NULL, FILENAME VARCHAR(200) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35) NULL, DESCRIPTION VARCHAR(255) NULL, COMMENTS VARCHAR(255) NULL, TAG VARCHAR(255) NULL, LIQUIBASE VARCHAR(20) NULL, CONSTRAINT PK_DATABASECHANGELOG PRIMARY KEY (ID, AUTHOR, FILENAME)): Specified key was too long; max key length is 767 bytes

JIRA | Gábor Czigola | 3 years ago
  1. 0

    Liquibase fails to initialize alltogether when being used in the listed environment. In particular MySQL is not supported at all. It fails to create the necessary DATABASECHANGELOG table due to index key length being to long. SEVERE 9/30/13 9:37 PM:liquibase: null: null: Error executing SQL CREATE TABLE kirlko_xvanmit.DATABASECHANGELOG (ID VARCHAR(63) NOT NULL, AUTHOR VARCHAR(63) NOT NULL, FILENAME VARCHAR(200) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35) NULL, DESCRIPTION VARCHAR(255) NULL, COMMENTS VARCHAR(255) NULL, TAG VARCHAR(255) NULL, LIQUIBASE VARCHAR(20) NULL, CONSTRAINT PK_DATABASECHANGELOG PRIMARY KEY (ID, AUTHOR, FILENAME)): Specified key was too long; max key length is 767 bytes liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE kirlko_xvanmit.DATABASECHANGELOG (ID VARCHAR(63) NOT NULL, AUTHOR VARCHAR(63) NOT NULL, FILENAME VARCHAR(200) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35) NULL, DESCRIPTION VARCHAR(255) NULL, COMMENTS VARCHAR(255) NULL, TAG VARCHAR(255) NULL, LIQUIBASE VARCHAR(20) NULL, CONSTRAINT PK_DATABASECHANGELOG PRIMARY KEY (ID, AUTHOR, FILENAME)): Specified key was too long; max key length is 767 bytes at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:56) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:98) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:64) at liquibase.database.AbstractJdbcDatabase.checkDatabaseChangeLogTable(AbstractJdbcDatabase.java:732) at liquibase.Liquibase.checkDatabaseChangeLogTable(Liquibase.java:609) at liquibase.Liquibase.listLocks(Liquibase.java:629) at liquibase.Liquibase.reportLocks(Liquibase.java:635) at liquibase.integration.commandline.Main.doMigration(Main.java:795) at liquibase.integration.commandline.Main.main(Main.java:138) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:525) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2812) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2761) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732) at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:86) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:49) ... 8 more

    JIRA | 3 years ago | Gábor Czigola
    liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE kirlko_xvanmit.DATABASECHANGELOG (ID VARCHAR(63) NOT NULL, AUTHOR VARCHAR(63) NOT NULL, FILENAME VARCHAR(200) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35) NULL, DESCRIPTION VARCHAR(255) NULL, COMMENTS VARCHAR(255) NULL, TAG VARCHAR(255) NULL, LIQUIBASE VARCHAR(20) NULL, CONSTRAINT PK_DATABASECHANGELOG PRIMARY KEY (ID, AUTHOR, FILENAME)): Specified key was too long; max key length is 767 bytes
  2. 0

    Liquibase fails to initialize alltogether when being used in the listed environment. In particular MySQL is not supported at all. It fails to create the necessary DATABASECHANGELOG table due to index key length being to long. SEVERE 9/30/13 9:37 PM:liquibase: null: null: Error executing SQL CREATE TABLE kirlko_xvanmit.DATABASECHANGELOG (ID VARCHAR(63) NOT NULL, AUTHOR VARCHAR(63) NOT NULL, FILENAME VARCHAR(200) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35) NULL, DESCRIPTION VARCHAR(255) NULL, COMMENTS VARCHAR(255) NULL, TAG VARCHAR(255) NULL, LIQUIBASE VARCHAR(20) NULL, CONSTRAINT PK_DATABASECHANGELOG PRIMARY KEY (ID, AUTHOR, FILENAME)): Specified key was too long; max key length is 767 bytes liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE kirlko_xvanmit.DATABASECHANGELOG (ID VARCHAR(63) NOT NULL, AUTHOR VARCHAR(63) NOT NULL, FILENAME VARCHAR(200) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35) NULL, DESCRIPTION VARCHAR(255) NULL, COMMENTS VARCHAR(255) NULL, TAG VARCHAR(255) NULL, LIQUIBASE VARCHAR(20) NULL, CONSTRAINT PK_DATABASECHANGELOG PRIMARY KEY (ID, AUTHOR, FILENAME)): Specified key was too long; max key length is 767 bytes at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:56) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:98) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:64) at liquibase.database.AbstractJdbcDatabase.checkDatabaseChangeLogTable(AbstractJdbcDatabase.java:732) at liquibase.Liquibase.checkDatabaseChangeLogTable(Liquibase.java:609) at liquibase.Liquibase.listLocks(Liquibase.java:629) at liquibase.Liquibase.reportLocks(Liquibase.java:635) at liquibase.integration.commandline.Main.doMigration(Main.java:795) at liquibase.integration.commandline.Main.main(Main.java:138) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:525) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2812) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2761) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732) at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:86) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:49) ... 8 more

    JIRA | 3 years ago | Gábor Czigola
    liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE kirlko_xvanmit.DATABASECHANGELOG (ID VARCHAR(63) NOT NULL, AUTHOR VARCHAR(63) NOT NULL, FILENAME VARCHAR(200) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35) NULL, DESCRIPTION VARCHAR(255) NULL, COMMENTS VARCHAR(255) NULL, TAG VARCHAR(255) NULL, LIQUIBASE VARCHAR(20) NULL, CONSTRAINT PK_DATABASECHANGELOG PRIMARY KEY (ID, AUTHOR, FILENAME)): Specified key was too long; max key length is 767 bytes
  3. 0

    After run liquibase script in Ubuntu get error but in windows work fine

    Stack Overflow | 1 year ago | Bohdan Olehovich
    liquibase.exception.DatabaseException: Table 'database.batch_job_execution' doesn't exist [Failed SQL: CREATE INDEX JOB_START_STATUS ON database.batch_job_execution(STATUS, START_TIME)]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Specified key was too long; max key length is 767 bytes

    GitHub | 4 years ago | dewick
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
  6. 0

    [MRM-1373] Archiva fails when default charset in database is UTF 8 - ASF JIRA

    apache.org | 1 year ago
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes

  1. Kialandei 1 times, last 2 weeks ago
  2. tvrmsmith 6 times, last 3 weeks ago
  3. davidvanlaatum 4 times, last 2 months ago
  4. tvrmsmith 1 times, last 4 months ago
  5. qoomon 1 times, last 4 months ago
27 more registered users
62 unregistered visitors
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. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

    Specified key was too long; max key length is 767 bytes

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:525)
    4 frames
  3. MySQL jdbc
    StatementImpl.execute
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    2. com.mysql.jdbc.Util.getInstance(Util.java:386)
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
    4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
    6. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
    7. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
    8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2812)
    9. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2761)
    10. com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894)
    11. com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732)
    11 frames
  4. Liquibase Core
    Main.main
    1. liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:86)
    2. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:49)
    3. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:98)
    4. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:64)
    5. liquibase.database.AbstractJdbcDatabase.checkDatabaseChangeLogTable(AbstractJdbcDatabase.java:732)
    6. liquibase.Liquibase.checkDatabaseChangeLogTable(Liquibase.java:609)
    7. liquibase.Liquibase.listLocks(Liquibase.java:629)
    8. liquibase.Liquibase.reportLocks(Liquibase.java:635)
    9. liquibase.integration.commandline.Main.doMigration(Main.java:795)
    10. liquibase.integration.commandline.Main.main(Main.java:138)
    10 frames