You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@continuum.apache.org by "Ravi (JIRA)" <ji...@codehaus.org> on 2012/03/01 03:51:02 UTC
[jira] (CONTINUUM-2671) Error while importing db to v1.3.8 from
v1.2.2
[ https://jira.codehaus.org/browse/CONTINUUM-2671?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=293078#comment-293078 ]
Ravi commented on CONTINUUM-2671:
---------------------------------
Brett,
Do you have any other work around for this issue ?
I want to keep the data from previous version for reporting purpose so, starting with a clean database is not an option.
> Error while importing db to v1.3.8 from v1.2.2
> ----------------------------------------------
>
> Key: CONTINUUM-2671
> URL: https://jira.codehaus.org/browse/CONTINUUM-2671
> Project: Continuum
> Issue Type: Bug
> Components: Data Management, Database
> Affects Versions: 1.3.8
> Environment: Linux 2.6.18-92.el5
> Reporter: Ravi
>
> http://continuum.apache.org/docs/1.3.8/installation/upgrade.html
> I m following the above guidelines to upgrade our current continuum version(v1.2.2) to the latest stable version (v1.3.8).
> I was able to successfully export the db from previous version but facing issues while importing the same into the new version(v.1.3.8).
> It looks like that few columns are dropped in the new schema which is causing the issue - please let me know if we have a fix for this or is there any other workaround.
> Below is the stack trace of the error that I see:
> -------------------------------------------------------------------------------------------------------------------------------
> [user@buildmachine bin]$ java -Xmx512m -jar data-management-cli-1.3.2-app.jar -buildsJdbcUrl jdbc:derby:/usr/local/apache-continuum-1.3.8/data/databases/continuum -mode IMPORT -directory backups
> 0 [main] INFO org.apache.maven.continuum.management.DataManagementCli - Processing Continuum database...
> 4179 [main] INFO JPOX.JDO - PersistenceManagerFactory - Vendor: JPOX Version: 1.1.6
> 4179 [main] INFO JPOX.JDO - PersistenceManagerFactory initialised for datastore URL=jdbc:derby:/usr/local/apache-continuum-1.3.8/data/databases/continuum driver=org.apache.derby.jdbc.EmbeddedDriver userName=sa
> 4768 [main] INFO JPOX.RDBMS - ================ DatabaseAdapter ==================
> 4768 [main] INFO JPOX.RDBMS - Adapter : org.jpox.store.rdbms.adapter.DerbyAdapter
> 4768 [main] INFO JPOX.RDBMS - Datastore : name="Apache Derby" version="10.1.3.1" (major=10, minor=1, revision=3)
> 4768 [main] INFO JPOX.RDBMS - Driver : name="Apache Derby Embedded JDBC Driver" version="10.1.3.1" (major=10, minor=1)
> 4768 [main] INFO JPOX.RDBMS - ===================================================
> 4803 [main] INFO JPOX.RDBMS.Schema - Initialising Catalog "", Schema "SA" using "None" auto-start option
> 4887 [main] INFO JPOX.RDBMS.Schema - Catalog "", Schema "SA" initialised - managing 0 classes
> 4917 [main] WARN JPOX.MetaData - No manager for annotations was found in the CLASSPATH so all annotations are ignored.
> 5372 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.system.Installation [Table : INSTALLATION, InheritanceStrategy : new-table]
> 5388 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.system.Profile [Table : PROFILES, InheritanceStrategy : new-table]
> 5389 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.project.BuildQueue [Table : BUILDQUEUE, InheritanceStrategy : new-table]
> 5389 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.project.Schedule [Table : SCHEDULE, InheritanceStrategy : new-table]
> 5389 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.project.BuildDefinition [Table : BUILDDEFINITION, InheritanceStrategy : new-table]
> 5390 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.project.BuildDefinitionTemplate [Table : BUILDDEFINITIONTEMPLATE, InheritanceStrategy : new-table]
> 5395 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Field : org.apache.maven.continuum.model.project.BuildDefinitionTemplate.buildDefinitions [Table : BUILDDEFINITIONTEMPLATE_BUILDDEFINITIONS]
> 5404 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Field : org.apache.maven.continuum.model.project.Schedule.buildQueues [Table : SCHEDULE_BUILDQUEUES]
> 5406 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Field : org.apache.maven.continuum.model.system.Profile.environmentVariables [Table : PROFILE_ENVIRONMENTVARIABLES]
> 5953 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table BUILDDEFINITIONTEMPLATE
> 5985 [main] INFO JPOX.RDBMS - Validated 1 index(es) for table BUILDDEFINITIONTEMPLATE
> 5992 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table BUILDQUEUE
> 6005 [main] INFO JPOX.RDBMS - Validated 1 index(es) for table BUILDQUEUE
> 6016 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table BUILDDEFINITION
> 6039 [main] INFO JPOX.RDBMS - Validated 2 foreign key(s) for table BUILDDEFINITION
> 6051 [main] INFO JPOX.RDBMS - Validated 3 index(es) for table BUILDDEFINITION
> 6061 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table SCHEDULE
> 6074 [main] INFO JPOX.RDBMS - Validated 1 index(es) for table SCHEDULE
> 6083 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table PROFILES
> 6095 [main] INFO JPOX.RDBMS - Validated 2 foreign key(s) for table PROFILES
> 6105 [main] INFO JPOX.RDBMS - Validated 3 index(es) for table PROFILES
> 6112 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table INSTALLATION
> 6123 [main] INFO JPOX.RDBMS - Validated 1 index(es) for table INSTALLATION
> 6132 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table BUILDDEFINITIONTEMPLATE_BUILDDEFINITIONS
> 6147 [main] INFO JPOX.RDBMS - Validated 2 foreign key(s) for table BUILDDEFINITIONTEMPLATE_BUILDDEFINITIONS
> 6155 [main] INFO JPOX.RDBMS - Validated 3 index(es) for table BUILDDEFINITIONTEMPLATE_BUILDDEFINITIONS
> 6162 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table PROFILE_ENVIRONMENTVARIABLES
> 6179 [main] INFO JPOX.RDBMS - Validated 2 foreign key(s) for table PROFILE_ENVIRONMENTVARIABLES
> 6189 [main] INFO JPOX.RDBMS - Validated 3 index(es) for table PROFILE_ENVIRONMENTVARIABLES
> 6196 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table SCHEDULE_BUILDQUEUES
> 6208 [main] INFO JPOX.RDBMS - Validated 2 foreign key(s) for table SCHEDULE_BUILDQUEUES
> 6215 [main] INFO JPOX.RDBMS - Validated 3 index(es) for table SCHEDULE_BUILDQUEUES
> Exception in thread "main" javax.jdo.JDODataStoreException: Error executing JDOQL query "SELECT 'org.apache.maven.continuum.model.project.BuildDefinitionTemplate' AS JPOXMETADATA,THIS.CONTINUUM_DEFAULT,THIS.ID,THIS.MODEL_ENCODING,THIS."NAME",THIS.BUILDDEFINITION_TEMPLATE_TYPE FROM BUILDDEFINITIONTEMPLATE THIS" : Column 'THIS.MODEL_ENCODING' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'THIS.MODEL_ENCODING' is not a column in the target table..
> 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:82)
> at org.apache.maven.continuum.management.JdoDataManagementTool.eraseDatabase(JdoDataManagementTool.java:223)
> at org.apache.maven.continuum.management.DataManagementCli.processDatabase(DataManagementCli.java:269)
> at org.apache.maven.continuum.management.DataManagementCli.main(DataManagementCli.java:170)
> NestedThrowablesStackTrace:
> ERROR 42X04: Column 'THIS.MODEL_ENCODING' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'THIS.MODEL_ENCODING' is not a column in the target table.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
> at org.apache.derby.impl.sql.compile.ColumnReference.bindExpression(Unknown Source)
> at org.apache.derby.impl.sql.compile.ResultColumn.bindExpression(Unknown Source)
> at org.apache.derby.impl.sql.compile.ResultColumnList.bindExpressions(Unknown Source)
> at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
> at org.apache.derby.impl.sql.compile.ReadCursorNode.bind(Unknown Source)
> at org.apache.derby.impl.sql.compile.CursorNode.bind(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
> at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
> at org.jpox.store.rdbms.RDBMSManager.getStatement(RDBMSManager.java:523)
> at org.jpox.store.rdbms.query.StatementText.prepareStatement(StatementText.java:215)
> at org.jpox.store.rdbms.query.RDBMSQuery.getStatement(RDBMSQuery.java:131)
> at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:582)
> 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:82)
> at org.apache.maven.continuum.management.JdoDataManagementTool.eraseDatabase(JdoDataManagementTool.java:223)
> at org.apache.maven.continuum.management.DataManagementCli.processDatabase(DataManagementCli.java:269)
> at org.apache.maven.continuum.management.DataManagementCli.main(DataManagementCli.java:170)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://jira.codehaus.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira