Return-Path: X-Original-To: apmail-continuum-issues-archive@www.apache.org Delivered-To: apmail-continuum-issues-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 2D672E37B for ; Tue, 20 Nov 2012 19:44:43 +0000 (UTC) Received: (qmail 92741 invoked by uid 500); 20 Nov 2012 19:44:43 -0000 Delivered-To: apmail-continuum-issues-archive@continuum.apache.org Received: (qmail 92704 invoked by uid 500); 20 Nov 2012 19:44:43 -0000 Mailing-List: contact issues-help@continuum.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@continuum.apache.org Delivered-To: mailing list issues@continuum.apache.org Received: (qmail 92646 invoked by uid 99); 20 Nov 2012 19:44:40 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Nov 2012 19:44:40 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [63.246.24.159] (HELO codehaus01.managed.contegix.com) (63.246.24.159) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Nov 2012 19:44:34 +0000 Received: from codehaus01 (localhost.localdomain [127.0.0.1]) by codehaus01.managed.contegix.com (Postfix) with ESMTP id 63365B0640 for ; Tue, 20 Nov 2012 13:44:13 -0600 (CST) Date: Tue, 20 Nov 2012 13:44:13 -0600 (CST) From: "Ravi (JIRA)" To: issues@continuum.apache.org Message-ID: <820388499.11910.1353440653419.JavaMail.j2ee-jira@codehaus01.managed.contegix.com> In-Reply-To: <1951389744.12960.1325729403097.JavaMail.j2ee-jira@codehaus01.managed.contegix.com> Subject: [jira] (CONTINUUM-2671) Error while importing db to v1.3.8 from v1.2.2 MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 22cf62d5d84cf5bea94eb3b65e0ebd09 X-Virus-Checked: Checked by ClamAV on apache.org [ https://jira.codehaus.org/browse/CONTINUUM-2671?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=314027#comment-314027 ] Ravi commented on CONTINUUM-2671: --------------------------------- No problem.. The new version starts up ok but no data got migrated from the previous version - so, I have to recreate all the projects that I had on my earlier version of continuum instance. > 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.(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.(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