Hi, Jeremie! Did you merge/replace old Admin page with a new one?
Вторник, 19 марта 2013, 16:00 +01:00 от Jeremie BOUSQUET <[email protected]>: >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 Kind regards, Dmitry _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
