[opencms-dev] Server Problem

Wed Jun 18 15:19:01 CEST 2003

Hi,

we are using OpenCms 5.0.0 with Apache 2.0.46 (mod_ssl, mod_jk2) and Tomcat
4.1.24 on Windows 2000 Server. The database is Oracle 9.2 on Windows 2000
Server. Tomcat is started from mod_jk2. After starting the Apache Server
OpenCms runs fine. A few hours later OpenCms starts losing some images. The
next failure step is the error message below.

Has anybody the same problem? Can anybody help me?

com.opencms.core.CmsException: 4 Sql exception. Detailed error:
[com.opencms.file.genericSql.CmsDbAccess] E/A-Exception: Connection reset
by peer: socket write error.
root cause was java.sql.SQLException: E/A-Exception: Connection reset by
peer: socket write error
        at
com.opencms.file.genericSql.CmsDbAccess.readFile(CmsDbAccess.java:6095)
        at
com.opencms.file.genericSql.CmsResourceBroker.readFile(CmsResourceBroker.java:5203)

        at com.opencms.file.CmsObject.readFile(CmsObject.java:2883)
        at com.opencms.core.OpenCms.initResource(OpenCms.java:788)
        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(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:2415)
        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:223)
        at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:261)
        at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:360)
        at org.apache.jk.common.ChannelJni.invoke(ChannelJni.java:210)
        at org.apache.jk.core.MsgContext.execute(MsgContext.java:203)
        at org.apache.jk.apr.AprImpl.jniInvoke(AprImpl.java:232)
>-----------
>Root cause:
>java.sql.SQLException: E/A-Exception: Connection reset by peer: socket
write error
>        at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
>        at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211)
>        at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:324)
>        at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1912)

>        at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2015)

>        at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:395)

>        at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:339)

>        at
com.opencms.dbpool.CmsPreparedStatement.executeQuery(CmsPreparedStatement.java:173)

>        at
com.opencms.file.genericSql.CmsDbAccess.readFile(CmsDbAccess.java:6054)
>        at
com.opencms.file.genericSql.CmsResourceBroker.readFile(CmsResourceBroker.java:5203)

>        at com.opencms.file.CmsObject.readFile(CmsObject.java:2883)
>        at com.opencms.core.OpenCms.initResource(OpenCms.java:788)
>        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(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:2415)
>        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:223)
>        at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:261)
>        at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:360)
>        at org.apache.jk.common.ChannelJni.invoke(ChannelJni.java:210)
>        at org.apache.jk.core.MsgContext.execute(MsgContext.java:203)
>        at org.apache.jk.apr.AprImpl.jniInvoke(AprImpl.java:232)

java.sql.SQLException: E/A-Exception: Connection reset by peer: socket
write error
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211)

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:324)

        at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1912)

        at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2015)

        at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:395)

        at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:339)

        at
com.opencms.dbpool.CmsPreparedStatement.executeQuery(CmsPreparedStatement.java:173)

        at
com.opencms.file.genericSql.CmsDbAccess.readFile(CmsDbAccess.java:6054)
        at
com.opencms.file.genericSql.CmsResourceBroker.readFile(CmsResourceBroker.java:5203)

        at com.opencms.file.CmsObject.readFile(CmsObject.java:2883)
        at com.opencms.core.OpenCms.initResource(OpenCms.java:788)
        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(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:2415)
        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:223)
        at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:261)
        at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:360)
        at org.apache.jk.common.ChannelJni.invoke(ChannelJni.java:210)
        at org.apache.jk.core.MsgContext.execute(MsgContext.java:203)
        at org.apache.jk.apr.AprImpl.jniInvoke(AprImpl.java:232)

Mit freundlichen Grüßen

Thomas Breder

____________________________________________________

S Broker AG
Information Technology

Tel.: +49 (0)203/289-2120 (Duisburg)
Tel.: +49 (0)611/2044-2120 (Wiesbaden)
Fax: +49 (0)203/289-2099 (Duisburg)
thomas.breder at sbroker.de

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
S Broker AG * Beekstraße 38-42 * 47051 Duisburg
service at sbroker.de * www.sbroker.de

Sitz Wiesbaden * Amtsgericht Wiesbaden * HRB 20591 * BLZ 300 301 00

Vorstand:
Klaus Schöniger (Sprecher)
Dr. Raoul G. Wild
Karl-Martin im Brahm

Vorsitzender des Aufsichtsrats:
Winfried Drewes

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese
E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den
Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren
sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.