[CONTINUUM-2323] Duplicate entry error during database migration from 1.2.2 to 1.3.3

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: backlog-to-cleanup
• Environment: Installed as a WAR under Tomcat; Running with MySQL DB
• Assignee: Unassigned
• Reporter: David Degardin
• Created: 11/Aug/09 10:20
• Updated: 20/Nov/12 01:10

Description

I'm trying to migrate from continuum-1.2.2 to continuum 1.3.3.

I've followed this procedure: http://continuum.apache.org/docs/1.3.3/installation/upgrade.html (i.e export with data-management-cli-1.2.3.1 and import with data-management-cli-1.3.2).

I've managed to export but I've got an exception during import:
"Exception in thread "main" javax.jdo.JDODataStoreException: Insert request failed: INSERT INTO `INSTALLATION` (`VAR_NAME`,`INSTALLATIONTYPE`,`NAME`,`VAR_VALUE`,`MODEL_ENCODING`,`INSTALLATION_ID`) VALUES (?,?,?,?,?,?)
at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:455)
......
NestedThrowablesStackTrace:
com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '4' for key 1"

When I look at the builds.xml file, there is no duplicate entry for installations...
Where am I wrong ? Please help, it's been awhile this stuff does not work.

Thanks

David

Issue Links

• relates to: CONTINUUM-2100 Unable to import data that includes installations