[1.1Milestone1] Importing a large .xar file
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
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
:-) 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:[email protected]] Sent: jeudi 7 juin 2007 13:59 To: [email protected] 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
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
-----Original Message----- From: Arnaud Bourree [mailto:[email protected]] Sent: jeudi 7 juin 2007 13:59 To: [email protected] 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
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:[email protected]] Sent: jeudi 7 juin 2007 13:59 To: [email protected] 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
-- You receive this message as a subscriber of the xwiki- [email protected] mailing list. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/ wws
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:[email protected]] Sent: vendredi 8 juin 2007 12:09 To: [email protected] 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:[email protected]] Sent: jeudi 7 juin 2007 13:59 To: [email protected] 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
-- You receive this message as a subscriber of the xwiki- [email protected] mailing list. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/ wws
participants (3)
-
Arnaud Bourree -
BOUSQUET Jeremie -
Vincent Massol