Hello, So I workaround-ed the problem by truncating stats table and relaunching ... Retesting migration, seems to indicate that there are other cases of generating duplicate keys, apart from [1]...
So migration finished, I restarted my wiki, the distribution wizard appeared, I chose "3.5" version as previous version, it found the correct ui extension, the install plan was built, then I get that exception in the distribution wizard, preventing me from upgrading to 4.5.2, just after step "Applying INSTALL for extension [Administration Application 4.5.2<http://varsovie:8085/xwiki/bin/distribution/XWiki/Distribution?extensionId=org.xwiki.platform%3Axwiki%2Dplatform%2Dadministration%2Dui&extensionVersion=4.5.2&extensionNamespace=wiki%3Axwiki&xback=%2Fxwiki%2Fbin%2Fdistribution%2FXWiki%2FDistribution>] on namespace [xwiki <http://varsovie:8085/xwiki/bin/view/Main/WebHome>]" : Exception thrown during job execution class org.xwiki.extension.InstallException: Failed to install extension [org.xwiki.platform:xwiki-platform-administration-ui-4.5.2] at org.xwiki.extension.handler.internal.DefaultExtensionHandlerManager.install(DefaultExtensionHandlerManager.java:82) at org.xwiki.extension.job.internal.AbstractExtensionJob.installExtension(AbstractExtensionJob.java:181) at org.xwiki.extension.job.internal.AbstractExtensionJob.applyAction(AbstractExtensionJob.java:138) at org.xwiki.extension.job.internal.AbstractExtensionJob.applyActions(AbstractExtensionJob.java:91) at org.xwiki.extension.job.internal.InstallJob.start(InstallJob.java:143) at org.xwiki.job.AbstractJob.start(AbstractJob.java:134) at org.xwiki.job.internal.DefaultJobManager.run(DefaultJobManager.java:155) at java.lang.Thread.run(Thread.java:662) Caused by: class java.lang.NullPointerException: null at org.xwiki.extension.xar.internal.handler.XarExtensionHandler.initializePagesIndex(XarExtensionHandler.java:185) at org.xwiki.extension.xar.internal.handler.XarExtensionHandler.install(XarExtensionHandler.java:311) at org.xwiki.extension.xar.internal.handler.XarExtensionHandler.install(XarExtensionHandler.java:275) at org.xwiki.extension.handler.internal.DefaultExtensionHandlerManager.install(DefaultExtensionHandlerManager.java:80) at org.xwiki.extension.job.internal.AbstractExtensionJob.installExtension(AbstractExtensionJob.java:181) at org.xwiki.extension.job.internal.AbstractExtensionJob.applyAction(AbstractExtensionJob.java:138) at org.xwiki.extension.job.internal.AbstractExtensionJob.applyActions(AbstractExtensionJob.java:91) at org.xwiki.extension.job.internal.InstallJob.start(InstallJob.java:143) at org.xwiki.job.AbstractJob.start(AbstractJob.java:134) at org.xwiki.job.internal.DefaultJobManager.run(DefaultJobManager.java:155) at java.lang.Thread.run(Thread.java:662) Any ideas to overcome that problem ? My wiki being quite big, I'd prefer let the distribution wizard manage conflicts ... BR, Jeremie [1] http://jira.xwiki.org/browse/XWIKI-8129 2013/3/18 Jeremie BOUSQUET <jeremie.bousq...@gmail.com> > Sure, but I need to adapt my hot backup process to innodb first, and I > successfully migrated my test instance a while ago (to 4.4.1) that was > myisam too... > Btw I'm not sure innodb would have helped so much the migration... > > Thanks, > Jeremie > Le 18 mars 2013 18:01, "Sorin Burjan" <sorin.bur...@xwiki.com> a écrit : > > Hi, >> >> I can't help you much about the duplicate id issue, but what can I tell >> you >> is that using MyISAM is NOT recommended. >> >> See http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL >> >> You should try to convert your database to InnoDB and try a migration >> after. >> >> Regards, >> Sorin B. >> >> >> On Mon, Mar 18, 2013 at 6:56 PM, Jeremie BOUSQUET < >> jeremie.bousq...@gmail.com> wrote: >> >> > Mmmm the new problem seems somewhat different: >> > >> > mysql> select * from xwikistatsdoc where xws_id='-1514641140'; >> > >> +-------------+------------+--------------------------------------------+ >> > | XWS_ID | XWS_NUMBER | XWS_NAME >> | >> > >> +-------------+------------+--------------------------------------------+ >> > | -1514641140 | 1981003594 | DUMMY\.Operations.IOT Testing Guideline | >> > >> +-------------+------------+--------------------------------------------+ >> > 1 row in set (0.00 sec) >> > >> > mysql> select * from xwikistatsdoc where xws_name='DUMMY\.Operations.IOT >> > Testing Guideline' and xws_number='1981003594'; >> > >> > >> +----------------------+------------+-------------------------------------------+ >> > | XWS_ID | XWS_NUMBER | XWS_NAME >> > | >> > >> > >> +----------------------+------------+-------------------------------------------+ >> > | -6621163153525844851 | 1981003594 | DUMMY.Operations.IOT Testing >> > Guideline | >> > >> > >> +----------------------+------------+-------------------------------------------+ >> > >> > Exception was: R40000XWIKI6990 migration failed while converting ID from >> > [-1514641140] to [-6621163153525844851] >> > >> > Maybe issue is having 2 entries with same XWS_NAME and XWS_NUMBER, only >> > difference in name being "." versus "\." ? >> > >> > In that case what seems strange, is that when that migration starts, I >> get >> > the following warnings: >> > >> > ... Skipping invalid statistical entry [1260484991] with name [ >> > Blog.Dummy.com.] >> > >> > I wonder why the "DUMMY.Operations.IOT..." is not skept because of the >> "." >> > ?? >> > >> > BR, >> > Jeremie >> > >> > >> > >> > >> > 2013/3/18 Jeremie BOUSQUET <jeremie.bousq...@gmail.com> >> > >> > > Answering myself partly ... >> > > >> > > >> > > 2013/3/18 Jeremie BOUSQUET <jeremie.bousq...@gmail.com> >> > > >> > >> Hello, >> > >> >> > >> I'm trying migration of XWIki 3.5 to 4.5.2, and have some issues ... >> > >> >> > >> First, I must tell that I ran the queries described in [1], to >> cleanup >> > >> the 3 stats tables. >> > >> >> > >> What happened though, is that during the migration I got an >> OutOfMemory >> > >> error ... during migration of xwikistatsdoc. >> > >> I relaunched with more heap (2Go), but got it again. >> > >> I relaunched after activating safemode for that particular migration >> > (R40000XWIKI6990), >> > >> but then I got an issue on duplicate key for the xwikistatsdoc table: >> > >> >> > >> Caused by: com.xpn.xwiki.XWikiException: Error number 3005 in 3: >> > >> R40000XWIKI6990 migration failed while converting ID from >> [232911443] to >> > >> [7825842251281349221] >> > >> >> > >> A quick analysis of incriminated rows shows (sorry for display): >> > >> >> > >> >> > >> >> > >> +----------------------+------------+----------------------------+---------------+ >> > >> | XWS_ID | XWS_NUMBER | XWS_NAME | >> > >> XWS_CLASSNAME | >> > >> >> > >> >> > >> +----------------------+------------+----------------------------+---------------+ >> > >> | 232911443 | 1956069455 | Main | >> > >> | >> > >> | 5956685394971351254 | 1956069455 | | >> > >> | >> > >> | 7825842251281349221 | 1956069455 | Main | >> > >> | >> > >> >> > >> >> > >> +----------------------+------------+----------------------------+---------------+ >> > >> >> > >> To me it seems that as migration process was interrupted, maybe stat >> > with >> > >> id 232911443 was migrated successfully (in a previous run) to id >> > 7825842251281349221, >> > >> but old row was not removed. >> > >> So when migration occurs again, it tries to migrate that same line >> again >> > >> and fails. >> > >> >> > >> So I will try to run again after removing that line, >> > >> >> > > >> > > ... that fails again, on another row. I believe that means that my >> table >> > > is now corrupted and won't migrate, unless I remove the "potential" >> > > duplicates beforehand ... >> > > I wonder if it could be somewhat possible to write such a script, ie >> that >> > > would remove already migrated rows, or rows that once migrated will >> > > generate duplicates ? >> > > If not I would go back to my backup ... >> > > >> > > >> > >> but in case it fails, is it possible to only: >> > >> - put back my backup of the 3 stats tables only (as the rest was >> > >> successfully migrated) >> > >> - relaunch the migration >> > >> >> > >> Would I need to update something in the migration temp tables to >> achieve >> > >> that ? (ie restart migration only for stats tables), or will it do >> it by >> > >> itself as it knows that step was unsuccessful ? >> > >> >> > >> Asking that because migration is painfully long, so I prefer to >> prepare >> > >> myself to loose less time ... tomorrow ;-) >> > >> >> > >> Bonus question: There are plenty of rows in xwikistatsdoc with empty >> > >> value in "XWS_NAME" field. Are these normal ? Can I / Should I purge >> > them ? >> > >> >> > >> Br, >> > >> Jeremie >> > >> >> > >> [1] http://jira.xwiki.org/browse/XWIKI-8129 >> > >> >> > > >> > > >> > _______________________________________________ >> > users mailing list >> > users@xwiki.org >> > http://lists.xwiki.org/mailman/listinfo/users >> > >> _______________________________________________ >> users mailing list >> users@xwiki.org >> http://lists.xwiki.org/mailman/listinfo/users >> > _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users