Hi Dmitry, Well, I'm almost sure I did, but I don't remember precisely... Would you recommend to reinstall page XWiki.Admin from 4.5.2, or to put back the one from 3.5 ? Le 19 mars 2013 16:52, "Dmitry Bakbardin" <haru_mamb...@mail.ru> a écrit :
> Hi, Jeremie! > > Did you merge/replace old Admin page with a new one? > > > Вторник, 19 марта 2013, 16:00 +01:00 от Jeremie BOUSQUET < > jeremie.bousq...@gmail.com>: > >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 < jeremie.bousq...@gmail.com > > > > >> 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 < jeremie.bousq...@gmail.com > > >> > >>> 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 > > > Kind regards, > > Dmitry > _______________________________________________ > 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