Issue Details (XML | Word | Printable)

Key: CONTINUUM-1912
Type: Bug Bug
Status: Closed Closed
Resolution: Duplicate
Priority: Major Major
Assignee: Wendy Smoak
Reporter: Maria Catherine Tan
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Continuum

Unable to import data to new version

Created: 01/Oct/08 06:49 PM   Updated: 11/Apr/09 12:15 AM   Resolved: 11/Apr/09 12:15 AM
Component/s: None
Affects Version/s: 1.2, 1.3.2 (Beta)
Fix Version/s: None

Time Tracking:
Not Specified

Issue Links:
Duplicate
 

Complexity: Intermediate


 Description  « Hide

Data containing environment variables causes this error:

javax.jdo.JDODataStoreException: Insert request failed: INSERT INTO INSTALLATION (VAR_VALUE,INSTALLATIONTYPE,VAR_NAME,"NAME",MODEL_ENCODING,INSTALLATION_ID) VALUES (?,?,?,?,?,?) NestedThrowables: SQL Exception: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'INSTALLATION_PK' defined on 'INSTALLATION'.

Sort Order: Ascending order - Click to sort in descending order
[ Permalink | « Hide ]
Wendy Smoak added a comment - 20/Feb/09 05:13 PM

Is this still a problem in 1.2.3 or 1.3.1 ?


[ Permalink | « Hide ]
Wendy Smoak added a comment - 10/Apr/09 09:56 PM

I get the same error trying to import the data from http://vmbuild.apache.org/continuum (running 1.2, exported with data-management-cli 1.2.3.1) into a fresh install of 1.3.2.

$ java -Xmx512m -jar ~/Downloads/data-management-cli-1.3.2-app.jar -buildsJdbcUrl jdbc:derby:/tmp/apache-continuum-1.3.2/data/databases/continuum -mode IMPORT -directory ~/vmbuild-backups-20090410

0 [main] INFO org.apache.maven.continuum.management.DataManagementCli - Processing Continuum database...
34045 [main] INFO JPOX.JDO - PersistenceManagerFactory - Vendor: JPOX Version: 1.1.6
34046 [main] INFO JPOX.JDO - PersistenceManagerFactory initialised for datastore URL=jdbc:derby:/tmp/apache-continuum-1.3.2/data/databases/continuum driver=org.apache.derby.jdbc.EmbeddedDriver userName=sa
35795 [main] INFO JPOX.RDBMS - ================ DatabaseAdapter ==================
35795 [main] INFO JPOX.RDBMS - Adapter : org.jpox.store.rdbms.adapter.DerbyAdapter
35796 [main] INFO JPOX.RDBMS - Datastore : name="Apache Derby" version="10.1.3.1" (major=10, minor=1, revision=3)
35796 [main] INFO JPOX.RDBMS - Driver : name="Apache Derby Embedded JDBC Driver" version="10.1.3.1" (major=10, minor=1)
35796 [main] INFO JPOX.RDBMS - ===================================================
35900 [main] INFO JPOX.RDBMS.Schema - Initialising Catalog "", Schema "SA" using "None" auto-start option
35989 [main] INFO JPOX.RDBMS.Schema - Catalog "", Schema "SA" initialised - managing 0 classes
36061 [main] WARN JPOX.MetaData - No manager for annotations was found in the CLASSPATH so all annotations are ignored.
36577 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.system.Installation [Table : INSTALLATION, InheritanceStrategy : new-table]
36599 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.system.Profile [Table : PROFILES, InheritanceStrategy : new-table]
36599 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.project.BuildQueue [Table : BUILDQUEUE, InheritanceStrategy : new-table]
36600 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.project.Schedule [Table : SCHEDULE, InheritanceStrategy : new-table]
36600 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.project.BuildDefinition [Table : BUILDDEFINITION, InheritanceStrategy : new-table]
36600 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.project.BuildDefinitionTemplate [Table : BUILDDEFINITIONTEMPLATE, InheritanceStrategy : new-table]
36607 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Field : org.apache.maven.continuum.model.project.BuildDefinitionTemplate.buildDefinitions [Table : BUILDDEFINITIONTEMPLATE_BUILDDEFINITIONS]
36620 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Field : org.apache.maven.continuum.model.project.Schedule.buildQueues [Table : SCHEDULE_BUILDQUEUES]
36623 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Field : org.apache.maven.continuum.model.system.Profile.environmentVariables [Table : PROFILE_ENVIRONMENTVARIABLES]
37893 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table BUILDDEFINITIONTEMPLATE
38051 [main] INFO JPOX.RDBMS - Validated 1 index(es) for table BUILDDEFINITIONTEMPLATE
38098 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table BUILDQUEUE
38374 [main] INFO JPOX.RDBMS - Validated 1 index(es) for table BUILDQUEUE
38523 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table BUILDDEFINITION
38626 [main] INFO JPOX.RDBMS - Validated 2 foreign key(s) for table BUILDDEFINITION
38679 [main] INFO JPOX.RDBMS - Validated 3 index(es) for table BUILDDEFINITION
38726 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table SCHEDULE
38871 [main] INFO JPOX.RDBMS - Validated 1 index(es) for table SCHEDULE
38926 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table PROFILES
38945 [main] INFO JPOX.RDBMS - Validated 2 foreign key(s) for table PROFILES
38996 [main] INFO JPOX.RDBMS - Validated 3 index(es) for table PROFILES
39043 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table INSTALLATION
39116 [main] INFO JPOX.RDBMS - Validated 1 index(es) for table INSTALLATION
39170 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table SCHEDULE_BUILDQUEUES
39196 [main] INFO JPOX.RDBMS - Validated 2 foreign key(s) for table SCHEDULE_BUILDQUEUES
39271 [main] INFO JPOX.RDBMS - Validated 3 index(es) for table SCHEDULE_BUILDQUEUES
39328 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table PROFILE_ENVIRONMENTVARIABLES
39355 [main] INFO JPOX.RDBMS - Validated 2 foreign key(s) for table PROFILE_ENVIRONMENTVARIABLES
39422 [main] INFO JPOX.RDBMS - Validated 3 index(es) for table PROFILE_ENVIRONMENTVARIABLES
39475 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table BUILDDEFINITIONTEMPLATE_BUILDDEFINITIONS
39493 [main] INFO JPOX.RDBMS - Validated 2 foreign key(s) for table BUILDDEFINITIONTEMPLATE_BUILDDEFINITIONS
39560 [main] INFO JPOX.RDBMS - Validated 3 index(es) for table BUILDDEFINITIONTEMPLATE_BUILDDEFINITIONS
39761 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.project.ProjectDependency [Table : PROJECTDEPENDENCY, InheritanceStrategy : new-table]
39768 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.scm.ChangeFile [Table : CHANGEFILE, InheritanceStrategy : new-table]
39769 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.scm.ChangeSet [Table : CHANGESET, InheritanceStrategy : new-table]
39769 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.scm.ScmResult [Table : SCMRESULT, InheritanceStrategy : new-table]
39769 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.project.ProjectDeveloper [Table : PROJECTDEVELOPER, InheritanceStrategy : new-table]
39770 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.project.ProjectNotifier [Table : PROJECTNOTIFIER, InheritanceStrategy : new-table]
39770 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.continuum.model.repository.LocalRepository [Table : LOCALREPOSITORY, InheritanceStrategy : new-table]
39771 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.project.ProjectGroup [Table : PROJECTGROUP, InheritanceStrategy : new-table]
39771 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.project.Project [Table : PROJECT, InheritanceStrategy : new-table]
39771 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.project.BuildResult [Table : BUILDRESULT, InheritanceStrategy : new-table]
39776 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Field : org.apache.maven.continuum.model.project.ProjectNotifier.configuration [Table : PROJECTNOTIFIER_CONFIGURATION]
39779 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Field : org.apache.maven.continuum.model.project.Project.buildDefinitions [Table : PROJECT_BUILDDEFINITIONS]
39780 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Field : org.apache.maven.continuum.model.project.Project.notifiers [Table : PROJECT_NOTIFIERS]
39785 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Field : org.apache.maven.continuum.model.project.ProjectGroup.buildDefinitions [Table : PROJECTGROUP_BUILDDEFINITIONS]
39786 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Field : org.apache.maven.continuum.model.project.ProjectGroup.notifiers [Table : PROJECTGROUP_NOTIFIERS]
40055 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table PROJECTNOTIFIER
40077 [main] INFO JPOX.RDBMS - Validated 1 index(es) for table PROJECTNOTIFIER
40083 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table CHANGESET
40095 [main] INFO JPOX.RDBMS - Validated 1 foreign key(s) for table CHANGESET
40101 [main] INFO JPOX.RDBMS - Validated 2 index(es) for table CHANGESET
40108 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table LOCALREPOSITORY
40119 [main] INFO JPOX.RDBMS - Validated 1 index(es) for table LOCALREPOSITORY
40126 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table CHANGEFILE
40131 [main] INFO JPOX.RDBMS - Validated 1 foreign key(s) for table CHANGEFILE
40144 [main] INFO JPOX.RDBMS - Validated 2 index(es) for table CHANGEFILE
40156 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table PROJECT
40172 [main] INFO JPOX.RDBMS - Validated 3 foreign key(s) for table PROJECT
40187 [main] INFO JPOX.RDBMS - Validated 4 index(es) for table PROJECT
40194 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table PROJECTDEVELOPER
40200 [main] INFO JPOX.RDBMS - Validated 1 foreign key(s) for table PROJECTDEVELOPER
40209 [main] INFO JPOX.RDBMS - Validated 2 index(es) for table PROJECTDEVELOPER
40218 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table PROJECTDEPENDENCY
40233 [main] INFO JPOX.RDBMS - Validated 2 foreign key(s) for table PROJECTDEPENDENCY
40239 [main] INFO JPOX.RDBMS - Validated 3 index(es) for table PROJECTDEPENDENCY
40245 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table BUILDRESULT
40255 [main] INFO JPOX.RDBMS - Validated 3 foreign key(s) for table BUILDRESULT
40299 [main] INFO JPOX.RDBMS - Validated 4 index(es) for table BUILDRESULT
40305 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table PROJECTGROUP
40316 [main] INFO JPOX.RDBMS - Validated 1 foreign key(s) for table PROJECTGROUP
40323 [main] INFO JPOX.RDBMS - Validated 2 index(es) for table PROJECTGROUP
40342 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table SCMRESULT
40364 [main] INFO JPOX.RDBMS - Validated 1 index(es) for table SCMRESULT
40393 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table PROJECTGROUP_NOTIFIERS
40461 [main] INFO JPOX.RDBMS - Validated 2 foreign key(s) for table PROJECTGROUP_NOTIFIERS
40466 [main] INFO JPOX.RDBMS - Validated 3 index(es) for table PROJECTGROUP_NOTIFIERS
40470 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table PROJECTNOTIFIER_CONFIGURATION
40475 [main] INFO JPOX.RDBMS - Validated 1 foreign key(s) for table PROJECTNOTIFIER_CONFIGURATION
40479 [main] INFO JPOX.RDBMS - Validated 2 index(es) for table PROJECTNOTIFIER_CONFIGURATION
40483 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table PROJECTGROUP_BUILDDEFINITIONS
40504 [main] INFO JPOX.RDBMS - Validated 2 foreign key(s) for table PROJECTGROUP_BUILDDEFINITIONS
40509 [main] INFO JPOX.RDBMS - Validated 3 index(es) for table PROJECTGROUP_BUILDDEFINITIONS
40514 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table PROJECT_NOTIFIERS
40520 [main] INFO JPOX.RDBMS - Validated 2 foreign key(s) for table PROJECT_NOTIFIERS
40525 [main] INFO JPOX.RDBMS - Validated 3 index(es) for table PROJECT_NOTIFIERS
40538 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table PROJECT_BUILDDEFINITIONS
40549 [main] INFO JPOX.RDBMS - Validated 2 foreign key(s) for table PROJECT_BUILDDEFINITIONS
40555 [main] INFO JPOX.RDBMS - Validated 3 index(es) for table PROJECT_BUILDDEFINITIONS
40566 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.continuum.model.release.ContinuumReleaseResult [Table : CONTINUUMRELEASERESULT, InheritanceStrategy : new-table]
40569 [main] INFO JPOX.RDBMS - Creating table CONTINUUMRELEASERESULT
40683 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table CONTINUUMRELEASERESULT
40706 [main] INFO JPOX.RDBMS - Creating foreign key constraint : "CONTINUUMREL3U_FK2" in catalog "" schema ""
40780 [main] INFO JPOX.RDBMS - Creating foreign key constraint : "CONTINUUMREL3U_FK1" in catalog "" schema ""
40855 [main] INFO JPOX.RDBMS - Validated 3 index(es) for table CONTINUUMRELEASERESULT
40865 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.continuum.model.project.ProjectScmRoot [Table : PROJECTSCMROOT, InheritanceStrategy : new-table]
40944 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table PROJECTSCMROOT
40954 [main] INFO JPOX.RDBMS - Validated 1 foreign key(s) for table PROJECTSCMROOT
40959 [main] INFO JPOX.RDBMS - Validated 2 index(es) for table PROJECTSCMROOT
41223 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.continuum.model.repository.AbstractPurgeConfiguration [Table : ABSTRACTPURGECONFIGURATION, InheritanceStrategy : new-table]
41224 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.continuum.model.repository.RepositoryPurgeConfiguration [Table : REPOSITORYPURGECONFIGURATION, InheritanceStrategy : new-table]
41373 [main] INFO JPOX.RDBMS - Validated 2 unique key(s) for table REPOSITORYPURGECONFIGURATION
41379 [main] INFO JPOX.RDBMS - Validated 2 foreign key(s) for table REPOSITORYPURGECONFIGURATION
41383 [main] INFO JPOX.RDBMS - Validated 3 index(es) for table REPOSITORYPURGECONFIGURATION
41392 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table ABSTRACTPURGECONFIGURATION
41400 [main] INFO JPOX.RDBMS - Validated 1 foreign key(s) for table ABSTRACTPURGECONFIGURATION
41407 [main] INFO JPOX.RDBMS - Validated 2 index(es) for table ABSTRACTPURGECONFIGURATION
41469 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.continuum.model.repository.DirectoryPurgeConfiguration [Table : DIRECTORYPURGECONFIGURATION, InheritanceStrategy : new-table]
41564 [main] INFO JPOX.RDBMS - Validated 2 unique key(s) for table DIRECTORYPURGECONFIGURATION
41568 [main] INFO JPOX.RDBMS - Validated 1 foreign key(s) for table DIRECTORYPURGECONFIGURATION
41617 [main] INFO JPOX.RDBMS - Validated 2 index(es) for table DIRECTORYPURGECONFIGURATION
41850 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.system.SystemConfiguration [Table : SYSTEMCONFIGURATION, InheritanceStrategy : new-table]
41908 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table SYSTEMCONFIGURATION
41918 [main] INFO JPOX.RDBMS - Validated 1 index(es) for table SYSTEMCONFIGURATION
1874779 [main] INFO JPOX.JDO - PersistenceManagerFactory - Vendor: JPOX Version: 1.1.6
1874780 [main] INFO JPOX.JDO - PersistenceManagerFactory initialised for datastore URL=jdbc:derby:/tmp/apache-continuum-1.3.2/data/databases/continuum driver=org.apache.derby.jdbc.EmbeddedDriver userName=sa
1874854 [main] INFO JPOX.RDBMS - ================ DatabaseAdapter ==================
1874854 [main] INFO JPOX.RDBMS - Adapter : org.jpox.store.rdbms.adapter.DerbyAdapter
1874854 [main] INFO JPOX.RDBMS - Datastore : name="Apache Derby" version="10.1.3.1" (major=10, minor=1, revision=3)
1874854 [main] INFO JPOX.RDBMS - Driver : name="Apache Derby Embedded JDBC Driver" version="10.1.3.1" (major=10, minor=1)
1874854 [main] INFO JPOX.RDBMS - ===================================================
1874864 [main] INFO JPOX.RDBMS.Schema - Initialising Catalog "", Schema "SA" using "None" auto-start option
1874903 [main] INFO JPOX.RDBMS.Schema - Catalog "", Schema "SA" initialised - managing 0 classes
1874905 [main] WARN JPOX.MetaData - No manager for annotations was found in the CLASSPATH so all annotations are ignored.
1874994 [main] INFO JPOX.MetaData - Class org.apache.continuum.model.project.ProjectScmRoot specified to use "application identity" but no "objectid-class" was specified. Reverting to javax.jdo.identity.IntIdentity
1875008 [main] INFO JPOX.MetaData - Class org.apache.maven.continuum.model.project.ProjectGroup specified to use "application identity" but no "objectid-class" was specified. Reverting to javax.jdo.identity.IntIdentity
1875021 [main] INFO JPOX.MetaData - Class org.apache.maven.continuum.model.project.Project specified to use "application identity" but no "objectid-class" was specified. Reverting to javax.jdo.identity.IntIdentity
1875045 [main] INFO JPOX.MetaData - Class org.apache.maven.continuum.model.project.ProjectNotifier specified to use "application identity" but no "objectid-class" was specified. Reverting to javax.jdo.identity.IntIdentity
1875094 [main] INFO JPOX.MetaData - Class org.apache.maven.continuum.model.project.BuildResult specified to use "application identity" but no "objectid-class" was specified. Reverting to javax.jdo.identity.IntIdentity
1875104 [main] INFO JPOX.MetaData - Class org.apache.maven.continuum.model.project.BuildDefinition specified to use "application identity" but no "objectid-class" was specified. Reverting to javax.jdo.identity.IntIdentity
1875110 [main] INFO JPOX.MetaData - Class org.apache.maven.continuum.model.project.BuildDefinitionTemplate specified to use "application identity" but no "objectid-class" was specified. Reverting to javax.jdo.identity.IntIdentity
1875120 [main] INFO JPOX.MetaData - Class org.apache.maven.continuum.model.project.BuildQueue specified to use "application identity" but no "objectid-class" was specified. Reverting to javax.jdo.identity.IntIdentity
1875146 [main] INFO JPOX.MetaData - Class org.apache.maven.continuum.model.project.Schedule specified to use "application identity" but no "objectid-class" was specified. Reverting to javax.jdo.identity.IntIdentity
1875167 [main] INFO JPOX.MetaData - Class org.apache.maven.continuum.model.system.Profile specified to use "application identity" but no "objectid-class" was specified. Reverting to javax.jdo.identity.IntIdentity
1875192 [main] INFO JPOX.MetaData - Class org.apache.maven.continuum.model.system.Installation specified to use "application identity" but no "objectid-class" was specified. Reverting to javax.jdo.identity.IntIdentity
1875210 [main] INFO JPOX.MetaData - Class org.apache.continuum.model.release.ContinuumReleaseResult specified to use "application identity" but no "objectid-class" was specified. Reverting to javax.jdo.identity.IntIdentity
1875216 [main] INFO JPOX.MetaData - Class org.apache.continuum.model.repository.LocalRepository specified to use "application identity" but no "objectid-class" was specified. Reverting to javax.jdo.identity.IntIdentity
1875223 [main] INFO JPOX.MetaData - Class org.apache.continuum.model.repository.AbstractPurgeConfiguration specified to use "application identity" but no "objectid-class" was specified. Reverting to javax.jdo.identity.IntIdentity
1875277 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.system.SystemConfiguration [Table : SYSTEMCONFIGURATION, InheritanceStrategy : new-table]
1875350 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table SYSTEMCONFIGURATION
1875357 [main] INFO JPOX.RDBMS - Validated 1 index(es) for table SYSTEMCONFIGURATION
1875519 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.project.BuildQueue [Table : BUILDQUEUE, InheritanceStrategy : new-table]
1875520 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.project.Schedule [Table : SCHEDULE, InheritanceStrategy : new-table]
1875520 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Field : org.apache.maven.continuum.model.project.Schedule.buildQueues [Table : SCHEDULE_BUILDQUEUES]
1875567 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table BUILDQUEUE
1875572 [main] INFO JPOX.RDBMS - Validated 1 index(es) for table BUILDQUEUE
1875575 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table SCHEDULE
1875580 [main] INFO JPOX.RDBMS - Validated 1 index(es) for table SCHEDULE
1875583 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table SCHEDULE_BUILDQUEUES
1875586 [main] INFO JPOX.RDBMS - Validated 2 foreign key(s) for table SCHEDULE_BUILDQUEUES
1875590 [main] INFO JPOX.RDBMS - Validated 3 index(es) for table SCHEDULE_BUILDQUEUES
1875656 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.system.Installation [Table : INSTALLATION, InheritanceStrategy : new-table]
1875722 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table INSTALLATION
1875728 [main] INFO JPOX.RDBMS - Validated 1 index(es) for table INSTALLATION
1875762 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Class : org.apache.maven.continuum.model.system.Profile [Table : PROFILES, InheritanceStrategy : new-table]
1875763 [main] INFO JPOX.RDBMS.Schema - Managing Persistence of Field : org.apache.maven.continuum.model.system.Profile.environmentVariables [Table : PROFILE_ENVIRONMENTVARIABLES]
1875818 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table PROFILES
1875824 [main] INFO JPOX.RDBMS - Validated 2 foreign key(s) for table PROFILES
1875828 [main] INFO JPOX.RDBMS - Validated 3 index(es) for table PROFILES
1875832 [main] INFO JPOX.RDBMS - Validated 1 unique key(s) for table PROFILE_ENVIRONMENTVARIABLES
1875837 [main] INFO JPOX.RDBMS - Validated 2 foreign key(s) for table PROFILE_ENVIRONMENTVARIABLES
1875842 [main] INFO JPOX.RDBMS - Validated 3 index(es) for table PROFILE_ENVIRONMENTVARIABLES
Exception in thread "main" javax.jdo.JDODataStoreException: Insert request failed: INSERT INTO INSTALLATION ("NAME",INSTALLATIONTYPE,VAR_VALUE,MODEL_ENCODING,VAR_NAME,INSTALLATION_ID) VALUES (?,?,?,?,?,?)
at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:455)
at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2519)
at org.jpox.store.StoreManager.insert(StoreManager.java:920)
at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3647)
at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3626)
at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1198)
at org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1243)
at org.jpox.store.rdbms.scostore.ElementContainerStore.validateElementForWriting(ElementContainerStore.java:393)
at org.jpox.store.rdbms.scostore.AbstractListStore.internalAdd(AbstractListStore.java:1151)
at org.jpox.store.rdbms.scostore.AbstractListStore.addAll(AbstractListStore.java:386)
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)
at org.jpox.store.StoreManager.insert(StoreManager.java:920)
at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3647)
at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3626)
at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1198)
at org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:1261)
at org.codehaus.plexus.jdo.PlexusJdoUtils.addObject(PlexusJdoUtils.java:97)
at org.codehaus.plexus.jdo.PlexusJdoUtils.addObject(PlexusJdoUtils.java:78)
at org.apache.maven.continuum.management.JdoDataManagementTool.restoreDatabase(JdoDataManagementTool.java:289)
at org.apache.maven.continuum.management.DataManagementCli.processDatabase(DataManagementCli.java:270)
at org.apache.maven.continuum.management.DataManagementCli.main(DataManagementCli.java:170)
NestedThrowablesStackTrace:
ERROR 23505: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'INSTALLATION_PK' defined on 'INSTALLATION'.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown Source)
at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at org.jpox.store.rdbms.RDBMSManager.executeStatementUpdate(RDBMSManager.java:572)
at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:328)
at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2519)
at org.jpox.store.StoreManager.insert(StoreManager.java:920)
at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3647)
at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3626)
at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1198)
at org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1243)
at org.jpox.store.rdbms.scostore.ElementContainerStore.validateElementForWriting(ElementContainerStore.java:393)
at org.jpox.store.rdbms.scostore.AbstractListStore.internalAdd(AbstractListStore.java:1151)
at org.jpox.store.rdbms.scostore.AbstractListStore.addAll(AbstractListStore.java:386)
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)
at org.jpox.store.StoreManager.insert(StoreManager.java:920)
at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3647)
at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3626)
at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1198)
at org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:1261)
at org.codehaus.plexus.jdo.PlexusJdoUtils.addObject(PlexusJdoUtils.java:97)
at org.codehaus.plexus.jdo.PlexusJdoUtils.addObject(PlexusJdoUtils.java:78)
at org.apache.maven.continuum.management.JdoDataManagementTool.restoreDatabase(JdoDataManagementTool.java:289)
at org.apache.maven.continuum.management.DataManagementCli.processDatabase(DataManagementCli.java:270)
at org.apache.maven.continuum.management.DataManagementCli.main(DataManagementCli.java:170)


[ Permalink | « Hide ]
Wendy Smoak added a comment - 11/Apr/09 12:13 AM

Importing data from 1.2 into 1.3.3-SNAPSHOT (r763312) was successful. (Though the app is taking an exceptionally long time to start... over 15 minutes now.)

java -Xmx1024m -jar ~/Downloads/data-management-cli-1.3.3-SNAPSHOT-app.jar -buildsJdbcUrl jdbc:derby:/tmp/apache-continuum-1.3.3-SNAPSHOT/data/databases/continuum -mode IMPORT -directory ~/vmbuild-backups-20090410

I think it was fixed by CONTINUUM-2100, I'll mark this as a duplicate.
Atlassian JIRA (v4.0#466) | Report a problem | Request a feature | Contact administrators
Powered by a free Atlassian JIRA open source license for Codehaus. Try JIRA - bug tracking software for your team.