[opencms-dev] max_allowed_packet - error in OpenCMS 4.6.1 with file-uploading

Stephan Hartmann hartmann at waehrisch-feykes.de
Mon Jun 10 14:54:33 CEST 2002 

Hi Martin,

the MySQL manual says that "the current protocol limits max_allowed_packet to 
16M".

Bye,
Stephan

Am Freitag,  7. Juni 2002 19:03 schrieben Sie:
> Hi List,
>
>
> I had the same problem with opencms 4.4.6 with a 8MByte-Limit before.
>
> There was a promise, that the limit will be fixed with opencms 4.6
>
> Problem:
> I get a file-upload-error when uploading a file with a size of 52.329 kByte
> (ZIP, but no unpacking), although it worked when I uncheck the "ZIP file
> unpacking" - option (different JPEGs).
>
> OpenCMS reports to me, that in the server-configuration there is set a max.
> limit of 64MByte for file-uploading with max_allowed_packet.
> I have set this variable to 512MByte in my.cnf under mySQL-configuration
> (running on linux 7.3prof) before, but opencms dont care about this.
> We have two different opencms-instances running on this database, but this
> should not be the problem in this case.
>
>
> What am I doing wrong?
> What parameter do I have to change to upload this huge files?
>
>
>
> Here is the error-log:
> ===========================================================================
>0 [CmsException]: 0 Unknown exception. Detailed Error: NO MESSAGE. Caught
> Exception: >java.lang.IllegalArgumentException: Packet is larger than
> max_allowed_packet from server configuration of 67107840 bytes<
> 	at
> com.opencms.template.cache.CmsElementXml.getContent(CmsElementXml.java:192)
> 	at
> com.opencms.template.cache.CmsUri.callCanonicalRoot(CmsUri.java:169)
> 	at
> com.opencms.template.cache.CmsElementCache.callCanonicalRoot(CmsElementCach
>e ..java:148)
> 	at
> com.opencms.launcher.CmsXmlLauncher.generateOutput(CmsXmlLauncher.java:228)
> 	at
> com.opencms.launcher.CmsXmlLauncher.launch(CmsXmlLauncher.java:283)
> 	at
> com.opencms.launcher.A_CmsLauncher.initlaunch(A_CmsLauncher.java:272)
> 	at com.opencms.core.OpenCms.showResource(OpenCms.java:588)
> 	at
> com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:223)
> 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> 	at com.opencms.boot.OpenCmsServlet.service(OpenCmsServlet.java:117)
> 	at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio
>n FilterChain.java:247)
> 	at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC
>h ain.java:193)
> 	at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j
>a va:243)
> 	at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(
>C ompiled Code))
> 	at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Comp
>i led Code))
> 	at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
> Code))
> 	at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.j
>a va:201)
> 	at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(
>C ompiled Code))
> 	at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Comp
>i led Code))
> 	at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
> Code))
> 	at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2344)
> 	at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:16
>4 )
> 	at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(
>C ompiled Code))
> 	at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve
>. java:170)
> 	at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(
>C ompiled Code))
> 	at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:17
>0 )
> 	at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(
>C ompiled Code))
> 	at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462)
> 	at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(
>C ompiled Code))
> 	at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Comp
>i led Code))
> 	at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
> Code))
> 	at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.jav
>a
>
> :163)
>
> 	at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(
>C ompiled Code))
> 	at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Comp
>i led Code))
> 	at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
> Code))
> 	at
> org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java
>: 1011)
> 	at
> org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:110
>6 )
> 	at java.lang.Thread.run(Thread.java:498)
>
> >java.lang.IllegalArgumentException: Packet is larger than
>
> max_allowed_packet from server configuration of 67107840 bytes
>
> >	at org.gjt.mm.mysql.Buffer.ensureCapacity(Buffer.java(Compiled
>
> Code))
>
> >	at org.gjt.mm.mysql.Buffer.writeBytesNoNull(Buffer.java(Compiled
>
> Code))
>
> >	at
>
> org.gjt.mm.mysql.PreparedStatement.executeUpdate(PreparedStatement.java(Com
>p iled Code))
>
> >	at
>
> com.opencms.dbpool.CmsPreparedStatement.executeUpdate(CmsPreparedStatement.
>j ava:170)
>
> >	at
>
> com.opencms.file.mySql.CmsDbAccess.createFile(CmsDbAccess.java:299)
>
> >	at
>
> com.opencms.file.genericSql.CmsResourceBroker.createFile(CmsResourceBroker.
>j ava:1720)
>
> >	at com.opencms.file.CmsObject.doCreateFile(CmsObject.java:935)
> >	at
>
> com.opencms.file.CmsResourceTypeBinary.createResource(CmsResourceTypeBinary
>. java:46)
>
> >	at com.opencms.file.CmsObject.createResource(CmsObject.java:891)
> >	at
>
> com.opencms.workplace.CmsNewResourceUpload.getContent(CmsNewResourceUpload.
>j ava:203)
>
> >	at
>
> com.opencms.template.cache.CmsElementXml.getContent(CmsElementXml.java:169)
>
> >	at
>
> com.opencms.template.cache.CmsUri.callCanonicalRoot(CmsUri.java:169)
>
> >	at
>
> com.opencms.template.cache.CmsElementCache.callCanonicalRoot(CmsElementCach
>e ..java:148)
>
> >	at
>
> com.opencms.launcher.CmsXmlLauncher.generateOutput(CmsXmlLauncher.java:228)
>
> >	at
>
> com.opencms.launcher.CmsXmlLauncher.launch(CmsXmlLauncher.java:283)
>
> >	at
>
> com.opencms.launcher.A_CmsLauncher.initlaunch(A_CmsLauncher.java:272)
>
> >	at com.opencms.core.OpenCms.showResource(OpenCms.java:588)
> >	at
>
> com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:223)
>
> >	at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> >	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> >	at com.opencms.boot.OpenCmsServlet.service(OpenCmsServlet.java:117)
> >	at
>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio
>n FilterChain.java:247)
>
> >	at
>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC
>h ain.java:193)
>
> >	at
>
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j
>a va:243)
>
> >	at
>
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(
>C ompiled Code))
>
> >	at
>
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Comp
>i led Code))
>
> >	at
>
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
> Code))
>
> >	at
>
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.j
>a va:201)
>
> >	at
>
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(
>C ompiled Code))
>
> >	at
>
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Comp
>i led Code))
>
> >	at
>
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
> Code))
>
> >	at
>
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2344)
>
> >	at
>
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:16
>4 )
>
> >	at
>
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(
>C ompiled Code))
>
> >	at
>
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve
>. java:170)
>
> >	at
>
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(
>C ompiled Code))
>
> >	at
>
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:17
>0 )
>
> >	at
>
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(
>C ompiled Code))
>
> >	at
>
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462)
>
> >	at
>
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(
>C ompiled Code))
>
> >	at
>
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Comp
>i led Code))
>
> >	at
>
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
> Code))
>
> >	at
>
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.jav
>a
>
> :163)
> :
> >	at
>
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(
>C ompiled Code))
>
> >	at
>
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Comp
>i led Code))
>
> >	at
>
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
> Code))
>
> >	at
>
> org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java
>: 1011)
>
> >	at
>
> org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:110
>6 )
>
> >	at java.lang.Thread.run(Thread.java:498)
>
> java.lang.IllegalArgumentException: Packet is larger than
> max_allowed_packet from server configuration of 67107840 bytes
> 	at org.gjt.mm.mysql.Buffer.ensureCapacity(Buffer.java(Compiled
> Code))
> 	at org.gjt.mm.mysql.Buffer.writeBytesNoNull(Buffer.java(Compiled
> Code))
> 	at
> org.gjt.mm.mysql.PreparedStatement.executeUpdate(PreparedStatement.java(Com
>p iled Code))
> 	at
> com.opencms.dbpool.CmsPreparedStatement.executeUpdate(CmsPreparedStatement.
>j ava:170)
> 	at
> com.opencms.file.mySql.CmsDbAccess.createFile(CmsDbAccess.java:299)
> 	at
> com.opencms.file.genericSql.CmsResourceBroker.createFile(CmsResourceBroker.
>j ava:1720)
> 	at com.opencms.file.CmsObject.doCreateFile(CmsObject.java:935)
> 	at
> com.opencms.file.CmsResourceTypeBinary.createResource(CmsResourceTypeBinary
>. java:46)
> 	at com.opencms.file.CmsObject.createResource(CmsObject.java:891)
> 	at
> com.opencms.workplace.CmsNewResourceUpload.getContent(CmsNewResourceUpload.
>j ava:203)
> 	at
> com.opencms.template.cache.CmsElementXml.getContent(CmsElementXml.java:169)
> 	at
> com.opencms.template.cache.CmsUri.callCanonicalRoot(CmsUri.java:169)
> 	at
> com.opencms.template.cache.CmsElementCache.callCanonicalRoot(CmsElementCach
>e ..java:148)
> 	at
> com.opencms.launcher.CmsXmlLauncher.generateOutput(CmsXmlLauncher.java:228)
> 	at
> com.opencms.launcher.CmsXmlLauncher.launch(CmsXmlLauncher.java:283)
> 	at
> com.opencms.launcher.A_CmsLauncher.initlaunch(A_CmsLauncher.java:272)
> 	at com.opencms.core.OpenCms.showResource(OpenCms.java:588)
> 	at
> com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:223)
> 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> 	at com.opencms.boot.OpenCmsServlet.service(OpenCmsServlet.java:117)
> 	at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio
>n FilterChain.java:247)
> 	at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC
>h ain.java:193)
> 	at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j
>a va:243)
> 	at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(
>C ompiled Code))
> 	at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Comp
>i led Code))
> 	at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
> Code))
> 	at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.j
>a va:201)
> 	at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(
>C ompiled Code))
> 	at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Comp
>i led Code))
> 	at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
> Code))
> 	at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2344)
> 	at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:16
>4 )
> 	at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(
>C ompiled Code))
> 	at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve
>. java:170)
> 	at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(
>C ompiled Code))
> 	at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:17
>0 )
> 	at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(
>C ompiled Code))
> 	at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462)
> 	at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(
>C ompiled Code))
> 	at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Comp
>i led Code))
> 	at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
> Code))
> 	at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.jav
>a
>
> :163)
>
> 	at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(
>C ompiled Code))
> 	at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Comp
>i led Code))
> 	at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
> Code))
> 	at
> org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java
>: 1011)
> 	at
> org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:110
>6 )
> 	at java.lang.Thread.run(Thread.java:498)
> ===========================================================================
>= =0
>
>
>
> Gruesse
>  Martin Buehrle
>
> _________________________________________________________________________
> Martin Buehrle, FCI1
> EADS - European Aeronautic Defence and Space Company
> LFK-Lenkflugkoerpersysteme GmbH
> Postfach 1661
> 85705 UNTERSCHLEISSHEIM
> Telefax: +49 89 3179-8927
> eMail: Martin.Buehrle at lfk.eads.net
> _________________________________________________________________________

-- 
Stephan Hartmann

Währisch & Feykes GmbH
Gustav-Adolf-Str. 5
47057 Duisburg
Tel. 0203 / 373 070
Fax 0203 / 376 766
hartmann at wfnetz.de

------------------------------------------------------
Ausschlusserklärung (Disclaimer):
Über das Internet versandte E-mails können unter fremden Namen erstellt oder 
manipuliert werden. Aus diesem Grund enthalten unsere mit E-mail verschickten 
Nachrichten grundsätzlich keine rechtsverbindlichen Willenserklärungen.

More information about the opencms-dev mailing list