So I could migrate my wiki instance to 4.5.2, hurrah ! :-) One problem remains, is that I can't login anymore with my "Admin" account. I tried to reset password on the Admin profile page, but still I can't login successfully. That's very weird...
2013/3/19 Jeremie BOUSQUET <[email protected]> > 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
