[opencms-dev] Large files upload fails

[Paul-Inge Flakstad]

Thanks for the reply, Marc. 

First, a correction: My previous mail said "max_upload_packet", which was a typo - it should've said "max_allowed_packet". It is set to 64M so I should have that case covered. 

I tried uploading files of various sizes yesterday, and it is pretty clear that there's some kind of ceiling at 16MB. All is well for files <16MB, but files that exceed 16MB (e.g. PDF files) cause problems.

Any other ideas? I read a post somewhere where someone suggested changing a MySQL field definition from (MEDIUM)BLOB to LONGBLOB - could that be it (sounds pretty awkward)?

-Paul

> -----Original Message-----
> From: opencms-dev-bounces at opencms.org 
> [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Marc Johnen
> Sent: 25. juni 2009 12:01
> To: opencms-dev at opencms.org
> Subject: Re: [opencms-dev] Large files upload fails
> 
> 
> Hi Paul,
> yes you could have found the solution by searching in the mailing list
> first.
> This is probably connected to the max_allowed_packet property 
> of MySql.
> Also I'd remove the "-Xms8m" from your config, because it 
> potentially create
> problems, but not related to uploading.
> Greetings
> Marc Johnen
> 
> 
> 
> Paul-Inge Flakstad wrote:
> > 
> > Hi all
> > 
> > I'm pretty sure this question is asked on a regular basis 
> in here, and my
> > apologies for asking it again. I just couldn't find any solution.
> > 
> > OpenCms misbehaves when I try to upload large files. One of 
> two scenarios
> > occur: either 1.) The upload applet closes and no file is 
> visible in the
> > workplace, or 2.) The upload applet closes and the file is 
> visible in the
> > workplace, but a CmsVfsResourceNotFoundException is thrown 
> when I try to
> > view the file.
> > 
> > No exception is thrown during the applet upload. If I 
> disable "Use upload
> > applet", a CmsVfsResourceNotFoundException is thrown.
> > 
> > Now, I've set/checked some values to try and fix the problem:
> > 
> > 1.) In my.cnf: max_upload_packet=64M
> > 2.) In opencms-workplace.xml: 
> <maxfileuploadsize>-1</maxfileuploadsize>
> > 3.) In catalina.bat: CATALINA_OPTS="-Xmx256m -Xms8m"
> > 
> > After changing to this, an upload of a 2.7MB .pdf file worked (which
> > didn't work prior to the change), but I still can't upload 
> a 16.0MB .pdf
> > file... Is there anything else I need to check?
> > 
> > Any solution, tip or idea is most welcome.
> > 
> > Cheers,
> > Paul
> > 
> > 
> > _______________________________________________
> > This mail is sent to you from the opencms-dev mailing list
> > To change your list options, or to unsubscribe from the 
> list, please visit
> > http://lists.opencms.org/mailman/listinfo/opencms-dev
> > 
> 
> -- 
> View this message in context: 
> http://www.nabble.com/Large-files-upload-fails-tp24187053p2420
0400.html
> Sent from the OpenCMS - Dev mailing list archive at Nabble.com.
> 
> 
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, 
> please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
>