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 398E0EC72 for ; Tue, 20 Nov 2012 13:27:39 +0000 (UTC) Received: (qmail 64422 invoked by uid 500); 20 Nov 2012 13:27:39 -0000 Delivered-To: apmail-continuum-issues-archive@continuum.apache.org Received: (qmail 64385 invoked by uid 500); 20 Nov 2012 13:27:39 -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 64356 invoked by uid 99); 20 Nov 2012 13:27:38 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Nov 2012 13:27:38 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.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 13:27:34 +0000 Received: from codehaus01 (localhost.localdomain [127.0.0.1]) by codehaus01.managed.contegix.com (Postfix) with ESMTP id 78BE1B06B6 for ; Tue, 20 Nov 2012 07:27:13 -0600 (CST) Date: Tue, 20 Nov 2012 07:27:13 -0600 (CST) From: "Brett Porter (JIRA)" To: issues@continuum.apache.org Message-ID: <1953610757.11723.1353418033495.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=313993#comment-313993 ] Brett Porter commented on CONTINUUM-2671: ----------------------------------------- sorry for missing the comments. The errors listed in the earlier comments are typical on first use, but don't affect the subsequent database. Did you not get the operation you expected after starting up the new version? > 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