Continuum

Update Backup / Restore Database tool for BuildQueue table

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: None
  • Fix Version/s: 1.3.3 (Beta)
  • Component/s: Data Management
  • Labels:
    None
  • Complexity:
    Intermediate
  • Number of attachments :
    1

Description

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)

Issue Links

is depended upon by

New Feature - A new feature of the product, which has yet to be developed. CONTINUUM-2098 Provide a Web UI for database backup and restore

  • Major - Major loss of function.
  • Open - The issue is open and ready for the assignee to start work on it.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
jan ancajas added a comment -

attached patch.

I updated BuildQueue - Schedule tables relationship during restore.

Show
jan ancajas added a comment - attached patch. I updated BuildQueue - Schedule tables relationship during restore.
Hide
Permalink
Maria Odea Ching added a comment -

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?

Show
Maria Odea Ching added a comment - 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?
Hide
Permalink
jan ancajas added a comment -

I haven't tried the use case of importing from a 1.3.1 Database. Only importing from 1.3.2-SNAPSHOT. I'll investigate more.

Show
jan ancajas added a comment - I haven't tried the use case of importing from a 1.3.1 Database. Only importing from 1.3.2-SNAPSHOT. I'll investigate more.
Hide
Permalink
Maria Odea Ching added a comment -

I think I'll file a separate jira for the error I encountered with importing a 1.3.1 database. I'll try exporting and importing a 1.3.2-SNAPSHOT db using a patched 1.3.2-SNAPSHOT db migration tool..

Show
Maria Odea Ching added a comment - I think I'll file a separate jira for the error I encountered with importing a 1.3.1 database. I'll try exporting and importing a 1.3.2-SNAPSHOT db using a patched 1.3.2-SNAPSHOT db migration tool..
Hide
Permalink
Maria Catherine Tan added a comment -

Fixed in r75039. Thanks Jan!

Slight Modification

  • update backup/restore test
Show
Maria Catherine Tan added a comment - Fixed in r75039. Thanks Jan! Slight Modification update backup/restore test
Hide
Permalink
Maria Catherine Tan added a comment -

The error Deng encountered is because the "ScmResult" field in the Project was removed since 1.3.2

Show
Maria Catherine Tan added a comment - The error Deng encountered is because the "ScmResult" field in the Project was removed since 1.3.2
Hide
Permalink
Maria Catherine Tan added a comment -

Deng,

I created an issue for your error CONTINUUM-2163

Show
Maria Catherine Tan added a comment - Deng, I created an issue for your error CONTINUUM-2163

People

  • Assignee:
    Maria Catherine Tan
    Reporter:
    jan ancajas
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: