IRC Archive for channel #xwiki on 15 October 2012

00:07 <cjd> has joined #xwiki
00:09 <dirk_schmitt> has quit
00:19 <vmassol> has joined #xwiki
00:28 <vmassol> has quit
00:45 <jvdrean> has quit
00:53 <jvdrean> has joined #xwiki
00:54 <vmassol> has joined #xwiki
01:04 <vmassol> has quit
01:28 <vmassol> has joined #xwiki
01:40 <vmassol> has quit
02:05 <vmassol> has joined #xwiki
02:15 <vmassol> has quit
02:23 <jvdrean1> has joined #xwiki
02:23 <jvdrean> has quit
02:40 <vmassol> has joined #xwiki
02:52 <vmassol> has quit
03:17 <vmassol> has joined #xwiki
03:27 <vmassol> has quit
03:27 <jvdrean1> has quit
03:53 <vmassol> has joined #xwiki
04:04 <vmassol> has quit
04:29 <vmassol> has joined #xwiki
04:30 <Denis> has joined #xwiki
04:40 <vmassol> has quit
04:42 <SvenDowideit> has quit
04:44 <SvenDowideit> has joined #xwiki
05:05 <tekzilla> has quit
05:05 <vmassol> has joined #xwiki
05:07 <tekzilla> has joined #xwiki
05:17 <vmassol> has quit
05:41 <vmassol> has joined #xwiki
05:51 <vmassol> has quit
06:00 <Denis> has quit
06:10 <cjd> has quit
06:17 <cjd> has joined #xwiki
06:17 <vmassol> has joined #xwiki
06:28 <vmassol> has quit
06:54 <vmassol> has joined #xwiki
07:06 <vmassol> has quit
07:27 <mflorea> has joined #xwiki
07:30 <vmassol> has joined #xwiki
07:41 <vmassol> has quit
08:01 <polx> has joined #xwiki
08:06 <vmassol> has joined #xwiki
08:18 <vmassol> has quit
08:26 <vmassol> has joined #xwiki
08:28 <mflorea> has quit
08:29 <mflorea> has joined #xwiki
08:33 <tmortagne> has joined #xwiki
08:37 <vmassol> good morning all
08:38 <vmassol> reminder: 4.3M1 release is for next Monday so we have 1 week left to commit stuff
08:38 <vmassol> sdumitriu: would be good to commit your page generation feature ASAP
08:41 <mflorea> has quit
08:56 <vmassol> has quit
09:00 <mflorea> has joined #xwiki
09:18 <vmassol> has joined #xwiki
09:28 <sburjan> has joined #xwiki
09:59 <jvdrean> has joined #xwiki
10:39 <dirk_schmitt> has joined #xwiki
10:39 <Slashman> has joined #xwiki
11:01 <dirk_schmitt> Yesterday I described here and in "[xwiki-users] Problem migration xwiki 3.1.1 --> 4.2 below postgresql 'Database xwiki needs migration(s)'" my migration problem.
11:01 <dirk_schmitt> Anybody around here who can help me to track down a way around my problem ?
11:02 <Denis1> has joined #xwiki
11:03 <Denis1> is now known as <Denis>
11:08 <jvdrean> has left #xwiki
11:09 <vmassol> hi everyone, we need a release manager for XWiki 4.3M1
11:09 <vmassol> here's the roster: http://dev.xwiki.org/xwiki/bin/view/Community/ReleaseManagerRoster
11:10 <vmassol> good candidates IMO: jerome, edy, Denis :)
11:15 <dirk_schmitt> Denis: May you please assist me in my issue described yesterday here and in Yesterday I described here and in "[xwiki-users] Problem migration xwiki 3.1.1 --> 4.2 below postgresql 'Database xwiki needs migration(s)'" ?
11:19 <+Denis> dirk_schmitt: Sure, but from the information in your mail, I have absolutely no clue :(
11:21 <dirk_schmitt> What can I do to achieve more informations ?
11:21 <+Denis> is it XE or XEM ?
11:23 <dirk_schmitt> xwiki-enterprise-web-4.2.war deployed to tomcat-7
11:24 <dirk_schmitt> (sorry if I not catching the acronyms)
11:25 <dirk_schmitt> The old instance (set to read-only is still available  below https://www.computer42.org/xwiki/bin/view/Main/ )
11:25 <+Denis> could you provide the catalina.out ? from your mail, it seems many useful messages are not there. Have you change the default login level ?
11:26 <+Denis> logging level
11:27 <dirk_schmitt> The logback.xml has been switched to syslog.  A moment, I will revert the logback.xml and generate a new logfile.
11:28 <+Denis> be sure to start over with your fresh original DB
11:29 <+Denis> and be careful, two new table are created during import, these should be dropped
11:31 <+Denis> (DATABASECHANGELOG and DATABASECHANGELOGLOCK tables)
11:31 <dirk_schmitt> The new catalina.out is below http://www.computer42.org/~dirk/tmp/catalina.out
11:33 <+Denis> seems you have not followed my advices about the two table above :)
11:33 <vmassol> Denis: those are really a pain
11:33 <vmassol> every user has the same issue with those tables
11:33 <+Denis> there are not, this is just the way you restore your db that is bad
11:33 <vmassol> it would be so cool to be able to do something about it :)
11:34 <vmassol> maybe a message to explain how to restore the DB properly or something
11:34 <+Denis> simple teach people that to restore a fresh db, the best way it to drop the DB first
11:34 <vmassol> it's not a problem if the solution is manual but it would be good that teh users don't have to contact us
11:35 <vmassol> a message would probably be the simplest to do, wdyt?
11:35 <dirk_schmitt> Denis: Converning the 2 tables - what documentation I have missed to read?
11:35 <dirk_schmitt> ^h^h^hConcerning
11:35 <+Denis> but this is not our job to teach peoples how to use their DBMS, and all differs
11:36 <+Denis> dirk_schmitt: just told you that to start over you need to start with your original DB, and that you should be careful these table have been properly dropped
11:38 <+Denis> vmassol: the main issue for us to be so clever is to know this is a mistake to have these table in the way. This only happen on failed migration that are poorly retried
11:38 <dirk_schmitt> I was done the work on the original db. (the live read only instance is running on a copy).
11:38 <dirk_schmitt> Should I now drop these tables ?
11:38 <vmassol> dirk_schmitt: here:
11:39 <vmassol> http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Backup
11:39 <vmassol> especially the part "It's important that the backup is done with --add-drop-database since when you restore it it's important that tables that might have been created are removed."
11:39 <vmassol> AFAIK… Denis would know better
11:39 <+Denis> dirk_schmitt: you said you are producing a new log. I need that you start over from the original DB and that you ensure these to table does not exists after restore of your original DB
11:44 <dirk_schmitt> I'm working with the original db. (The readonly live instance i mentioned before is running on a copy of the original database).
11:45 <dirk_schmitt> So have no backup of the database without these 2 tables.
11:45 <dirk_schmitt> I'm try to migrate from a XWiki 3.1.1 --> 4.2.
11:45 <dirk_schmitt> I think that these 2 tables are for a long time in my database. (In the past there were some blockers which doesn't allow the XWiki upgrade on postgres).
11:45 <dirk_schmitt> Just a note: The upgrade/migration of another installation yesterday was successful.
11:45 <dirk_schmitt> Denis: Should I now drop these tables ?
11:47 <+Denis> dirk_schmitt: these tables could have only been created by a attempt of a 4.x migration, it means your original database is not really clean. Anyway, drop them, and let me see the log again
11:48 <vmassol> Denis: I'm about to start migrating xwiki.org to 4.2 this afternoon….
11:48 <vmassol> Denis: would be great if you are around ;)
11:48 <dirk_schmitt> vmassol: The --add-drop-database note is attached to mysql, not postgresql.
11:48 <vmassol> dirk_schmitt: indeed
11:48 <+Denis> vmassol: I'll be around until 16:30
11:48 <vmassol> ok thanks
11:51 <jvdrean> has joined #xwiki
11:54 <dirk_schmitt> Denis: http://www.computer42.org/~dirk/tmp/11_53-catalina.out
11:55 <dirk_schmitt> The two tables are created again after start of tomcat (and access xwiki).
11:55 <+Denis> which is normal
12:01 <dirk_schmitt> I see in the successful migrated instance from yesterday the same tables. So these tables are not dropped after a migration ?
12:01 <dirk_schmitt> This implies if I take a backup and run 'dropdb xwiki && pg_restore -C ...' I will get the same result as in the beginning ?
12:03 <+Denis> dirk_schmitt: no these tables are created by the first migration to 4.x, and these keep a record of the schema updates executed over the DB. If you have run an older version of the migration procedure at some point, the executed update has been updated and therefore conflict with then new one. This is why these table should not exists on a table earlier to 4.x
12:05 <+Denis> dirk_schmitt: well, now regarding the failure, I am not a postgresql expert, but it seems you have a permission issue during some access to the data, and in particular large objects.
12:07 <+Denis> dirk_schmitt: maybe you would like to execute something like http://pastebin.com/49cD59FW on your DB to fixup the issue, and simply restart the migration (no need to start over from the beginning now)
12:12 <+Denis> dirk_schmitt: maybe Sergui could have better clue about this issue, since it is the R35102XWIKI777: Migration for XWIKI-7771: Fix the LOBs wrongly created by the 3.2-3.5 mapping files for PostgreSQL, that failed on LOBs in fact. This is possible we have a particular issue in your case.
12:12 <+Denis> sdumitriu: any clue on the above ?
12:14 <+Denis> sdumitriu: the log is http://www.computer42.org/~dirk/tmp/11_53-catalina.out
12:18 <cdop> has joined #xwiki
12:18 <dirk_schmitt> Denis: There should I use your command sequence ? (what language ?)
12:18 <dirk_schmitt> Is it o.k. to use this shell alternative to produce the sql code?
12:18 <dirk_schmitt> for id in $(psql  -c 'select loid from pg_catalog.pg_largeobject;') ; do echo ALTER LARGE OBJECT $id  OWNER to ownsers_username ; done
12:19 <dirk_schmitt> ^h^h^h^howners_username
12:21 <+Denis> dirk_schmitt: I could not help on that, let sdumitriu provide some advice here
12:25 <dirk_schmitt> Should  'owners_username ' be the database user used by hibernate.xml ?
12:28 <mflorea> has quit
12:28 <dirk_schmitt> sdumitriu is away since ~17h ;-)
12:31 <+Denis> dirk_schmitt: he should be back in not so long then :)
12:34 <+Denis> dirk_schmitt: maybe this is not a permission issue but an issue with the migration itself. Reading your mail back, it seems you are starting from a 3.1.1 version, and that migration fix an issue introduced in the mapping of 3.2, currious that it is executed than.
12:35 <tmortagne> has quit
12:37 <+Denis> dirk_schmitt: if you are sure you do not have use a 3.2 mapping, you may simply go over, and force skipping that migration using: xwiki.store.migration.ignored=35102 in xwiki.cfg
12:38 <+Denis> dirk_schmitt: use this with care however since it could cause more harm than good if use wrongly, only sdumitriu could tell you more now :)
12:49 <dirk_schmitt> O.k. I will go to lunch first :-)
12:55 <cdop> question: can I specify which user group *only* are allowed to use wysiwyg or which user group may select between wysiwyg and source editing?
12:57 <vmassol> cdop: not ouf of the box, the editor to use is a profile preference
12:57 <vmassol> (ie each user choses what editor to use)
12:58 <vmassol> now nothing prevents you from writing some script/change some vm files to do what you want but it's not a built in feature and I'm not sure we would want it
12:59 <vmassol> I'd be interested to know the reason for which you'd like to do this
12:59 <cdop> well i want to use the xwiki in our company and i am afraid that non-techs would find "source-editing" and break stuff.
12:59 <vmassol> ok that makes sense
13:00 <vmassol> for simple users we don't show the wiki editor
13:00 <vmassol> so it would make sense to also not show the source tab in the WYSIWYG editor IMO
13:00 <vmassol> cdop: you should raise a jira issue about this
13:00 <+sburjan> we already have that afaik in WYSIWYG Admin page
13:00 <+sburjan> to hide the source tab
13:01 <vmassol> sburjan: no
13:01 <vmassol> that's different
13:01 <cdop> yes, but us in the tech-department prefer  (and should) be able to edit source.
13:01 <cdop> so it should be a permission thing.
13:01 <vmassol> its not permission
13:01 <vmassol> it's profile-type based
13:02 <vmassol> simple users should not see this tab by default I agree
13:02 <vmassol> since they don't see the wiki editor menu entry either
13:03 <cdop> ah ok, now i get it
13:03 <cdop> so the issue should be called "Hide WYSIWYG-Sourcetab for simple users".
13:03 <vmassol> exactly
13:04 <cdop> ok, gonna report it :)
13:04 <vmassol> cool
13:08 <+sburjan> vmassol: I don't understand. So if a simple user type is selected, then the source tab shoul be hidden ? as a profile based preference, not a global setting ?
13:14 <cdop> hmm it seems that a "simple user" can switch himself to a "advanced user". so a noob could gain source-editing-access... no good.
13:18 <+sburjan> yes
13:19 <vmassol> has quit
13:20 <cdop> ok, but i guess thats not that bad. as most noob users wont even find their profile-page ;)
13:21 <vmassol> has joined #xwiki
13:21 <cdop> and as my users are all from our company, we can blame them if they twiddle to much :)
13:21 <vmassol> cdop: that's perfectly normal and wanted
13:23 <vmassol> (sorry was offline during a few seconds)
13:23 <vmassol> I was ansswering to:
13:23 <vmassol> "hmm it seems that a "simple user" can switch himself to a "advanced user". so a noob could gain source-editing-access... no good."
13:24 <vmassol> "vmassol: I don't understand. So if a simple user type is selected, then the source tab shoul be hidden ? as a profile based preference, not a global setting ?"
13:24 <vmassol> yes
13:25 <cdop> ok, thanks. so ok i have an advanced question. i want not to use those (existing) formatting macros. i want to select text in wysiwyg-editor, press one button in the toolbar and have it formatted/highlighted as "python-code", press another button have it formatted as "java-code", press another and have all formatting/high-lighting removed.
13:26 <cdop> in case i dont want to use my time with that, but "buy" developer-time/developments from the xwiki-devs, how would that work?
13:27 <cdop> <-working in a german company
13:27 <vmassol> ouch
13:27 <vmassol> mistake
13:27 <vmassol> I hate that
13:28 <cdop> german companies? i agree .)
13:28 <vmassol> :)
13:28 <vmassol> no, hitting delete space instead of delete page
13:28 <cdop> oh :) even worse
13:29 <cdop> but for that there is roleback, right?
13:29 <vmassol> no :(
13:29 <cdop> :-/
13:33 <vmassol> cdop:
13:33 <vmassol> there's rollback but only one page at a time
13:34 <vmassol> cdop: you can contact one of the companies offering professional support, see http://www.xwiki.org/xwiki/bin/view/Main/Support#HProfessionalSupport
13:48 <vmassol> has quit
13:50 <vmassol> has joined #xwiki
13:54 <cdop> ah thanks :)
13:57 <+Denis> vmassol: there isn't any confirmation ?
13:57 <vmassol> Denis: there is but it's the same one as when you're deleting a page
13:58 <vmassol> so i thought I was deleting just a page
13:58 <vmassol> the menus are next to each other
13:58 <vmassol> ...
13:58 <vmassol> we need to make it harder to make a mistake
13:58 <+Denis> a proper confirmation should list what would be deleted in details !
13:58 <vmassol> imagine if I had deleted the XWiki space ;)
13:58 <vmassol> wich over 10K users
13:58 <vmassol> * with
13:59 <vmassol> Denis: yes good idea
13:59 <vmassol> could be a livetable listing all the pages that will be deleted
13:59 <+Denis> the snipped we had before just do that, and it was really good to notice what your are deleting is finally not what you expect
13:59 <+Denis> (not in a livetable, but would be better of course)
14:01 <vmassol> http://jira.xwiki.org/browse/XWIKI-8320
14:24 <mflorea> has joined #xwiki
14:28 <sburjan_> has joined #xwiki
14:30 <vmassol> would be interesting to extend JSX/SSX support to multiwiki....
14:31 <sburjan`> has quit
14:31 <sburjan_> is now known as <sburjan`>
14:31 <vmassol> for ex I'd like to add a banner to explain that the wiki is in maintenance and thus read only
14:31 <vmassol> I caneasily do this in JSX but only for the current wiki....
14:31 <vmassol> to make it work in a farm I need to override the skin and copy a whole vm file
14:46 <mrvanes> has joined #xwiki
14:57 <sburjan_> has joined #xwiki
14:59 <sburjan`> has quit
14:59 <sburjan_> is now known as <sburjan`>
15:01 <@sdumitriu> Denis, dirk_schmitt: Good morning
15:02 <+Denis> sdumitriu: Good morning Sergiu !
15:03 <@sdumitriu> Hm, weird permission issue...
15:03 <@sdumitriu> Never saw that
15:04 <+Denis> is it really a permission issue ? since he says migrating from 3.1
15:05 <+Denis> is it expected that the migration is executed ?
15:07 <+Denis> could the migration be simply ignored by force ?
15:09 <@sdumitriu> First, dirk_schmitt are you sure that's a 3.1.2?
15:11 <@sdumitriu> The migrator is supposed to do nothing if the data doesn't need migration
15:34 <dirk_schmitt> Hi Sergiu :-)
15:34 <dirk_schmitt> I have 2 instances. One you know, there you have helped me in January 2011 to fix an issue. This instance is migrated and seem to work. -->http://www.pfarreiengemeinschaft-westum-loehndorf.de/xwiki/.
15:34 <dirk_schmitt> The other intance is (currently read only) available below https://www.computer42.org/xwiki/
15:34 <dirk_schmitt> It reports to be 'XWIKI ENTERPRISE 3.1.1'
15:34 <dirk_schmitt> The migration of both was delayed because of the various postgres related problems, e.g. XWIKI-7564.
15:34 <dirk_schmitt> If it help I can switch of the "read only mode".
15:34 <dirk_schmitt> The migration should be done on a different installation with copied database in a new tomcat (v7) container.
15:37 <sburjan_> has joined #xwiki
15:39 <sburjan`> has quit
15:39 <sburjan_> is now known as <sburjan`>
15:44 <sburjan_> has joined #xwiki
15:47 <sburjan`> has quit
15:47 <sburjan_> is now known as <sburjan`>
16:01 <rrodriguez> has joined #xwiki
16:28 <sburjan_> has joined #xwiki
16:28 <sburjan`> has quit
16:28 <sburjan_> is now known as <sburjan`>
16:29 <dirk_schmitt> sdumitriu: ping
16:42 <@sdumitriu> Pong
16:45 <vmassol> has quit
16:46 <vmassol> has joined #xwiki
16:49 <cdop> 13 minutes... well he should be somewhere between mars and jupiter.
17:03 <@sdumitriu> Yep, I was just watching Curiosity pass by
17:03 <vmassol> :)
17:03 <@sdumitriu> (was actually making a tea)
17:05 <dirk_schmitt> sdumitriu: As I stated before, the migration should upgrade 3.1.1 to 4.2.
17:19 <rrodriguez> has quit
17:27 <vmassol> guys, we need to set the status flags on all those issues with patches: http://jira.xwiki.org/secure/Dashboard.jspa?selectPageId=10000#Issue-Statistics/10472
17:40 <vmassol> only 27 to go…. need help!
17:41 <vmassol> (I'm starting from the bottom)
17:41 <sburjan`> has quit
17:42 <sburjan> has quit
17:52 <vmassol> 20 more
18:03 <vmassol> Denis: there are a few patches created by your in jira, probably when you were not a committer, you could maybe review htem now? )
18:03 <vmassol> :)
18:03 <vmassol> (here's one for ex: http://jira.xwiki.org/browse/XWIKI-3328 )
18:10 <vmassol> 13 to go...
18:13 <vmassol> AndreasJonsson: I have a patch for your to review: http://jira.xwiki.org/browse/XWIKI-6202 :)
18:23 <@sdumitriu> Denis: An update on Dirk's problem: There were a few broken versions in xwikircs related to Scheduler.WatchlistDailyNotifier that triggered the R35102 migrator
18:24 <@sdumitriu> I assume that those versions were created when Dirk tried to upgrade this instance before, since they're all consecutive versions between 20 and 21 February
18:24 <+AndreasJonsson> vmassol: I had forgotten that one. :)  I'll have a look at it.
18:24 <@sdumitriu> I reset the history of that document, hoping that the upgrade will go smoothly from now on
18:24 <vmassol> cool :)
18:25 <vmassol> just finished setting the status on all issues with patches
18:25 <vmassol> and just sent an email about it
18:25 <vmassol> http://jira.xwiki.org/secure/Dashboard.jspa?selectPageId=10000#Issue-Statistics/10472
18:25 <@sdumitriu> I still have no idea why the permission error was raised, that doesn't look like a normal behavior
18:27 <sburjan`> has joined #xwiki
18:40 <sdumitriu> has quit
18:42 <dirk_schmitt> sdimitru: The migration seems to run a bit longer - but fails :-/
18:42 <dirk_schmitt> --> http://www.computer42.org/~dirk/tmp/18_40-catalina.out
18:42 <+Denis> dirk_schmitt: that one is for me ;)
18:43 <dirk_schmitt> Great :-)
18:44 <+Denis> dirk_schmitt: I think you are facing the following issue: http://jira.xwiki.org/browse/XWIKI-8129
18:48 <dirk_schmitt> Anybody around who can translate the sql statemin in XWIKI-8129 to postgres dialext ?
18:55 <+Denis> vmassol: sorry, I was out of the office, seems you sort it out yourself
18:55 <vmassol> Denis: what part?
18:55 <+Denis> qualifying patches
18:55 <vmassol> ah yes
18:56 <vmassol> there are quite a few there written by you….
18:56 <+Denis> yes I know
18:57 <+Denis> and some are awaiting sergiu attention for a while :)
18:58 <vmassol> ah we don't have a status for "awaiting sergiu's attention" :)
19:04 <+Denis> could not this be added ? it would be more used than future, no ? :D
19:11 <vmassol> has quit
19:17 <sdumitriu> has joined #xwiki
19:18 <@sdumitriu> dirk_schmitt: Back, any progress?
19:24 <coud5> has joined #xwiki
19:26 <Slashman> has quit
19:35 <abusenius> has joined #xwiki
19:41 <vmassol> has joined #xwiki
19:53 <vmassol> has quit
20:01 <technickal_nick> has joined #xwiki
20:03 <dirk_schmitt> Next round: http://www.computer42.org/~dirk/tmp/20_01-catalina.out
20:04 <dirk_schmitt> For http://jira.xwiki.org/browse/XWIKI-8129 I have added the sql statement compatible with postgresql.
20:15 <@sdumitriu> Hm, another weird result...
20:17 <vmassol> has joined #xwiki
20:18 <@sdumitriu> OK, I know what's causing that
20:18 <@sdumitriu> Did you remember to drop the databasechangelog table?
20:19 <@sdumitriu> DATABASECHANGELOG and DATABASECHANGELOGLOCK
20:19 <dirk_schmitt> No - I will do it now ;-)
20:20 <@sdumitriu> Denis: We probably shouldn't use this.logCount++ in the migrator, since that's not a stable indicator
20:21 <@sdumitriu> We should use a more stable way of constructing changelog identifiers, like append table names
20:30 <vmassol> has quit
20:32 <dirk_schmitt> Is this o.k. ?
20:33 <dirk_schmitt> has quit
20:36 <dirk42> has joined #xwiki
20:40 <dirk42> dirk42=dirk_schmitt, back again :-)
20:46 <mflorea> has quit
20:47 <+Denis> sdumitriu: this is not really an issue, the problem is that the DB of dirk contains an older version of the schema update
20:48 <+sburjan`> maybe the notion of migrator is not enough. we might some sanitazor
20:48 <+Denis> so even with more stable ids, it will fails the same way, since we have changed the executed schema updates
20:49 <+sburjan`> I wonder if clearing the stas table will provide a deecent solution to these problems. Maybe users don't care that much about stats
20:49 <@sdumitriu> sburjan`: I don't agree, some users care a lot about stats
20:49 <+Denis> sburjan`: we cannot manage a migration starting from anything and arriving to the good thing, there is a minimum to be expect from the xwiki  administrator
20:51 <+Denis> regarding the stats, I agree that we may do something about it. The reason I have not is that I do not know the right SQL to be used for each DBs
20:51 <dirk42> next round: https://www.computer42.org/~dirk/tmp/20_20-catalina.out
20:53 <@sdumitriu> Another stats problem
20:54 <@sdumitriu> This time not in xwikistatsdoc, but in xwikistatsreferer
20:54 <@sdumitriu> So run the same SQL to fix stats for the xwikistatsreferer table
20:54 <dirk42> Denis: The SQL I added to the issue seems to be compliant to the sql standard. Maybe this works.
20:54 <dirk42> I think performance is not important on database migration, because this is (hopefully) a one time action.
20:55 <+Denis> dirk42: you need to execute on the 3 tables as explained in the JIRA issue
20:55 <vmassol> has joined #xwiki
20:55 <@sdumitriu> And xwikistatsvisit as well
20:56 <+Denis> dirk42: the same SQL on mysql with a large number of stats, and it could be very large, cause many hours of processing (almost endless from the user point of view), so I cannot put that in the migration automatically
20:56 <+Denis> dirk42: we may have a farm of thousand of wikis to migrate !
20:57 <+Denis> dirk42: not need to start over after your cleanup, it should continue where it left over
21:07 <vmassol> has quit
21:17 <dirk42> O.k. but as a temporary solution it would good to provide a log message pointing to the issue  and the workaround.
21:19 <dirk42> BTW: The column prefix is different in each table.  I have add the "full" script to http://jira.xwiki.org/browse/XWIKI-8129
21:27 <cdop> has quit
21:27 <vmassol> has joined #xwiki
21:42 <+Denis> dirk42: thanks, I have also update the MySQL script
21:43 <+Denis> dirk42: is your migration ok now ?
21:47 <+Denis> sdumitriu: thanks for the catch, it is already late here ;)
21:59 <dirk42> :-) The migration has come to a end. Thank you all for your excellent help.
22:00 <mrvanes> has quit
23:00 <technickal_nick> has quit
23:01 <abusenius> has quit
23:04 <vmassol> has quit
23:15 <dirk42> has left #xwiki
23:34 <coud5> has quit
23:34 <vmassol> has joined #xwiki
23:39 <vmassol> has quit