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

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major 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)
  1. Text File
    wrapper.txt
    05/Mar/08 9:45 AM
    64 kB
    Arnaud Heritier

Issue Links

is superceded by

Task - A task that needs to be done. MRM-1025 remove the archiva database

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.
relates to

Bug - A problem which impairs or prevents the functions of the product. MRM-227 Archiva doesn't suppost UTF-8 databases in Mysql

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.

Bug - A problem which impairs or prevents the functions of the product. MRM-415 [MySQL] Specified key was too long; max key length is 765 bytes

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Arnaud Heritier added a comment -

I have the same issue with archiva 1.0.1 (standalone) MySql version 5.0.22, driver jdbc mysql 5.1.5

Show
Arnaud Heritier added a comment - I have the same issue with archiva 1.0.1 (standalone) MySql version 5.0.22, driver jdbc mysql 5.1.5
Hide
Permalink
Arnaud Heritier added a comment -

Wrapper logs

Show
Arnaud Heritier added a comment - Wrapper logs
Hide
Permalink
Arnaud Heritier added a comment -

The problem seems to be in rednack and no more in archiva itself. Fixing the application.xml for redback like in MRM-227 fixes the issue

Show
Arnaud Heritier added a comment - The problem seems to be in rednack and no more in archiva itself. Fixing the application.xml for redback like in MRM-227 fixes the issue
Hide
Permalink
Wendy Smoak added a comment -

Also mentioned on this blog http://flexandjava.blogspot.com/2009/03/archiva-and-mysql.html

Show
Wendy Smoak added a comment - Also mentioned on this blog http://flexandjava.blogspot.com/2009/03/archiva-and-mysql.html

People

  • Assignee:
    Brett Porter
    Reporter:
    Arnaud Heritier
Vote (2)
Watch (2)

Dates

  • Created:
    Updated:
    Resolved: