You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@archiva.apache.org by "Maria Odea Ching (JIRA)" <ji...@codehaus.org> on 2009/05/20 12:41:45 UTC
[jira] Commented: (MRM-1157) Update from 1.1.3 to 1.2 fails with
create table error
[ http://jira.codehaus.org/browse/MRM-1157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=177298#action_177298 ]
Maria Odea Ching commented on MRM-1157:
---------------------------------------
This was caused by the changes in MRM-836..
> Update from 1.1.3 to 1.2 fails with create table error
> ------------------------------------------------------
>
> Key: MRM-1157
> URL: http://jira.codehaus.org/browse/MRM-1157
> Project: Archiva
> Issue Type: Bug
> Affects Versions: 1.2
> Environment: CentOS Linux 5.2, JDK 1.6.0_07 64-Bit, MySQL 5.0.67, Tomcat 6.0.18
> Reporter: Dennis Kieselhorst
> Assignee: Maria Odea Ching
> Priority: Blocker
> Fix For: 1.2.1
>
>
> After updating from 1.1.3 to 1.2 the following exception is thrown contiously:
> [pool-1-thread-1] ERROR JPOX.RDBMS - An exception was thrown while adding/validating class(es) : Can't create table './archiva/#sql-474f_847bb9.frm' (errno: 150)
> java.sql.SQLException: Can't create table './archiva/#sql-474f_847bb9.frm' (errno: 150)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
> at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734)
> at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
> at org.jpox.store.rdbms.table.TableImpl.validateForeignKeys(TableImpl.java:463)
> at org.jpox.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:388)
> at org.jpox.store.rdbms.table.ClassTable.validateConstraints(ClassTable.java:2875)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3123)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3326)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2567)
> at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2419)
> at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:824)
> at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:838)
> at org.jpox.AbstractPersistenceManager.newObjectIdInstance(AbstractPersistenceManager.java:2393)
> at org.apache.maven.archiva.database.jdo.JdoAccess.getObjectById(JdoAccess.java:426)
> at org.apache.maven.archiva.database.jdo.JdoProjectModelDAO.getProjectModel(JdoProjectModelDAO.java:73)
> at org.apache.maven.archiva.consumers.database.ProjectModelToDatabaseConsumer.getProjectModelFromDatabase(ProjectModelToDatabaseConsumer.java:203)
> at org.apache.maven.archiva.consumers.database.ProjectModelToDatabaseConsumer.processArchivaArtifact(ProjectModelToDatabaseConsumer.java:133)
> at org.apache.maven.archiva.database.updater.ProcessArchivaArtifactClosure.execute(ProcessArchivaArtifactClosure.java:48)
> at org.apache.commons.collections.CollectionUtils.forAllDo(CollectionUtils.java:388)
> at org.apache.maven.archiva.database.updater.JdoDatabaseUpdater.updateUnprocessed(JdoDatabaseUpdater.java:150)
> at org.apache.maven.archiva.database.updater.JdoDatabaseUpdater.updateAllUnprocessed(JdoDatabaseUpdater.java:87)
> at org.apache.maven.archiva.scheduled.executors.ArchivaDatabaseUpdateTaskExecutor.executeTask(ArchivaDatabaseUpdateTaskExecutor.java:69)
> at org.codehaus.plexus.taskqueue.execution.ThreadedTaskQueueExecutor$ExecutorRunnable$1.run(ThreadedTaskQueueExecutor.java:116)
> at edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:442)
> at edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
> at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:987)
> at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:528)
> at java.lang.Thread.run(Thread.java:619)
> Caused by: javax.jdo.JDODataStoreException: Error(s) were found while auto-creating/validating the datastore for classes. The errors are printed in the log, and are attached to this exception.
> NestedThrowables:
> java.sql.SQLException: Can't create table './archiva/#sql-474f_847bba.frm' (errno: 150)
> java.sql.SQLException: Can't create table './archiva/#sql-474f_847bba.frm' (errno: 150)
> java.sql.SQLException: Can't create table './archiva/#sql-474f_847bba.frm' (errno: 150)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.verifyErrors(RDBMSManager.java:3285)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3335)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2567)
> at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2419)
> at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:824)
> at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:838)
> at org.jpox.AbstractPersistenceManager.newObjectIdInstance(AbstractPersistenceManager.java:2393)
> at org.apache.maven.archiva.database.jdo.JdoAccess.getObjectById(JdoAccess.java:426)
> ... 19 more
> Caused by: java.sql.SQLException: Can't create table './archiva/#sql-474f_847bba.frm' (errno: 150)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
> at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734)
> at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
> at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
> at org.jpox.store.rdbms.table.TableImpl.validateForeignKeys(TableImpl.java:463)
> at org.jpox.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:388)
> at org.jpox.store.rdbms.table.ClassTable.validateConstraints(ClassTable.java:2875)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3123)
> at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3326)
> ... 25 more
> Archiva is successful proxying artifacts but release deployments fail with "Error deploying artifact: Read timed out".
--
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