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 Tue, 20 Nov 2012 13:27:13 GMT

    [ 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

        

Mime
View raw message