[MRM-1157] Update from 1.1.3 to 1.2 fails with create table error

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.2
• Fix Version/s: 1.2.1
• Environment: CentOS Linux 5.2, JDK 1.6.0_07 64-Bit, MySQL 5.0.67, Tomcat 6.0.18
• Assignee: Maria Odea B. Ching
• Reporter: Dennis Kieselhorst
• Created: 27/Mar/09 07:51
• Updated: 05/Jun/09 06:50
• Resolved: 24/May/09 06:00

Description

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".

Issue Links

• relates to: MRM-1176 SQLSyntaxErrorException is thrown when browsing for artifacts after upgrading from 1.3.1 to 1.2