[opencms-dev] upload a big file

[Rafael Diaz Valdes]

Hi list
 
I need to upload a big file (20MB) but  Opencms crash, I fixed the configuration in order to upload big files 
 
in Tomcat (catalina.bat)
  CATALINA_OPTS= %CATALINA_OPTS% - Dsun.io.useCanonCaches=false -Xmx2000M -Xms2M
 
also in MySQL (my.cnf)
  set-variable = key_buffer_size=2000M
  set-variable = max_allowed_packet=2000M
 
my system is:
 Apache2 with mod-proxy conection with Tomcat 4.1.29 and Opencms 5 as ROOT in Tomcat.
 
the error is:
 

javax.servlet.ServletException: Resource loader error in file '/NewAlicePortal/en/Collaboration/Boards/Technical/DocumentsTBForum/includefile.jsp'
Root cause:
org.apache.jasper.JasperException: com.opencms.core.CmsException: [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.java:173)
 at com.opencms.file.mySql.CmsDbAccess.readFile(CmsDbAccess.java:674)
 at com.opencms.file.mySql.CmsDbAccess.createFile(CmsDbAccess.java:386)
 at com.opencms.file.genericSql.CmsResourceBroker.createFile(CmsResourceBroker.java:1789)
 at com.opencms.file.CmsObject.doCreateFile(CmsObject.java:978)
 at com.opencms.file.CmsResourceTypePlain.createResource(CmsResourceTypePlain.java:308)
 at com.opencms.file.CmsObject.createResource(CmsObject.java:934)
 at com.opencms.file.CmsObject.createResource(CmsObject.java:929)
 at org.apache.jsp.includefile_jsp_jsp._jspService(includefile_jsp_jsp.java:112)
 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:210)
 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
 at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:575)
 at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:498)
 at com.opencms.flex.cache.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:158)
 at com.opencms.flex.CmsJspLoader.service(CmsJspLoader.java:972)
 at com.opencms.flex.cache.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:256)
 at com.opencms.flex.CmsJspLoader.load(CmsJspLoader.java:577)
 at com.opencms.flex.CmsJspLoader.initlaunch(CmsJspLoader.java:239)
 at com.opencms.core.OpenCms.showResource(OpenCms.java:961)
 at com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:310)
 at com.opencms.core.OpenCmsHttpServlet.doPost(OpenCmsHttpServlet.java:331)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.java:191)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(StandardPipeline.java:643)
 at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(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.processConnection(Http11Protocol.java:549)
 at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666)
 at java.lang.Thread.run(Thread.java:534)

** END NESTED EXCEPTION **

 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
 at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:575)
 at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:498)
 at com.opencms.flex.cache.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:158)
 at com.opencms.flex.CmsJspLoader.service(CmsJspLoader.java:972)
 at com.opencms.flex.cache.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:256)
 at com.opencms.flex.CmsJspLoader.load(CmsJspLoader.java:577)
 at com.opencms.flex.CmsJspLoader.initlaunch(CmsJspLoader.java:239)
 at com.opencms.core.OpenCms.showResource(OpenCms.java:961)
 at com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:310)
 at com.opencms.core.OpenCmsHttpServlet.doPost(OpenCmsHttpServlet.java:331)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.java:191)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(StandardPipeline.java:643)
 at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(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.processConnection(Http11Protocol.java:549)
 at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666)
 at java.lang.Thread.run(Thread.java:534)
--------------- End of root cause.