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

["Bührle, Martin, FCI1"]

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(CmsElementCache
.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(Application
FilterChain.java:247)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:243)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(C
ompiled Code))
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Compi
led Code))
	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
Code))
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:201)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(C
ompiled Code))
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Compi
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:164
)
	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:170
)
	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(Compi
led Code))
	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
Code))
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:163)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(C
ompiled Code))
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Compi
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:1106
)
	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(Comp
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(CmsElementCache
.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(Application
FilterChain.java:247)
>	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
>	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:243)
>	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(C
ompiled Code))
>	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Compi
led Code))
>	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
Code))
>	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:201)
>	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(C
ompiled Code))
>	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Compi
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:164
)
>	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:170
)
>	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(Compi
led Code))
>	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
Code))
>	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:163)
>	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(C
ompiled Code))
>	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Compi
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:1106
)
>	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(Comp
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(CmsElementCache
.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(Application
FilterChain.java:247)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:243)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(C
ompiled Code))
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Compi
led Code))
	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
Code))
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:201)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(C
ompiled Code))
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Compi
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:164
)
	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:170
)
	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(Compi
led Code))
	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
Code))
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:163)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java(C
ompiled Code))
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Compi
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:1106
)
	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
_________________________________________________________________________