[CONTINUUM-2408] Unable to import data that includes installations

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.3.4 (Beta)
• Component/s: Data Management
• Labels: backlog-to-cleanup
• Assignee: Unassigned
• Reporter: Luca Di Stefano
• Created: 18/Nov/09 07:47
• Updated: 20/Nov/12 01:09

Description

0 [main] INFO org.apache.maven.continuum.management.DataManagementCli - Processing Continuum database...
63124 [main] WARN JPOX.MetaData - No manager for annotations was found in the CLASSPATH so all annotations are ignored.
Exception in thread "main" javax.jdo.JDODataStoreException: Error executing JDOQL query "SELECT 'org.apache.maven.continuum.model.project.BuildResult' AS JPOXMETADATA,`THIS`.`BUILD_DEFINITION_ID_OID`,`THIS`.`BUILD_NUMBER`,`THIS`.`BUILD_URL`,`THIS`.`END_TIME`,`THIS`.`ERROR`,`THIS`.`EXIT_CODE`,`THIS`.`ID`,`THIS`.`LAST_CHANGED_DATE`,`THIS`.`MODEL_ENCODING`,`THIS`.`PROJECT_ID_OID`,`THIS`.`START_TIME`,`THIS`.`RESULTSTATE`,`THIS`.`SUCCESS`,`THIS`.`RESULTTRIGGER` FROM `BUILDRESULT` `THIS`" : Unknown column 'THIS.BUILD_URL' in 'field list'.
at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:636)
at org.jpox.store.rdbms.query.JDOQLQuery.performDeletePersistentAll(JDOQLQuery.java:659)
at org.jpox.store.query.Query.deletePersistentAll(Query.java:1120)
at org.jpox.store.query.Query.deletePersistentAll(Query.java:1075)
at org.jpox.store.query.Query.deletePersistentAll(Query.java:1049)
at org.codehaus.plexus.jdo.PlexusJdoUtils.removeAll(PlexusJdoUtils.java:444)
at org.apache.continuum.dao.DaoUtilsImpl.eraseDatabase(DaoUtilsImpl.java:85)
at org.apache.maven.continuum.management.JdoDataManagementTool.eraseDatabase(JdoDataManagementTool.java:232)
at org.apache.maven.continuum.management.DataManagementCli.processDatabase(DataManagementCli.java:287)
at org.apache.maven.continuum.management.DataManagementCli.main(DataManagementCli.java:180)
NestedThrowablesStackTrace:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'THIS.BUILD_URL' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
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:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
at org.jpox.store.rdbms.RDBMSManager.executeStatementQuery(RDBMSManager.java:640)
at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:594)
at org.jpox.store.rdbms.query.JDOQLQuery.performDeletePersistentAll(JDOQLQuery.java:659)
at org.jpox.store.query.Query.deletePersistentAll(Query.java:1120)
at org.jpox.store.query.Query.deletePersistentAll(Query.java:1075)
at org.jpox.store.query.Query.deletePersistentAll(Query.java:1049)
at org.codehaus.plexus.jdo.PlexusJdoUtils.removeAll(PlexusJdoUtils.java:444)
at org.apache.continuum.dao.DaoUtilsImpl.eraseDatabase(DaoUtilsImpl.java:85)
at org.apache.maven.continuum.management.JdoDataManagementTool.eraseDatabase(JdoDataManagementTool.java:232)
at org.apache.maven.continuum.management.DataManagementCli.processDatabase(DataManagementCli.java:287)
at org.apache.maven.continuum.management.DataManagementCli.main(DataManagementCli.java:180)

the target db belongs to 1.2.3 version....

Issue Links

• is related to: CONTINUUM-2100 Unable to import data that includes installations