<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16890" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Verdana size=2><SPAN class=375001715-29092009>Hello
All,</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN class=375001715-29092009>I am using OpenCms
version 7.0.5 with mysql Db.</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN class=375001715-29092009>I run it under
tomcat version 5.5.27 . When I leave the opencms inactive for a long time
specially at nights when no one access the opencms, in the early morning, the
first few access requests gives following exception.</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN class=375001715-29092009>I understand its a
Db connection statement problem and </SPAN></FONT><FONT face=Verdana
size=2><SPAN class=375001715-29092009>I understand opencms uses dbcp connection
pool and pool for prepared statements, to eliminate few causes, I disabled the
prepared statement pooling by making db.statements.default.pooling=false in
opencms.properties but the problem still persists. I have seen various people
are getting the same exception but I couldnt find the solution online.
</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=375001715-29092009></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=375001715-29092009>Before digging down myself deep into the problem,
was just wondering does anyone knows the real cause and the fix to this
problem?</SPAN></FONT></DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=375001715-29092009></SPAN></FONT> </DIV>
<DIV><FONT face=Verdana size=2><SPAN
class=375001715-29092009></SPAN></FONT> </DIV>
<DIV><FONT><SPAN class=375001715-29092009><SPAN lang=EN>
<P><FONT face=Verdana size=2>org.opencms.db.CmsDbSqlException: Error reading the
user "Guest".</FONT></P>
<P><FONT face=Verdana size=2>at
org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:116)</FONT></P>
<P><FONT face=Verdana size=2>at
org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:238)</FONT></P>
<P><FONT face=Verdana size=2>at
org.opencms.db.CmsDbContext.report(CmsDbContext.java:212)</FONT></P>
<P><FONT face=Verdana size=2>at
org.opencms.db.CmsSecurityManager.readUser(CmsSecurityManager.java:4336)</FONT></P>
<P><FONT face=Verdana size=2>at
org.opencms.main.OpenCmsCore.initCmsObject(OpenCmsCore.java:1911)</FONT></P>
<P><FONT face=Verdana size=2>at
org.opencms.main.OpenCmsCore.initCmsObject(OpenCmsCore.java:827)</FONT></P>
<P><FONT face=Verdana size=2>at
org.opencms.main.OpenCmsCore.initCmsObject(OpenCmsCore.java:852)</FONT></P>
<P><FONT face=Verdana size=2>at
org.opencms.main.OpenCms.initCmsObject(OpenCms.java:606)</FONT></P>
<P><FONT face=Verdana size=2>at
com.switchfire.cms.webservices.CmsServiceInitializer.getCmsObject(CmsServiceInitializer.java:67)</FONT></P>
<P><FONT face=Verdana size=2>at
com.switchfire.cms.webservices.CmsServiceInitializer.login(CmsServiceInitializer.java:76)</FONT></P>
<P><FONT face=Verdana size=2>at
com.switchfire.cms.servlet.CmsClientAlertServlet.doProcess(CmsClientAlertServlet.java:47)</FONT></P>
<P><FONT face=Verdana size=2>at
com.switchfire.cms.servlet.BaseCmsServlet.doPost(BaseCmsServlet.java:32)</FONT></P>
<P><FONT face=Verdana size=2>at
javax.servlet.http.HttpServlet.service(HttpServlet.java:647)</FONT></P>
<P><FONT face=Verdana size=2>at
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)</FONT></P>
<P><FONT face=Verdana size=2>at java.lang.Thread.run(Thread.java:619)</FONT></P>
<P><FONT face=Verdana size=2>Caused by: org.opencms.db.CmsDbSqlException: An SQL
error occurred when executing the following query:
com.mysql.jdbc.PreparedStatement@2eebc11d: statement has been closed, no further
internal information available. </FONT></P>
<P><FONT face=Verdana size=2>at
org.opencms.db.generic.CmsUserDriver.readUser(CmsUserDriver.java:1379)</FONT></P>
<P><FONT face=Verdana size=2>at
org.opencms.db.CmsDriverManager.readUser(CmsDriverManager.java:6849)</FONT></P>
<P><FONT face=Verdana size=2>at
org.opencms.db.CmsSecurityManager.readUser(CmsSecurityManager.java:4334)</FONT></P>
<P><FONT face=Verdana size=2>... 25 more</FONT></P>
<P><FONT face=Verdana size=2>Caused by: com.mysql.jdbc.CommunicationsException:
Communications link failure due to underlying exception: </FONT></P>
<P><FONT face=Verdana size=2>** BEGIN NESTED EXCEPTION ** </FONT></P>
<P><FONT face=Verdana size=2>java.net.SocketException</FONT></P>
<P><FONT face=Verdana size=2>MESSAGE: Broken pipe</FONT></P>
<P><FONT face=Verdana size=2>STACKTRACE:</FONT></P>
<P><FONT face=Verdana size=2>java.net.SocketException: Broken pipe</FONT></P>
<P><FONT face=Verdana size=2>at java.net.SocketOutputStream.socketWrite0(Native
Method)</FONT></P>
<P><FONT face=Verdana size=2>at
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)</FONT></P>
<P><FONT face=Verdana size=2>at
java.net.SocketOutputStream.write(SocketOutputStream.java:136)</FONT></P>
<P><FONT face=Verdana size=2>at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)</FONT></P>
<P><FONT face=Verdana size=2>at
java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)</FONT></P>
<P><FONT face=Verdana size=2>at
com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)</FONT></P>
<P><FONT face=Verdana size=2>at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)</FONT></P>
<P><FONT face=Verdana size=2>at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)</FONT></P>
<P><FONT face=Verdana size=2>at
com.mysql.jdbc.Connection.execSQL(Connection.java:3256)</FONT></P>
<P><FONT face=Verdana size=2>at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)</FONT></P>
<P><FONT face=Verdana size=2>at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)</FONT></P>
<P><FONT face=Verdana size=2>at
org.opencms.db.generic.CmsUserDriver.readUser(CmsUserDriver.java:1362)</FONT></P>
<P><FONT face=Verdana size=2>at
org.opencms.db.CmsDriverManager.readUser(CmsDriverManager.java:6849)</FONT></P>
<P><FONT face=Verdana size=2>at
org.opencms.db.CmsSecurityManager.readUser(CmsSecurityManager.java:4334)</FONT></P>
<P><FONT face=Verdana size=2>at
org.opencms.main.OpenCmsCore.initCmsObject(OpenCmsCore.java:1911)</FONT></P>
<P><FONT face=Verdana size=2>at
org.opencms.main.OpenCmsCore.initCmsObject(OpenCmsCore.java:827)</FONT></P>
<P><FONT face=Verdana size=2>at
org.opencms.main.OpenCmsCore.initCmsObject(OpenCmsCore.java:852)</FONT></P>
<P><FONT face=Verdana size=2>at
org.opencms.main.OpenCms.initCmsObject(OpenCms.java:606)</FONT></P>
<P><FONT face=Verdana size=2>at
com.switchfire.cms.webservices.CmsServiceInitializer.getCmsObject(CmsServiceInitializer.java:67)</FONT></P>
<P><FONT face=Verdana size=2>at
com.switchfire.cms.webservices.CmsServiceInitializer.login(CmsServiceInitializer.java:76)</FONT></P>
<P><FONT face=Verdana size=2>at
com.switchfire.cms.servlet.CmsClientAlertServlet.doProcess(CmsClientAlertServlet.java:47)</FONT></P>
<P><FONT face=Verdana size=2>at
com.switchfire.cms.servlet.BaseCmsServlet.doPost(BaseCmsServlet.java:32)</FONT></P>
<P><FONT face=Verdana size=2>at
javax.servlet.http.HttpServlet.service(HttpServlet.java:647)</FONT></P>
<P><FONT face=Verdana size=2>at
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)</FONT></P>
<P><FONT face=Verdana size=2>at java.lang.Thread.run(Thread.java:619)</FONT></P>
<P><FONT face=Verdana size=2></FONT> </P>
<P><FONT face=Verdana size=2>** END NESTED EXCEPTION **</FONT></P>
<P><FONT face=Verdana size=2></FONT> </P>
<P><FONT face=Verdana size=2></FONT> </P>
<P><FONT face=Verdana size=2>Last packet sent to the server was 1 ms
ago.</FONT></P>
<P><FONT face=Verdana size=2>at
com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2759)</FONT></P>
<P><FONT face=Verdana size=2>at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)</FONT></P>
<P><FONT face=Verdana size=2>at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)</FONT></P>
<P><FONT face=Verdana size=2>at
com.mysql.jdbc.Connection.execSQL(Connection.java:3256)</FONT></P>
<P><FONT face=Verdana size=2>at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)</FONT></P>
<P><FONT face=Verdana size=2>at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448)</FONT></P>
<P><FONT face=Verdana size=2>at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)</FONT></P>
<P><FONT face=Verdana size=2>at
org.opencms.db.generic.CmsUserDriver.readUser(CmsUserDriver.java:1362)</FONT></P>
<P><FONT face=Verdana size=2>... 27 more</FONT></P>
<P><FONT face=Verdana size=2></FONT> </P>
<P><SPAN class=375001715-29092009><FONT face=Verdana
size=2>Regards,</FONT></SPAN></P>
<P><SPAN class=375001715-29092009><FONT face=Verdana
size=2>Tarun</FONT></SPAN></P></SPAN></SPAN></FONT></DIV></BODY></HTML>