[opencms-dev] problem uploading a file

Hernandez Martínez, Julián HernandezMJ at cerdanyola.cat
Thu Mar 20 15:11:13 CET 2008 

Hello I'm Juliàn from spain, I've read I got and solve this problem, could your help me?


Configuration 
Windows 2000 server sp4
tomcat 5.5.25    - initial memory pool : 500MB,    Maxim memory pool:  500 MB
mysql 5.0   - max_allowed_packed: 8387584
java 1.5. 0_12
OPENCMS 7.03


When I try to upload a 2,5MB file I can't. on opencms.log:

18 mar 2008 11:22:13,960 ERROR [rg.opencms.workplace.CmsDialog:1423] El diálogo del workplace ha causado un error.
org.opencms.db.CmsDbSqlException: Error al crear el recurso "/sites/portal/galeries/galeria_documents/Documents_premsa_2008/03/Campanya_de_prevencixn_y_control_mosquito_tigre441.pdf".
	at org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:116)
	at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:238)
	at org.opencms.db.CmsDbContext.report(CmsDbContext.java:212)
	at org.opencms.db.CmsSecurityManager.createResource(CmsSecurityManager.java:1001)
	at org.opencms.file.types.A_CmsResourceType.createResource(A_CmsResourceType.java:288)
	at org.opencms.file.CmsObject.createResource(CmsObject.java:733)
	at org.opencms.workplace.explorer.CmsNewResourceUpload.actionUpload(CmsNewResourceUpload.java:462)
	at org.apache.jsp.WEB_002dINF.jsp.offline.system.workplace.commons.newresource_005fupload_jsp._jspService(newresource_005fupload_jsp.java:110)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
	at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:594)
	at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:505)
	at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:193)
	at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)
	at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:999)
	at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:422)
	at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:173)
	at org.opencms.loader.CmsJspLoader.dispatchJsp(CmsJspLoader.java:233)
	at org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:575)
	at org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:948)
	at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1492)
	at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:171)
	at org.opencms.main.OpenCmsServlet.doPost(OpenCmsServlet.java:183)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
	at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
	at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
	at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.opencms.db.CmsDbSqlException: Sucedió un error SQL ejecutando la siquiente consulta: com.mysql.jdbc.PreparedStatement at 1871533: statement has been closed, no further internal information available. 
	at org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:174)
	at org.opencms.db.generic.CmsVfsDriver.createResource(CmsVfsDriver.java:622)
	at org.opencms.db.CmsDriverManager.createResource(CmsDriverManager.java:1679)
	at org.opencms.db.CmsDriverManager.createResource(CmsDriverManager.java:1788)
	at org.opencms.db.CmsSecurityManager.createResource(CmsSecurityManager.java:999)
	... 43 more
Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

java.net.SocketException
MESSAGE: Connection reset by peer: socket write error

STACKTRACE:

java.net.SocketException: Connection reset by peer: socket write error
	at java.net.SocketOutputStream.socketWrite0(Native Method)
	at java.net.SocketOutputStream.socketWrite(Unknown Source)
	at java.net.SocketOutputStream.write(Unknown Source)
	at java.io.BufferedOutputStream.write(Unknown Source)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2742)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1585)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1500)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
	at org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:172)
	at org.opencms.db.generic.CmsVfsDriver.createResource(CmsVfsDriver.java:622)
	at org.opencms.db.CmsDriverManager.createResource(CmsDriverManager.java:1679)
	at org.opencms.db.CmsDriverManager.createResource(CmsDriverManager.java:1788)
	at org.opencms.db.CmsSecurityManager.createResource(CmsSecurityManager.java:999)
	at org.opencms.file.types.A_CmsResourceType.createResource(A_CmsResourceType.java:288)
	at org.opencms.file.CmsObject.createResource(CmsObject.java:733)
	at org.opencms.workplace.explorer.CmsNewResourceUpload.actionUpload(CmsNewResourceUpload.java:462)
	at org.apache.jsp.WEB_002dINF.jsp.offline.system.workplace.commons.newresource_005fupload_jsp._jspService(newresource_005fupload_jsp.java:110)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
	at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:594)
	at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:505)
	at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:193)
	at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)
	at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:999)
	at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:422)
	at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:173)
	at org.opencms.loader.CmsJspLoader.dispatchJsp(CmsJspLoader.java:233)
	at org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:575)
	at org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:948)
	at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1492)
	at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:171)
	at org.opencms.main.OpenCmsServlet.doPost(OpenCmsServlet.java:183)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
	at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
	at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
	at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
	at java.lang.Thread.run(Unknown Source)


** END NESTED EXCEPTION **



Last packet sent to the server was 16 ms ago.
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2759)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1585)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1500)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
	at org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:172)
	... 47 more


Finally, when I change de database to oracle 10G I can upload a 9MB file

thanks





--
Abans d'imprimir aquest missatge en paper pensi si realment és necessari. El medi ambient és cosa de tots.

--
Advertència Legal
La present informació s’envia únicament a la persona a la que va dirigida i pot contenir informació
de caràcter confidencial o privilegiada. Qualsevol modificació, retransmissió, difusió o altre ús
d’aquesta informació per persones o entitats diferents a la persona a la que va dirigida no està
permesa. Si vostè l’ha rebut per error, si us plau contacti amb el remitent i esborri el missatge de
qualsevol ordinador. En el cas que aquest missatge sigui contestat per la mateixa via, s'ha de saber
que la seva resposta podria ser coneguda per tercers en entrar a la xarxa. Per això, si el
missatge inclou contrasenyes, números de targetes de crèdit o qualsevol altra informació que vostè
consideri confidencial, seria més segur contestar per una altra via i cancel·lar la seva transmissió.
L’Ajuntament de Cerdanyola del Vallès no pot assumir la responsabilitat derivada del fet de que terceres persones
puguin arribar a conèixer el contingut d’aquest missatge durant la seva transmissió.

More information about the opencms-dev mailing list