Ravi created CONTINUUM-2671:
-------------------------------
Summary: 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
