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

Reply via email to