From issues-return-24753-apmail-maven-issues-archive=maven.apache.org@maven.apache.org Sun Jun 17 21:57:22 2007 Return-Path: Delivered-To: apmail-maven-issues-archive@locus.apache.org Received: (qmail 83855 invoked from network); 17 Jun 2007 21:57:20 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 17 Jun 2007 21:57:20 -0000 Received: (qmail 94240 invoked by uid 500); 17 Jun 2007 21:57:23 -0000 Delivered-To: apmail-maven-issues-archive@maven.apache.org Received: (qmail 94181 invoked by uid 500); 17 Jun 2007 21:57:22 -0000 Mailing-List: contact issues-help@maven.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@maven.apache.org Delivered-To: mailing list issues@maven.apache.org Received: (qmail 94170 invoked by uid 99); 17 Jun 2007 21:57:22 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 17 Jun 2007 14:57:22 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Received: from [63.246.2.115] (HELO codehaus01.managed.contegix.com) (63.246.2.115) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 17 Jun 2007 14:57:18 -0700 Received: from codehaus01.managed.contegix.com (localhost.localdomain [127.0.0.1]) by codehaus01.managed.contegix.com (Postfix) with ESMTP id 1605D14A803F for ; Sun, 17 Jun 2007 16:56:58 -0500 (CDT) Message-ID: <30048877.1182117418086.JavaMail.haus-jira@codehaus01.managed.contegix.com> Date: Sun, 17 Jun 2007 16:56:58 -0500 (CDT) From: "Joakim Erdfelt (JIRA)" To: issues@maven.apache.org Subject: [jira] Commented: (MRM-415) [MySQL] Specified key was too long; max key length is 765 bytes In-Reply-To: <8149725.1182117117143.JavaMail.haus-jira@codehaus01.managed.contegix.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ http://jira.codehaus.org/browse/MRM-415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_99783 ] Joakim Erdfelt commented on MRM-415: ------------------------------------ Some more details... {code} NestedThrowables: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Specified key was too long; max key length is 765 bytes at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3330) 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) ... 55 more Caused by: 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) ... 61 more {code} > [MySQL] Specified key was too long; max key length is 765 bytes > --------------------------------------------------------------- > > Key: MRM-415 > URL: http://jira.codehaus.org/browse/MRM-415 > Project: Archiva > Issue Type: Bug > Affects Versions: 1.0-alpha-2 > Reporter: Joakim Erdfelt > Assignee: Joakim Erdfelt > > When starting up archiva on a MySQL Database. the following error is seen. > {code} > 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) > {code} -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira