continuum-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brett Porter (JIRA)" <j...@codehaus.org>
Subject [jira] (CONTINUUM-2671) Error while importing db to v1.3.8 from v1.2.2
Date Wed, 21 Nov 2012 05:20:13 GMT

     [ https://jira.codehaus.org/browse/CONTINUUM-2671?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Brett Porter closed CONTINUUM-2671.
-----------------------------------

    Resolution: Duplicate
      Assignee: Brett Porter
    
> 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
>            Assignee: Brett Porter
>
> 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

        

Mime
View raw message