18 Mar
2013
18 Mar
'13
5:22 p.m.
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, 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
18 Mar
18 Mar
5:23 p.m.
New subject: [xwiki-users] Migrating 3.5 to 4.5.2
Possibly interesting note: I'm on MySql 5.1 / MyISAM engine
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 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, 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
5:49 p.m.
New subject: [xwiki-users] Migrating 3.5 to 4.5.2
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 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
5:56 p.m.
New subject: [xwiki-users] Migrating 3.5 to 4.5.2
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.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
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
6:01 p.m.
New subject: [xwiki-users] Migrating 3.5 to 4.5.2
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:
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.bousquet(a)gmail.com>
them ?
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
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
> 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
Br,
Jeremie
[1] http://jira.xwiki.org/browse/XWIKI-8129
6:38 p.m.
New subject: [xwiki-users] Migrating 3.5 to 4.5.2
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:
to
+----------------------+------------+----------------------------+---------------+
+----------------------+------------+----------------------------+---------------+
+----------------------+------------+----------------------------+---------------+
again
_______________________________________________
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 |
+-------------+------------+--------------------------------------------+
| -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
>> 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] >
[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 >> 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
19 Mar
19 Mar
11:27 a.m.
New subject: [xwiki-users] Migrating 3.5 to 4.5.2
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
[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 |
> >> |
> >>
> >>
+----------------------+------------+----------------------------+---------------+
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
> > >> 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 >
> 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 > 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
> >>
>
1:13 p.m.
New subject: [xwiki-users] Migrating 3.5 to 4.5.2
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
> >>
>
4 p.m.
New subject: [xwiki-users] Migrating 3.5 to 4.5.2
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.bousquet(a)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.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:
> 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.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
> >> 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(a)xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
4:52 p.m.
New subject: [xwiki-users] Migrating 3.5 to 4.5.2
Hi, Jeremie!
Did you merge/replace old Admin page with a new one?
Вторник, 19 марта 2013, 16:00 +01:00 от Jeremie BOUSQUET
<jeremie.bousquet(a)gmail.com>om>:
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.bousquet(a)gmail.com >
Kind regards,
Dmitry
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 >
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users 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=…
>]
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:
>
> > 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.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
> > >> 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(a)xwiki.org
> > http://lists.xwiki.org/mailman/listinfo/users
> >
> _______________________________________________
> users mailing list
> users(a)xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>
6:14 p.m.
New subject: [xwiki-users] Migrating 3.5 to 4.5.2
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_mamburu(a)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.bousquet(a)gmail.com>gt;:
org.xwiki.extension.handler.internal.DefaultExtensionHandlerManager.install(DefaultExtensionHandlerManager.java:82)
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
Kind regards,
Dmitry
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
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.bousquet(a)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.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=…]
> 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
>> >> 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:
>>>>
>>>> > 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.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
>>>>> > >> 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(a)xwiki.org
>> > http://lists.xwiki.org/mailman/listinfo/users
>> >
>> _______________________________________________
>> users mailing list
>> users(a)xwiki.org
>> http://lists.xwiki.org/mailman/listinfo/users
>>
>
4296
days inactive
4297
days old
10 comments
3 participants
participants (3)
-
Dmitry Bakbardin -
Jeremie BOUSQUET -
Sorin Burjan