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
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users