Uploaded image for project: 'Archiva'
  1. Archiva
  2. MRM-729

[MySQL] Specified key was too long; max key length is 765 bytes - in redback

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 1.0.1
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      When starting up archiva on a MySQL Database. the following error is seen.

      Caused by: javax.jdo.JDODataStoreException: An exception was thrown while adding/validating class(es) : Specified key was too long; max key length is 765 bytes
      com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Specified key was too long; max key length is 765 bytes
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
              at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)
              at com.mysql.jdbc.Connection.execSQL(Connection.java:3099)
              at com.mysql.jdbc.Statement.execute(Statement.java:695)
              at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
              at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
              at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
              at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
              at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3052)
              at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3313)
              at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2554)
              at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2406)
              at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:821)
              at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:835)
              at org.jpox.AbstractPersistenceManager.newObjectIdInstance(AbstractPersistenceManager.java:2377)
              at org.apache.maven.archiva.database.jdo.JdoAccess.getObjectById(JdoAccess.java:428)
              at org.apache.maven.archiva.database.jdo.JdoAccess.getObjectById(JdoAccess.java:466)
              at org.apache.maven.archiva.database.jdo.JdoRepositoryDAO.getRepository(JdoRepositoryDAO.java:76)
              at org.apache.maven.archiva.web.startup.ConfigurationSynchronization.synchConfiguration(ConfigurationSynchronization.java:94)
              at org.apache.maven.archiva.web.startup.ConfigurationSynchronization.initialize(ConfigurationSynchronization.java:147)
              at org.codehaus.plexus.personality.plexus.lifecycle.phase.InitializePhase.execute(InitializePhase.java:33)
      

        Attachments

        1. wrapper.txt
          64 kB
          Arnaud Heritier

          Issue Links

            Activity

              People

              • Assignee:
                brettporter Brett Porter
                Reporter:
                aheritier Arnaud Heritier
              • Votes:
                2 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: