An alternative is to export the pages in chunks. Install the 
ImportExport application, which allows to select which pages to export, 
and only select a few pages at a time, keeping the size of the 
attachments smaller. Then, import each archive one by one.

The best option, however, is to install mysql and import the sql dump.

Ajdin Brandic wrote:
> Sergiu
> 
> Xwiki would not start with heap size more than 1.6gb, I've attempted
> this.
> I'll try the other option you've suggested although I do not know how to
> load sql dump into HSQLDB? I've you have any suggestions please advise.
> 
> I searched web for 2 days looking for answers to this question and all I
> found was JAVA_OPTS and CATALINA_OPTS suggestions.  I have not seen any
> ware your comment on "handling attachment consumes about 27 time the
> size of the attachment".  It was probably some ware out there but I
> missed it.

That mail was pretty old. Only the conclusion is relevant to this topic, 
the huge memory requirement.

> Maybe you should include it on the Import/Export page
> http://platform.xwiki.org/xwiki/bin/view/AdminGuide/ImportExport
> 
> Thank you for your response, at least I know where the issue is.
> 
> Ajdin
> 
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
> Of Sergiu Dumitriu
> Sent: 05 December 2008 10:14
> To: XWiki Users
> Subject: Re: [xwiki-users] Java Heap Space, Out of memory exception
> 
> Ajdin Brandic wrote:
>> Hi All
>>  
>> I am having a problem uploading a xar file.  I get "Java Heap Space, 
>> Out of memory exception" (full message below).
>>  
>> I've downloaded the latest version of XWiki for windows xp (beginner's
> 
>> version with HSQLDB & Jetty).
>>  
>> In my start_xwiki.bat I have set "set JAVA_OPTS=-Xmx1600m -Xms512m".
>> 1.6gb is the maximum as xwiki would not start if I go over this. 
>>  
>> I don't think I have CATALINA.bat any ware so I din not find where to 
>> set CATALINA_OPTS.
>>  
>> I have changed file upload size to 133MB by going to 
>> http://localhost:8080/xwiki/bin/edit/XWiki/XWikiPreferences?editor=obj
>> ec t  and changing Maximum Upload Size:.
>>  
>> The .xar file is 90MB downloaded as backup from 
>> http://patternlanguagenetwork.myxwiki.org/xwiki/bin/view/Main/WebHome.
>> I do not know what version this runs on since it is on one of the 
>> xwiki farm things :-).
>>  
>> I have Win XP with 3.5gb memory available.
>>
>> Has anyone had this error recently?
>>  
> 
> This is a major design flaw of the current attachment storage model. As
> stated in a previous mail, handling attachment consumes about 27 time
> the size of the attachment, so 90M * 27 ~= 2.5G. This needs to be fixed
> ASAP. In the meantime, you can either increase the heap size to more
> than 2.5G, or request an sql dump from the myxwiki farm admins.
> 


-- 
Sergiu Dumitriu
http://purl.org/net/sergiu/
_______________________________________________
users mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/users

Reply via email to