[
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
