You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@continuum.apache.org by "Maria Odea Ching (JIRA)" <ji...@codehaus.org> on 2009/03/03 12:10:13 UTC
[jira] Commented: (CONTINUUM-2106) Update Backup / Restore Database
tool for BuildQueue table
[ 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