Continuum
  1. Continuum
  2. CONTINUUM-2106

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

          Activity

          Hide
          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
          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
          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
          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
          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
          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
          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
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: