[opencms-dev] Please help to upload file>16MB

[Stephan Hartmann]

Hi Rafael,

if you are using MySql 3.x, this is the limit. Only MySql 4.0.1 and up
support a packet size greater than 16MB.

Regards,
Stephan

----- Original Message -----
From: "Rafael Diaz Valdes" <Rafael.Diaz.Valdes at cern.ch>
To: <opencms-dev at opencms.org>
Sent: Thursday, March 03, 2005 12:38 PM
Subject: [opencms-dev] Please help to upload file>16MB


> Hi list
> Please I need help, I want to upload a file with size> 16M, i made the
following changes in my configuration:
>
> mysql (my.cnf)
> [mysqld]
> max_allowed_packet=512M
> key_buffer_size=512M
>
> also i put the JAVA_OPTS
>
> JAVA_OPTS = "-Xmx1024m -Xms512m"
>
> In the workplace the first step to upload the files is finished but when
you select the file type the process never end, after that  i have to close
the section and login again, then I can find the file in the wokplace but
when you click on it this is the error:
> *************************************************************
>
> com.opencms.core.CmsException: 4 Sql exception. Detailed error:
[com.opencms.file.mySql.CmsDbAccess] Error during query: Unexpected
Exception: java.lang.IndexOutOfBoundsException message given: null
> Nested Stack Trace:
>
> ** BEGIN NESTED EXCEPTION **
> java.lang.IndexOutOfBoundsException
> STACKTRACE:
> java.lang.IndexOutOfBoundsException
>  at java.io.BufferedInputStream.read(BufferedInputStream.java:272)
>  at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1058)
>  at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1374)
>  at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:705)
>  at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:263)
>  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:985)
>  at com.mysql.jdbc.Connection.execSQL(Connection.java:1844)
>  at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1458)
>  at
com.opencms.dbpool.CmsPreparedStatement.executeQuery(CmsPreparedStatement.ja
va:173)
>  at com.opencms.file.mySql.CmsDbAccess.readFile(CmsDbAccess.java:674)
>  at
com.opencms.file.genericSql.CmsResourceBroker.readFile(CmsResourceBroker.jav
a:5203)
>  at com.opencms.file.CmsObject.readFile(CmsObject.java:2888)
>  at com.opencms.core.OpenCms.initResource(OpenCms.java:793)
>  at com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:306)
>  at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
>  at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>  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:256)
>  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
>  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>  at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
>  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
>  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>  at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
>  at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
>  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
>  at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
>  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
>  at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
>  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
>  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>  at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
>  at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
>  at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>  at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193)
>  at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
>  at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:549)
>  at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589)
>  at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:666)
>  at java.lang.Thread.run(Thread.java:534)
>
>
> Please I need to solve this problem so fast,  i going to apreciate your
help
> best regards
> rafael
>
>
>


----------------------------------------------------------------------------
----


>
>
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev