AW: [opencms-dev] max_allowed_packet - error in OpenCMS 4.6.1 wit h file-uploading

"Bührle, Martin, FCI1" martin.buehrle at lfk.eads.net
Sat Jun 8 12:28:22 CEST 2002 

Stephan,
thanks for Your answer.

Has this to do with the /pics/ and /downloads/ - configuration-settings in
opencms.properties?
(dynamic or static download-location) Or how ca I change this behavior?
Anyway OpenCMS reports in the error-message (popup) that a maximum of
67108864 (64m) is allowed.


Gruesse
 Martin Buehrle

_________________________________________________________________________
Martin Buehrle, FCI1
EADS - European Aeronautic Defence and Space Company
Postfach 1661
85705 UNTERSCHLEISSHEIM
Telefax: +49 89 3179-8927
eMail: Martin.Buehrle at lfk.eads.net
_________________________________________________________________________



> -----Ursprüngliche Nachricht-----
> Von:	Stephan Hartmann [SMTP:beffe at beffe.de]
> Gesendet am:	Samstag, 8. Juni 2002 10:54
> An:	opencms-dev at www.opencms.org
> Betreff:	Re: [opencms-dev] max_allowed_packet - error in OpenCMS
> 4.6.1 with file-uploading
> 
> Well, if the files are stored in table CMS_FILES, then the size is
> limited to 16MB (unless they are split) because mediumblob is used for
> field FILE_CONTENT. 
> 
> bye,
> Stephan
> 
> 
> Am Fre, 2002-06-07 um 19.03 schrieb "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(CmsElementCac
> he
> > ..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(Applicati
> on
> > FilterChain.java:247)
> > 	at
> >
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilter
> Ch
> > 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(Com
> pi
> > 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(Com
> pi
> > 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:1
> 64
> > )
> > 	at
> >
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> (C
> > ompiled Code))
> > 	at
> >
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValv
> e.
> > java:170)
> > 	at
> >
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> (C
> > ompiled Code))
> > 	at
> >
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:1
> 70
> > )
> > 	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(Com
> pi
> > led Code))
> > 	at
> >
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
> > Code))
> > 	at
> >
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.ja
> va
> > :163)
> > 	at
> >
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> (C
> > ompiled Code))
> > 	at
> >
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Com
> pi
> > led Code))
> > 	at
> >
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
> > Code))
> > 	at
> >
> org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.jav
> a:
> > 1011)
> > 	at
> >
> org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:11
> 06
> > )
> > 	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(Co
> mp
> > 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(CmsResourceTypeBinar
> y.
> > 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(CmsElementCac
> he
> > ..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(Applicati
> on
> > FilterChain.java:247)
> > >	at
> >
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilter
> Ch
> > 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(Com
> pi
> > 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(Com
> pi
> > 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:1
> 64
> > )
> > >	at
> >
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> (C
> > ompiled Code))
> > >	at
> >
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValv
> e.
> > java:170)
> > >	at
> >
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> (C
> > ompiled Code))
> > >	at
> >
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:1
> 70
> > )
> > >	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(Com
> pi
> > led Code))
> > >	at
> >
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
> > Code))
> > >	at
> >
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.ja
> va
> > :163)
> > >	at
> >
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> (C
> > ompiled Code))
> > >	at
> >
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Com
> pi
> > led Code))
> > >	at
> >
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
> > Code))
> > >	at
> >
> org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.jav
> a:
> > 1011)
> > >	at
> >
> org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:11
> 06
> > )
> > >	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(Co
> mp
> > 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(CmsResourceTypeBinar
> y.
> > 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(CmsElementCac
> he
> > ..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(Applicati
> on
> > FilterChain.java:247)
> > 	at
> >
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilter
> Ch
> > 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(Com
> pi
> > 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(Com
> pi
> > 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:1
> 64
> > )
> > 	at
> >
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> (C
> > ompiled Code))
> > 	at
> >
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValv
> e.
> > java:170)
> > 	at
> >
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> (C
> > ompiled Code))
> > 	at
> >
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:1
> 70
> > )
> > 	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(Com
> pi
> > led Code))
> > 	at
> >
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
> > Code))
> > 	at
> >
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.ja
> va
> > :163)
> > 	at
> >
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java
> (C
> > ompiled Code))
> > 	at
> >
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java(Com
> pi
> > led Code))
> > 	at
> >
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java(Compiled
> > Code))
> > 	at
> >
> org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.jav
> a:
> > 1011)
> > 	at
> >
> org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:11
> 06
> > )
> > 	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
> >
> _________________________________________________________________________
> > 
> > 
> > 
>

More information about the opencms-dev mailing list