Re: [xwiki-users] Migration from 2.4 to the latest debian package (4.1.4): Duplicate entry error on R40000XWIKI6990

From what I know there is two migration modes and by default the

Hi, I'm trying tom igrate an xwiki installation at version 2.4 to the latest debian package (4.1.4). This is on Tomcat 7 and Mysql 5.5 with Oracle Java 6 update 34. I get the following error: 2012-09-17 18:03:32,895 [https://par-wiki-1.clear2pay.com/xwiki/bin/view/Main/] INFO .HibernateDataMigrationManager - Running migration [R40000XWIKI6990] with version [40000] 2012-09-17 18:03:33,014 [https://par-wiki-1.clear2pay.com/xwiki/bin/view/Main/] INFO h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] - Retrieved 0 document IDs to be converted. 2012-09-17 18:03:33,144 [https://par-wiki-1.clear2pay.com/xwiki/bin/view/Main/] INFO h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] - Retrieved 0 object IDs to be converted. 2012-09-17 18:03:33,260 [https://par-wiki-1.clear2pay.com/xwiki/bin/view/Main/] INFO h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] - Retrieved 3 custom mapped classes to be processed. 2012-09-17 18:03:34,517 [https://par-wiki-1.clear2pay.com/xwiki/bin/view/Main/] INFO h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] - Retrieved 14750 document statistics IDs to be converted. 2012-09-17 18:03:34,535 [https://par-wiki-1.clear2pay.com/xwiki/bin/view/Main/] INFO h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] - Retrieved 83 referer statistics IDs to be converted. 2012-09-17 18:03:34,852 [https://par-wiki-1.clear2pay.com/xwiki/bin/view/Main/] INFO h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] - Retrieved 36076 visit statistics IDs to be converted. 2012-09-17 18:03:34,897 [https://par-wiki-1.clear2pay.com/xwiki/bin/view/Main/] INFO h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] - No document IDs to convert, skipping. 2012-09-17 18:03:34,897 [https://par-wiki-1.clear2pay.com/xwiki/bin/view/Main/] INFO h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] - No object IDs to convert, skipping. 2012-09-17 18:03:34,898 [https://par-wiki-1.clear2pay.com/xwiki/bin/view/Main/] INFO h.R40000XWIKI6990DataMigration - [R40000XWIKI6990] - Converting 14750 document statistics IDs in 1 tables... 2012-09-17 18:03:38,742 [https://par-wiki-1.clear2pay.com/xwiki/bin/view/Main/] WARN o.h.u.JDBCExceptionReporter - SQL Error: 1062, SQLState: 23000 2012-09-17 18:03:38,742 [https://par-wiki-1.clear2pay.com/xwiki/bin/view/Main/] ERROR o.h.u.JDBCExceptionReporter - Duplicate entry '5441591690732251370' for key 'PRIMARY' 2012-09-17 18:03:38,856 [https://par-wiki-1.clear2pay.com/xwiki/bin/view/Main/] INFO .HibernateDataMigrationManager - Failed to migrate database [xwiki]... com.xpn.xwiki.store.migration.DataMigrationException: Data migration R40000XWIKI6990 failed at com.xpn.xwiki.store.migration.hibernate.AbstractHibernateDataMigration.migrate(AbstractHibernateDataMigration.java:111) ~[xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:621) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrationsForDatabase(AbstractDataMigrationManager.java:546) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:493) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.startMigrations(HibernateDataMigrationManager.java:296) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:421) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:666) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:813) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:746) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:736) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:290) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1438) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1481) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.XWiki.getXWikiPreference(XWiki.java:2215) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.XWiki.getXWikiPreference(XWiki.java:2247) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.render.XWikiMacrosMappingRenderer.loadPreferences(XWikiMacrosMappingRenderer.java:107) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.render.XWikiMacrosMappingRenderer.<init>(XWikiMacrosMappingRenderer.java:83) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.render.DefaultXWikiRenderingEngine.<init>(DefaultXWikiRenderingEngine.java:72) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.XWiki.resetRenderingEngine(XWiki.java:1114) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:790) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.XWiki.<init>(XWiki.java:738) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:399) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:486) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) [struts-1.2.9.jar:1.2.9] at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) [struts-1.2.9.jar:1.2.9] at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) [struts-1.2.9.jar:1.2.9] at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) [struts-1.2.9.jar:1.2.9] at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) [tomcat-servlet-api-3.0.jar:na] at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) [tomcat-servlet-api-3.0.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) [tomcat-catalina-7.0.28.jar:7.0.28] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [tomcat-catalina-7.0.28.jar:7.0.28] at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [tomcat-catalina-7.0.28.jar:7.0.28] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [tomcat-catalina-7.0.28.jar:7.0.28] at org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144) [xwiki-platform-wysiwyg-server-4.1.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [tomcat-catalina-7.0.28.jar:7.0.28] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [tomcat-catalina-7.0.28.jar:7.0.28] at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66) [xwiki-platform-webdav-server-4.1.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [tomcat-catalina-7.0.28.jar:7.0.28] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [tomcat-catalina-7.0.28.jar:7.0.28] at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) [xwiki-platform-container-servlet-4.1.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [tomcat-catalina-7.0.28.jar:7.0.28] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [tomcat-catalina-7.0.28.jar:7.0.28] at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) [xwiki-platform-container-servlet-4.1.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [tomcat-catalina-7.0.28.jar:7.0.28] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [tomcat-catalina-7.0.28.jar:7.0.28] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225) [tomcat-catalina-7.0.28.jar:7.0.28] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) [tomcat-catalina-7.0.28.jar:7.0.28] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) [tomcat-catalina-7.0.28.jar:7.0.28] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) [tomcat-catalina-7.0.28.jar:7.0.28] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) [tomcat-catalina-7.0.28.jar:7.0.28] at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) [tomcat-catalina-7.0.28.jar:7.0.28] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) [tomcat-catalina-7.0.28.jar:7.0.28] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) [tomcat-catalina-7.0.28.jar:7.0.28] at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200) [tomcat-coyote-7.0.28.jar:7.0.28] at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) [tomcat-coyote-7.0.28.jar:7.0.28] at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310) [tomcat-coyote-7.0.28.jar:7.0.28] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_34] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_34] at java.lang.Thread.run(Thread.java:662) [na:1.6.0_34] Caused by: com.xpn.xwiki.XWikiException: Error number 3005 in 3: R40000XWIKI6990 migration failed Wrapped Exception: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: could not execute native bulk manipulation query at com.xpn.xwiki.store.migration.hibernate.R40000XWIKI6990DataMigration.hibernateMigrate(R40000XWIKI6990DataMigration.java:1299) ~[xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.store.migration.hibernate.AbstractHibernateDataMigration.migrate(AbstractHibernateDataMigration.java:109) ~[xwiki-platform-legacy-oldcore-4.1.4.jar:na] ... 61 common frames omitted Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: could not execute native bulk manipulation query at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1214) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:1322) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.store.migration.hibernate.R40000XWIKI6990DataMigration.hibernateMigrate(R40000XWIKI6990DataMigration.java:1286) ~[xwiki-platform-legacy-oldcore-4.1.4.jar:na] ... 62 common frames omitted Caused by: org.hibernate.exception.ConstraintViolationException: could not execute native bulk manipulation query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:219) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1310) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:396) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at com.xpn.xwiki.store.migration.hibernate.R40000XWIKI6990DataMigration$AbstractBulkIdConversionHibernateCallback.executeSqlIdUpdate(R40000XWIKI6990DataMigration.java:531) ~[xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.store.migration.hibernate.R40000XWIKI6990DataMigration$7.doBulkIdUpdate(R40000XWIKI6990DataMigration.java:1294) ~[xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.store.migration.hibernate.R40000XWIKI6990DataMigration$AbstractBulkIdConversionHibernateCallback.doUpdate(R40000XWIKI6990DataMigration.java:356) ~[xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.store.migration.hibernate.R40000XWIKI6990DataMigration$AbstractUpdateHibernateCallback.doInHibernate(R40000XWIKI6990DataMigration.java:218) ~[xwiki-platform-legacy-oldcore-4.1.4.jar:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1208) [xwiki-platform-legacy-oldcore-4.1.4.jar:na] ... 64 common frames omitted Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '5441591690732251370' for key 'PRIMARY' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.6.0_34] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) ~[na:1.6.0_34] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) ~[na:1.6.0_34] at java.lang.reflect.Constructor.newInstance(Constructor.java:513) ~[na:1.6.0_34] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.16.jar:na] at com.mysql.jdbc.Util.getInstance(Util.java:386) ~[mysql-connector-java-5.1.16.jar:na] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040) ~[mysql-connector-java-5.1.16.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597) ~[mysql-connector-java-5.1.16.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529) ~[mysql-connector-java-5.1.16.jar:na] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990) ~[mysql-connector-java-5.1.16.jar:na] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151) ~[mysql-connector-java-5.1.16.jar:na] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625) ~[mysql-connector-java-5.1.16.jar:na] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) ~[mysql-connector-java-5.1.16.jar:na] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415) ~[mysql-connector-java-5.1.16.jar:na] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333) ~[mysql-connector-java-5.1.16.jar:na] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318) ~[mysql-connector-java-5.1.16.jar:na] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.3.jar:1.3] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.3.jar:1.3] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.3.jar:1.3] at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:210) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] ... 71 common frames omitted How can I proceed with the migration ? Should I try to migrate from 2.4 to another version first ? Philippe _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users