Mmm seems I could solve it. I had the following error at startup since a long time:
2013-03-19 11:09:40,248 [main] ERROR ltInstalledExtensionRepository - Invalid extension [gdelhumeau:livetableexcelexport-macro-1.0] it will not be loaded org.xwiki.extension.InvalidExtensionException: The dependency [org.xwiki.contrib:xwiki-plugin-excel-] of extension [gdelhumeau:livetableexcelexport-macro-1.0] is invalid So I chose "Skip" from DW, shutdown the wiki, remove that extension from my permanent directory, restarted wiki... And now DW seems to be able to continue install, and propose conflicts on admin app. Now it works but I can't login anymore as "Admin", other users login work but not that one for any reason ... Hope it will be fixed after DW upgrades. BR, Jeremie 2013/3/19 Jeremie BOUSQUET <[email protected]> > 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 <[email protected]> > >> 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" <[email protected]> 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 < >>> [email protected]> 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 <[email protected]> >>> > >>> > > Answering myself partly ... >>> > > >>> > > >>> > > 2013/3/18 Jeremie BOUSQUET <[email protected]> >>> > > >>> > >> 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 >>> > [email protected] >>> > http://lists.xwiki.org/mailman/listinfo/users >>> > >>> _______________________________________________ >>> users mailing list >>> [email protected] >>> http://lists.xwiki.org/mailman/listinfo/users >>> >> > _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
