[1.1Milestone1] Importing a large .xar file

List overview All Threads
Download

newer

older

Private Wiki with token

Doubt regarding search

BOUSQUET Jeremie

7 Jun 2007 7 Jun '07

12:32 p.m.

Hello, I'm trying to migrate from xwiki 1.0 to 1.1.milestone 1 engine using the export/import feature. I'm configured to use a MySQL database on both sides. My exported .xar file is about 60Mo. I managed to go through following errors: - limit of 10Mo from XWiki as attachment size - limit of 1Mo as packet max size for MySQL Now I'm getting the following error while trying to attach the Backup.xar file in my new wiki instance: "java.sql.BatchUpdateException: Data truncation: Data truncated for column 'XWA_CONTENT' at row 1" Any ideas ? The .xar file do not get correctly attached after this. Best regards, Jérémie

Attachments:

attachment.html (text/html — 2.0 KB)

Show replies by date

Arnaud Bourree

7 Jun 7 Jun

1:58 p.m.

New subject: [xwiki-users] [1.1Milestone1] Importing a large .xar file

Hello, Could I suggest you to split your XAR? Regards, Arnaud. BOUSQUET Jeremie wrote on 07/06/2007 12:32:

...

BOUSQUET Jeremie

5:27 p.m.

New subject: [xwiki-users] [1.1Milestone1] Importing a large .xar file

:-) In fact the XWA_CONTENT problem is due MEDIUMBLOB type used in xwikiattachment_content and xwikiattachment_archive tables, I think. Anyway I tried splitting the .xar, but I sometimes get some strange errors (premature EOF from XML parser for example). I also have a page containing 17Mo of files attachments --> impossible to get this through because with MEDIUMBLOB I'm limited to 16Mo whatever other limitations (if I'm right of course). I wanted to make this migration properly using .xar features, and not through a brutal SQL dump, but finally it's not that easy. Regards, Jérémie

...

-----Original Message----- From: Arnaud Bourree [mailto:arnaud.bourree@gemalto.com] Sent: jeudi 7 juin 2007 13:59 To: xwiki-users(a)objectweb.org Subject: Re: [xwiki-users] [1.1Milestone1] Importing a large .xar file Hello, Could I suggest you to split your XAR? Regards, Arnaud. BOUSQUET Jeremie wrote on 07/06/2007 12:32:

Hello, I'm trying to migrate from xwiki 1.0 to 1.1.milestone 1

engine using

the export/import feature. I'm configured to use a MySQL

database on

both sides. My exported .xar file is about 60Mo. I managed to go

through following

errors: - limit of 10Mo from XWiki as attachment size - limit of 1Mo as packet max size for MySQL Now I'm getting the following error while trying to attach the Backup.xar file in my new wiki instance: "java.sql.BatchUpdateException: Data truncation: Data truncated for column 'XWA_CONTENT' at row 1" Any ideas ? The .xar file do not get correctly attached after this. Best regards, Jérémie

BOUSQUET Jeremie

7:01 p.m.

New subject: [xwiki-users] [1.1Milestone1] Importing a large .xar file

Hi, To sum up, the main problem, in my opinion, with import feature : sometimes some pages make the import process fail. If you remove the page(s) that make things fail, then it's ok. The big problem is : you don't known which page(s) make import fails ... So I have to split the .xar into small xars, and then try to locate the page(s) with incorrect data ... This process is very long : it would be very helpful to display the page on which import process fails. Regards, Jérémie

...

Hello, I'm trying to migrate from xwiki 1.0 to 1.1.milestone 1

engine using

the export/import feature. I'm configured to use a MySQL

database on

both sides. My exported .xar file is about 60Mo. I managed to go

through following

Vincent Massol

8 Jun 8 Jun

12:09 p.m.

New subject: [xwiki-users] [1.1Milestone1] Importing a large .xar file

Hi Jeremie, On Jun 7, 2007, at 7:01 PM, BOUSQUET Jeremie wrote:

...

Hi, To sum up, the main problem, in my opinion, with import feature : sometimes some pages make the import process fail. If you remove the page(s) that make things fail, then it's ok.

Yes this is true. We have a jira issue opened for this. Just need a patch...

...

The big problem is : you don't known which page(s) make import fails ... So I have to split the .xar into small xars, and then try to locate the page(s) with incorrect data ... This process is very long : it would be very helpful to display the page on which import process fails.

I completely agree, we need something better. Any help is most welcome. Thanks -Vincent

...

Hello, I'm trying to migrate from xwiki 1.0 to 1.1.milestone 1

engine using

the export/import feature. I'm configured to use a MySQL

database on

both sides. My exported .xar file is about 60Mo. I managed to go

through following

-- You receive this message as a subscriber of the xwiki- users(a)objectweb.org mailing list. To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/ wws

BOUSQUET Jeremie

1:38 p.m.

New subject: [xwiki-users] [1.1Milestone1] Importing a large .xar file

Hi Vincent, Thanks for your answer, and sorry for not having checked the jira db before ... :-) I would love having time to help you, really ... ;) What is missing could be an export / import result status, because meanwhile I found that some pages failed to be exported too, with no clear message ... (result is just 0 sized files in .xar) Regards Jeremie

...

-----Original Message----- From: Vincent Massol [mailto:vincent@massol.net] Sent: vendredi 8 juin 2007 12:09 To: xwiki-users(a)objectweb.org Subject: Re: [xwiki-users] [1.1Milestone1] Importing a large .xar file Hi Jeremie, On Jun 7, 2007, at 7:01 PM, BOUSQUET Jeremie wrote:

Hi, To sum up, the main problem, in my opinion, with import feature : sometimes some pages make the import process fail. If you

remove the

page(s) that make things fail, then it's ok.

Yes this is true. We have a jira issue opened for this. Just need a patch...

The big problem is : you don't known which page(s) make

import fails

... So I have to split the .xar into small xars, and then try to locate the page(s) with incorrect data ... This process is

very long :

it would be very helpful to display the page on which

import process

fails.

I completely agree, we need something better. Any help is most welcome. Thanks -Vincent

> -----Original Message----- > From: Arnaud Bourree [mailto:arnaud.bourree@gemalto.com] > Sent: jeudi 7 juin 2007 13:59 > To: xwiki-users(a)objectweb.org > Subject: Re: [xwiki-users] [1.1Milestone1] Importing a large .xar > file > > Hello, > > Could I suggest you to split your XAR? > > Regards, > > Arnaud. > > BOUSQUET Jeremie wrote on 07/06/2007 12:32: >> Hello, >> >> I'm trying to migrate from xwiki 1.0 to 1.1.milestone 1 > engine using >> the export/import feature. I'm configured to use a MySQL > database on >> both sides. >> >> My exported .xar file is about 60Mo. I managed to go > through following >> errors: >> - limit of 10Mo from XWiki as attachment size >> - limit of 1Mo as packet max size for MySQL >> >> Now I'm getting the following error while trying to attach the >> Backup.xar file in my new wiki instance: >> "java.sql.BatchUpdateException: Data truncation: Data

truncated for

>> column 'XWA_CONTENT' at row 1" >> Any ideas ? The .xar file do not get correctly attached

after this.

Best regards, Jérémie

http://www.objectweb.org/

wws

6310

days inactive

6311

days old

xwiki-users@xwiki.org

Manage subscription

5 comments

3 participants

tags (0)

participants (3)

Arnaud Bourree
BOUSQUET Jeremie
Vincent Massol