19 Mar
2013
19 Mar
'13
1:13 p.m.
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.bousquet(a)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.bousquet(a)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.burjan(a)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.bousquet(a)gmail.com> wrote:
+-------------+------------+--------------------------------------------+
> | -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.bousquet(a)gmail.com>
> > Answering myself partly ...
> > > > 2013/3/18 Jeremie BOUSQUET
<jeremie.bousquet(a)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
+----------------------+------------+----------------------------+---------------+
> >> | XWS_ID | XWS_NUMBER | XWS_NAME |
> >> XWS_CLASSNAME |
> >>
> >>
+----------------------+------------+----------------------------+---------------+
> >> | 232911443 | 1956069455 | Main |
> >> |
> >> | 5956685394971351254 | 1956069455 | |
> >> |
> >> | 7825842251281349221 | 1956069455 | Main |
> >> |
> >>
> >>
+----------------------+------------+----------------------------+---------------+
> > ... that fails again, on
another row. I believe that means that my
table
> > >> 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
> > _______________________________________________
> users mailing list
> users(a)xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
Mmmm the new problem seems somewhat different:
mysql> select * from xwikistatsdoc where xws_id='-1514641140';
+-------------+------------+--------------------------------------------+
| XWS_ID | XWS_NUMBER | XWS_NAME
|
>> 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):
> >>
> >>
> >>
>>
>> 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,
> >>
> > 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 ...
> >> 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
> >>
>