com.cenqua.crucible.hibernate.CruDBException: Problem with constraints script C:\fecru\fecru-2.10.1\sql\MYSQL\schema\constraints_80.sql

Atlassian JIRA | Gurleen Anand [Atlassian] | 4 years ago
  1. 0

    DB migration from HSQLDB to MySQL 5.6 failing with: {noformat} 2013-02-14 09:48:17,932 ERROR [ThreadPool2 ] fisheye DBEditHelper-doGet - Database migration failed: com.cenqua.crucible.hibernate.CruDBException: Problem with constraints script C:\fecru\fecru-2.10.1\sql\MYSQL\schema\constraints_80.sql com.cenqua.crucible.hibernate.CruDBException: Problem with constraints script C:\fecru\fecru-2.10.1\sql\MYSQL\schema\constraints_80.sql at com.cenqua.crucible.hibernate.DefaultDBControl.addConstraints(DefaultDBControl.java:344) at com.atlassian.crucible.migration.item.DBImporter.importData(DBImporter.java:145) at com.atlassian.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:90) at com.atlassian.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:72) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) at java.util.concurrent.FutureTask.run(FutureTask.java:166) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) Caused by: com.cenqua.crucible.hibernate.CruDBException: SQL script error on line 124: "create index cru_idx_stored_path on cru_stored_path (cru_path);" (Specified key was too long; max key length is 767 bytes), please contact http://www.atlassian.com/support/ at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:510) at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:441) at com.cenqua.crucible.hibernate.DefaultDBControl.addConstraints(DefaultDBControl.java:338) ... 10 more 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:1053) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2788) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1816) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1730) at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:482) ... 12 more {noformat} This seems to have exceeded the [Innodb limit|http://dev.mysql.com/doc/refman/5.6/en/innodb-restrictions.html] of 767 bytes. Not being experienced on MySQL 5.5

    Atlassian JIRA | 4 years ago | Gurleen Anand [Atlassian]
    com.cenqua.crucible.hibernate.CruDBException: Problem with constraints script C:\fecru\fecru-2.10.1\sql\MYSQL\schema\constraints_80.sql
  2. 0

    DB migration from HSQLDB to MySQL 5.6 failing with: {noformat} 2013-02-14 09:48:17,932 ERROR [ThreadPool2 ] fisheye DBEditHelper-doGet - Database migration failed: com.cenqua.crucible.hibernate.CruDBException: Problem with constraints script C:\fecru\fecru-2.10.1\sql\MYSQL\schema\constraints_80.sql com.cenqua.crucible.hibernate.CruDBException: Problem with constraints script C:\fecru\fecru-2.10.1\sql\MYSQL\schema\constraints_80.sql at com.cenqua.crucible.hibernate.DefaultDBControl.addConstraints(DefaultDBControl.java:344) at com.atlassian.crucible.migration.item.DBImporter.importData(DBImporter.java:145) at com.atlassian.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:90) at com.atlassian.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:72) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) at java.util.concurrent.FutureTask.run(FutureTask.java:166) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) Caused by: com.cenqua.crucible.hibernate.CruDBException: SQL script error on line 124: "create index cru_idx_stored_path on cru_stored_path (cru_path);" (Specified key was too long; max key length is 767 bytes), please contact http://www.atlassian.com/support/ at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:510) at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:441) at com.cenqua.crucible.hibernate.DefaultDBControl.addConstraints(DefaultDBControl.java:338) ... 10 more 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:1053) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2788) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1816) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1730) at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:482) ... 12 more {noformat} This seems to have exceeded the [Innodb limit|http://dev.mysql.com/doc/refman/5.6/en/innodb-restrictions.html] of 767 bytes. Not being experienced on MySQL 5.5

    Atlassian JIRA | 4 years ago | Gurleen Anand [Atlassian]
    com.cenqua.crucible.hibernate.CruDBException: Problem with constraints script C:\fecru\fecru-2.10.1\sql\MYSQL\schema\constraints_80.sql
  3. 0

    RE: UPDATE RE: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes (beeline - hive server 2)

    hive-user | 1 year ago | Timothy Garza
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    答复: UPDATE RE: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes (beeline - hive server 2)

    hive-user | 1 year ago | San Luo
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
  6. 0

    RE: UPDATE RE: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes (beeline - hive server 2)

    hive-user | 1 year ago | Timothy Garza
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes

  1. Kialandei 1 times, last 1 week ago
  2. jshakil 1 times, last 1 month ago
  3. mortalman7 1 times, last 4 months ago
  4. MoYapro 1 times, last 1 week ago
  5. tvrmsmith 6 times, last 2 weeks ago
27 more registered users
66 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.executeUpdate
    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:1053)
    4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
    6. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
    7. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
    8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2788)
    9. com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1816)
    10. com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1730)
    10 frames
  4. com.cenqua.crucible
    DefaultDBControl.addConstraints
    1. com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:482)
    2. com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:441)
    3. com.cenqua.crucible.hibernate.DefaultDBControl.addConstraints(DefaultDBControl.java:338)
    3 frames
  5. com.atlassian.crucible
    DBEditHelper$ImportRunner.call
    1. com.atlassian.crucible.migration.item.DBImporter.importData(DBImporter.java:145)
    2. com.atlassian.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:90)
    3. com.atlassian.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:72)
    3 frames
  6. Java RT
    Thread.run
    1. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
    2. java.util.concurrent.FutureTask.run(FutureTask.java:166)
    3. java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
    4. java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
    5. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    6. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    7. java.lang.Thread.run(Thread.java:722)
    7 frames