continuum-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Maria Odea Ching (JIRA)" <j...@codehaus.org>
Subject [jira] Commented: (CONTINUUM-2106) Update Backup / Restore Database tool for BuildQueue table
Date Tue, 03 Mar 2009 11:10:13 GMT

    [ http://jira.codehaus.org/browse/CONTINUUM-2106?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=167703#action_167703
] 

Maria Odea Ching commented on CONTINUUM-2106:
---------------------------------------------

Hi Jan, I got the following error while importing a 1.3.1 database using a 1.3.2-SNAPSHOT
with the attached patch db migration tool:


0 [main] INFO org.apache.maven.continuum.management.DataManagementCli  - Processing Continuum
database...
[INFO] snapshot org.apache.continuum:data-management-jdo:1.3.2-SNAPSHOT: checking for updates
from sonatype.public
[WARNING] repository metadata for: 'snapshot org.apache.continuum:data-management-jdo:1.3.2-SNAPSHOT'
could not be retrieved from repository: sonatype.public due to an error: Error transferring
file
[INFO] Repository 'sonatype.public' will be blacklisted
6961 [main] INFO JPOX.JDO  - PersistenceManagerFactory - Vendor: JPOX  Version: 1.1.6
6961 [main] INFO JPOX.JDO  - PersistenceManagerFactory initialised for datastore URL=jdbc:derby:/home/deng/Projects/continuum-trunk/continuum-jetty/target/apache-continuum-1.3.2-SNAPSHOT/data/databases/continuum
driver=org.apache.derby.jdbc.EmbeddedDriver userName=sa
9464 [main] INFO JPOX.RDBMS  - ================ DatabaseAdapter ==================
9464 [main] INFO JPOX.RDBMS  - Adapter : org.jpox.store.rdbms.adapter.DerbyAdapter
9464 [main] INFO JPOX.RDBMS  - Datastore : name="Apache Derby" version="10.1.3.1" (major=10,
minor=1, revision=3)
9464 [main] INFO JPOX.RDBMS  - Driver : name="Apache Derby Embedded JDBC Driver" version="10.1.3.1"
(major=10, minor=1)
9465 [main] INFO JPOX.RDBMS  - ===================================================
9562 [main] INFO JPOX.RDBMS.Schema  - Initialising Catalog "", Schema "SA" using "None" auto-start
option
9637 [main] INFO JPOX.RDBMS.Schema  - Catalog "", Schema "SA" initialised - managing 0 classes
9680 [main] WARN JPOX.MetaData  - No manager for annotations was found in the CLASSPATH so
all annotations are ignored.
10509 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.system.Installation
[Table : INSTALLATION, InheritanceStrategy : new-table]
10561 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.system.Profile
[Table : PROFILES, InheritanceStrategy : new-table]
10562 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.project.BuildQueue
[Table : BUILDQUEUE, InheritanceStrategy : new-table]
10562 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.project.Schedule
[Table : SCHEDULE, InheritanceStrategy : new-table]
10563 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.project.BuildDefinition
[Table : BUILDDEFINITION, InheritanceStrategy : new-table]
10563 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.project.BuildDefinitionTemplate
[Table : BUILDDEFINITIONTEMPLATE, InheritanceStrategy : new-table]
10614 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Field : org.apache.maven.continuum.model.project.BuildDefinitionTemplate.buildDefinitions
[Table : BUILDDEFINITIONTEMPLATE_BUILDDEFINITIONS]
10616 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Field : org.apache.maven.continuum.model.system.Profile.environmentVariables
[Table : PROFILE_ENVIRONMENTVARIABLES]
10617 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Field : org.apache.maven.continuum.model.project.Schedule.buildQueues
[Table : SCHEDULE_BUILDQUEUES]
12336 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table BUILDDEFINITION
12381 [main] INFO JPOX.RDBMS  - Validated 2 foreign key(s) for table BUILDDEFINITION
12475 [main] INFO JPOX.RDBMS  - Validated 3 index(es) for table BUILDDEFINITION
12598 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table BUILDDEFINITIONTEMPLATE
12690 [main] INFO JPOX.RDBMS  - Validated 1 index(es) for table BUILDDEFINITIONTEMPLATE
12800 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROFILES
12835 [main] INFO JPOX.RDBMS  - Validated 2 foreign key(s) for table PROFILES
12980 [main] INFO JPOX.RDBMS  - Validated 3 index(es) for table PROFILES
13096 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table SCHEDULE
13252 [main] INFO JPOX.RDBMS  - Validated 1 index(es) for table SCHEDULE
13387 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table INSTALLATION
13506 [main] INFO JPOX.RDBMS  - Validated 1 index(es) for table INSTALLATION
13564 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table BUILDQUEUE
13637 [main] INFO JPOX.RDBMS  - Validated 1 index(es) for table BUILDQUEUE
13719 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table SCHEDULE_BUILDQUEUES
13767 [main] INFO JPOX.RDBMS  - Validated 2 foreign key(s) for table SCHEDULE_BUILDQUEUES
13825 [main] INFO JPOX.RDBMS  - Validated 3 index(es) for table SCHEDULE_BUILDQUEUES
13950 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table BUILDDEFINITIONTEMPLATE_BUILDDEFINITIONS
13985 [main] INFO JPOX.RDBMS  - Validated 2 foreign key(s) for table BUILDDEFINITIONTEMPLATE_BUILDDEFINITIONS
14083 [main] INFO JPOX.RDBMS  - Validated 3 index(es) for table BUILDDEFINITIONTEMPLATE_BUILDDEFINITIONS
14160 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROFILE_ENVIRONMENTVARIABLES
14212 [main] INFO JPOX.RDBMS  - Validated 2 foreign key(s) for table PROFILE_ENVIRONMENTVARIABLES
14283 [main] INFO JPOX.RDBMS  - Validated 3 index(es) for table PROFILE_ENVIRONMENTVARIABLES
14507 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.project.ProjectDependency
[Table : PROJECTDEPENDENCY, InheritanceStrategy : new-table]
14509 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.scm.ChangeFile
[Table : CHANGEFILE, InheritanceStrategy : new-table]
14509 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.scm.ChangeSet
[Table : CHANGESET, InheritanceStrategy : new-table]
14509 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.scm.ScmResult
[Table : SCMRESULT, InheritanceStrategy : new-table]
14509 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.project.ProjectDeveloper
[Table : PROJECTDEVELOPER, InheritanceStrategy : new-table]
14510 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.project.ProjectNotifier
[Table : PROJECTNOTIFIER, InheritanceStrategy : new-table]
14510 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.continuum.model.repository.LocalRepository
[Table : LOCALREPOSITORY, InheritanceStrategy : new-table]
14510 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.project.ProjectGroup
[Table : PROJECTGROUP, InheritanceStrategy : new-table]
14510 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.project.Project
[Table : PROJECT, InheritanceStrategy : new-table]
14511 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.project.BuildResult
[Table : BUILDRESULT, InheritanceStrategy : new-table]
14516 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Field : org.apache.maven.continuum.model.project.ProjectNotifier.configuration
[Table : PROJECTNOTIFIER_CONFIGURATION]
14527 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Field : org.apache.maven.continuum.model.project.ProjectGroup.buildDefinitions
[Table : PROJECTGROUP_BUILDDEFINITIONS]
14528 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Field : org.apache.maven.continuum.model.project.ProjectGroup.notifiers
[Table : PROJECTGROUP_NOTIFIERS]
14561 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Field : org.apache.maven.continuum.model.project.Project.buildDefinitions
[Table : PROJECT_BUILDDEFINITIONS]
14563 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Field : org.apache.maven.continuum.model.project.Project.notifiers
[Table : PROJECT_NOTIFIERS]
14725 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table CHANGEFILE
14749 [main] INFO JPOX.RDBMS  - Validated 1 foreign key(s) for table CHANGEFILE
14786 [main] INFO JPOX.RDBMS  - Validated 2 index(es) for table CHANGEFILE
14793 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROJECTNOTIFIER
14811 [main] INFO JPOX.RDBMS  - Validated 1 index(es) for table PROJECTNOTIFIER
14846 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table LOCALREPOSITORY
14855 [main] INFO JPOX.RDBMS  - Validated 1 index(es) for table LOCALREPOSITORY
14862 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table CHANGESET
14869 [main] INFO JPOX.RDBMS  - Validated 1 foreign key(s) for table CHANGESET
14876 [main] INFO JPOX.RDBMS  - Validated 2 index(es) for table CHANGESET
14915 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROJECTGROUP
14923 [main] INFO JPOX.RDBMS  - Validated 1 foreign key(s) for table PROJECTGROUP
14939 [main] INFO JPOX.RDBMS  - Validated 2 index(es) for table PROJECTGROUP
14971 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table BUILDRESULT
15014 [main] INFO JPOX.RDBMS  - Validated 3 foreign key(s) for table BUILDRESULT
15031 [main] INFO JPOX.RDBMS  - Validated 4 index(es) for table BUILDRESULT
15036 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table SCMRESULT
15077 [main] INFO JPOX.RDBMS  - Validated 1 index(es) for table SCMRESULT
15082 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROJECTDEVELOPER
15096 [main] INFO JPOX.RDBMS  - Validated 1 foreign key(s) for table PROJECTDEVELOPER
15143 [main] INFO JPOX.RDBMS  - Validated 2 index(es) for table PROJECTDEVELOPER
15161 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROJECT
15206 [main] INFO JPOX.RDBMS  - Validated 3 foreign key(s) for table PROJECT
15218 [main] INFO JPOX.RDBMS  - Validated 4 index(es) for table PROJECT
15224 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROJECTDEPENDENCY
15240 [main] INFO JPOX.RDBMS  - Validated 2 foreign key(s) for table PROJECTDEPENDENCY
15248 [main] INFO JPOX.RDBMS  - Validated 3 index(es) for table PROJECTDEPENDENCY
15256 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROJECT_BUILDDEFINITIONS
15267 [main] INFO JPOX.RDBMS  - Validated 2 foreign key(s) for table PROJECT_BUILDDEFINITIONS
15280 [main] INFO JPOX.RDBMS  - Validated 3 index(es) for table PROJECT_BUILDDEFINITIONS
15286 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROJECTGROUP_BUILDDEFINITIONS
15304 [main] INFO JPOX.RDBMS  - Validated 2 foreign key(s) for table PROJECTGROUP_BUILDDEFINITIONS
15311 [main] INFO JPOX.RDBMS  - Validated 3 index(es) for table PROJECTGROUP_BUILDDEFINITIONS
15319 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROJECT_NOTIFIERS
15334 [main] INFO JPOX.RDBMS  - Validated 2 foreign key(s) for table PROJECT_NOTIFIERS
15343 [main] INFO JPOX.RDBMS  - Validated 3 index(es) for table PROJECT_NOTIFIERS
15350 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROJECTNOTIFIER_CONFIGURATION
15357 [main] INFO JPOX.RDBMS  - Validated 1 foreign key(s) for table PROJECTNOTIFIER_CONFIGURATION
15367 [main] INFO JPOX.RDBMS  - Validated 2 index(es) for table PROJECTNOTIFIER_CONFIGURATION
15374 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROJECTGROUP_NOTIFIERS
15382 [main] INFO JPOX.RDBMS  - Validated 2 foreign key(s) for table PROJECTGROUP_NOTIFIERS
15392 [main] INFO JPOX.RDBMS  - Validated 3 index(es) for table PROJECTGROUP_NOTIFIERS
15409 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.continuum.model.release.ContinuumReleaseResult
[Table : CONTINUUMRELEASERESULT, InheritanceStrategy : new-table]
15414 [main] INFO JPOX.RDBMS  - Creating table CONTINUUMRELEASERESULT
16063 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table CONTINUUMRELEASERESULT
16078 [main] INFO JPOX.RDBMS  - Creating foreign key constraint : "CONTINUUMREL3U_FK1" in
catalog "" schema ""
16129 [main] INFO JPOX.RDBMS  - Creating foreign key constraint : "CONTINUUMREL3U_FK2" in
catalog "" schema ""
16235 [main] INFO JPOX.RDBMS  - Validated 3 index(es) for table CONTINUUMRELEASERESULT
16260 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.continuum.model.project.ProjectScmRoot
[Table : PROJECTSCMROOT, InheritanceStrategy : new-table]
16455 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table PROJECTSCMROOT
16699 [main] INFO JPOX.RDBMS  - Validated 1 foreign key(s) for table PROJECTSCMROOT
16704 [main] INFO JPOX.RDBMS  - Validated 2 index(es) for table PROJECTSCMROOT
16935 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.continuum.model.repository.AbstractPurgeConfiguration
[Table : ABSTRACTPURGECONFIGURATION, InheritanceStrategy : new-table]
16935 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.continuum.model.repository.RepositoryPurgeConfiguration
[Table : REPOSITORYPURGECONFIGURATION, InheritanceStrategy : new-table]
16997 [main] INFO JPOX.RDBMS  - Validated 2 unique key(s) for table REPOSITORYPURGECONFIGURATION
17005 [main] INFO JPOX.RDBMS  - Validated 2 foreign key(s) for table REPOSITORYPURGECONFIGURATION
17019 [main] INFO JPOX.RDBMS  - Validated 3 index(es) for table REPOSITORYPURGECONFIGURATION
17024 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table ABSTRACTPURGECONFIGURATION
17033 [main] INFO JPOX.RDBMS  - Validated 1 foreign key(s) for table ABSTRACTPURGECONFIGURATION
17041 [main] INFO JPOX.RDBMS  - Validated 2 index(es) for table ABSTRACTPURGECONFIGURATION
17127 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.continuum.model.repository.DirectoryPurgeConfiguration
[Table : DIRECTORYPURGECONFIGURATION, InheritanceStrategy : new-table]
17217 [main] INFO JPOX.RDBMS  - Validated 2 unique key(s) for table DIRECTORYPURGECONFIGURATION
17222 [main] INFO JPOX.RDBMS  - Validated 1 foreign key(s) for table DIRECTORYPURGECONFIGURATION
17226 [main] INFO JPOX.RDBMS  - Validated 2 index(es) for table DIRECTORYPURGECONFIGURATION
17357 [main] INFO JPOX.RDBMS.Schema  - Managing Persistence of Class : org.apache.maven.continuum.model.system.SystemConfiguration
[Table : SYSTEMCONFIGURATION, InheritanceStrategy : new-table]
17424 [main] INFO JPOX.RDBMS  - Validated 1 unique key(s) for table SYSTEMCONFIGURATION
17432 [main] INFO JPOX.RDBMS  - Validated 1 index(es) for table SYSTEMCONFIGURATION
Exception in thread "main" org.apache.maven.continuum.management.DataManagementException:
javax.xml.stream.XMLStreamException: ParseError at [row,col]:[673,22]
Message: Unrecognised tag: 'scmResult'
        at org.apache.maven.continuum.management.JdoDataManagementTool.restoreDatabase(JdoDataManagementTool.java:231)
        at org.apache.maven.continuum.management.DataManagementCli.processDatabase(DataManagementCli.java:270)
        at org.apache.maven.continuum.management.DataManagementCli.main(DataManagementCli.java:170)
Caused by: javax.xml.stream.XMLStreamException: ParseError at [row,col]:[673,22]
Message: Unrecognised tag: 'scmResult'
        at org.apache.maven.continuum.model.project.io.stax.ContinuumStaxReader.parseProject(ContinuumStaxReader.java:2638)
        at org.apache.maven.continuum.model.project.io.stax.ContinuumStaxReader.parseProjectGroup(ContinuumStaxReader.java:2846)
        at org.apache.maven.continuum.model.project.io.stax.ContinuumStaxReader.parseContinuumDatabase(ContinuumStaxReader.java:1354)
        at org.apache.maven.continuum.model.project.io.stax.ContinuumStaxReader.read(ContinuumStaxReader.java:3713)
        at org.apache.maven.continuum.model.project.io.stax.ContinuumStaxReader.read(ContinuumStaxReader.java:3729)
        at org.apache.maven.continuum.management.JdoDataManagementTool.restoreDatabase(JdoDataManagementTool.java:227)
        ... 2 more



Does the error with the BuildQueue you've described above comes before or after the error
I got?

> Update Backup / Restore Database tool for BuildQueue table
> ----------------------------------------------------------
>
>                 Key: CONTINUUM-2106
>                 URL: http://jira.codehaus.org/browse/CONTINUUM-2106
>             Project: Continuum
>          Issue Type: Bug
>          Components: Data Management
>            Reporter: jan ancajas
>            Assignee: Maria Odea Ching
>         Attachments: CONTINUUM-2106.patch
>
>
> backing up and restoring continuum database using 1.3.2-SNAPSHOT  causes this: 
> javax.jdo.JDOUserException: Field org.apache.maven.continuum.model.project.BuildQueue.name
is null, but is mandatory as its described in the jdo metadata
> at org.jpox.store.rdbms.fieldmanager.ParameterSetter.storeStringField(ParameterSetter.java:120)
> at org.jpox.state.StateManagerImpl.providedStringField(StateManagerImpl.java:2757)
> at org.apache.maven.continuum.model.project.BuildQueue.jdoProvideField(BuildQueue.java)
> at org.apache.maven.continuum.model.project.BuildQueue.jdoProvideFields(BuildQueue.java)
> at org.jpox.state.StateManagerImpl.provideFields(StateManagerImpl.java:3115)
> at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:252)
> at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2519)
> at org.jpox.store.StoreManager.insert(StoreManager.java:938)
> at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3667)
> at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3646)
> at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1206)
> at org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1259)
> at org.jpox.store.rdbms.scostore.ElementContainerStore.validateElementForWriting(ElementContainerStore.java:397)
> at org.jpox.store.rdbms.scostore.AbstractListStore.internalAdd(AbstractListStore.java:1154)
> at org.jpox.store.rdbms.scostore.AbstractListStore.addAll(AbstractListStore.java:387)
> at org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.java:209)
> at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:464)
> at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2519)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message