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