Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-10086

SQLBinaryManager tests fails to create binaries table on MySQL 5.5

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.6
    • Fix Version/s: 5.6.0-HF01, 5.7.1
    • Component/s: Core VCS, Tests

      Description

      SQLBinaryManager fails to create binaries table on MySQL 5.5:

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

      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:39)
      	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
      	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:1052)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
      	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
      	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
      	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
      	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
      	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:842)
      	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:681)
      	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:260)
      	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:260)
      	at org.nuxeo.ecm.core.storage.sql.TestSQLBinaryManager.setUp(TestSQLBinaryManager.java:124)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                fguillaume Florent Guillaume
                Reporter:
                fguillaume Florent Guillaume
                Participants:
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: