Re: Communications link failure due to underlying exception...various network exceptions
Posted by:
Sam M
Date: May 24, 2007 02:04AM
I am facing a similar problem with the Communication link, every day, after being idle for around 8 hours, the server stops connecting to the MySQL. We are using the latest 5.0.x jdbc driver, added the MySQL server's IP address on the Application server's hosts file, but nothing worked. Can anyone please help.
** BEGIN NESTED EXCEPTION **
com.mysql.jdbc.CommunicationsException
MESSAGE: Communications link
failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at
com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1963)
at
com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2375)
at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2874)
at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at
com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1403)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:32)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.entities.enduser.BmsEndUserComponent.getUser(BmsEndUserComponent.java:127)
at
bms.entities.enduser.BmsUserInitialization.initUserDetails(BmsUserInitialization.java:18)
at bms.entities.enduser.BmsUserDbHandle.initUser(BmsUserDbHandle.java:25)
at bms.entities.enduser.BMSUserLoginAE.perform(BMSUserLoginAE.java:47)
at
org.apache.struts.action.Action.execute(Action.java:420)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
** END NESTED EXCEPTION
**
Last packet sent to the server was 1 ms
ago.
STACKTRACE:
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at
com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1963)
at
com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2375)
at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2874)
at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at
com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1403)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:32)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.entities.enduser.BmsEndUserComponent.getUser(BmsEndUserComponent.java:127)
at
bms.entities.enduser.BmsUserInitialization.initUserDetails(BmsUserInitialization.java:18)
at bms.entities.enduser.BmsUserDbHandle.initUser(BmsUserDbHandle.java:25)
at bms.entities.enduser.BMSUserLoginAE.perform(BMSUserLoginAE.java:47)
at
org.apache.struts.action.Action.execute(Action.java:420)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
** END NESTED EXCEPTION
**
Last packet sent to the server was 1 ms ago.
at
com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2586)
at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2874)
at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at
com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1403)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:32)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at
bms.entities.enduser.BmsEndUserComponent.getUser(BmsEndUserComponent.java:127)
at
bms.entities.enduser.BmsUserInitialization.initUserDetails(BmsUserInitialization.java:18)
at bms.entities.enduser.BmsUserDbHandle.initUser(BmsUserDbHandle.java:25)
at bms.entities.enduser.BMSUserLoginAE.perform(BMSUserLoginAE.java:47)
at
org.apache.struts.action.Action.execute(Action.java:420)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
** END NESTED EXCEPTION **
MIME-Version: 1.0
Content-Type: multipart/mixed;
boundary="----=_Part_4_21176201.1179237680505"
------=_Part_4_21176201.1179237680505
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:
** BEGIN NESTED EXCEPTION **
com.mysql.jdbc.CommunicationsException
MESSAGE: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1963)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2375)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2874)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1403)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:32)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.entities.enduser.BmsEndUserComponent.getUser(BmsEndUserComponent.java:127)
at bms.entities.enduser.BmsUserInitialization.initUserDetails(BmsUserInitialization.java:18)
at bms.entities.enduser.BmsUserDbHandle.initUser(BmsUserDbHandle.java:25)
at bms.entities.enduser.BMSUserLoginAE.perform(BMSUserLoginAE.java:47)
at org.apache.struts.action.Action.execute(Action.java:420)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
** END NESTED EXCEPTION **
Last packet sent to the server was 1 ms ago.
STACKTRACE:
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1963)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2375)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2874)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1403)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:32)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.entities.enduser.BmsEndUserComponent.getUser(BmsEndUserComponent.java:127)
at bms.entities.enduser.BmsUserInitialization.initUserDetails(BmsUserInitialization.java:18)
at bms.entities.enduser.BmsUserDbHandle.initUser(BmsUserDbHandle.java:25)
at bms.entities.enduser.BMSUserLoginAE.perform(BMSUserLoginAE.java:47)
at org.apache.struts.action.Action.execute(Action.java:420)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
** END NESTED EXCEPTION **
Last packet sent to the server was 1 ms ago.
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2586)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2874)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1403)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:32)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.util.db.BmsAdminComponent.getAdminDetails(BmsAdminComponent.java:49)
at bms.util.exception.BmsException.BmsSQLException(BmsException.java:27)
at bms.entities.enduser.BmsEndUserComponent.getUser(BmsEndUserComponent.java:127)
at bms.entities.enduser.BmsUserInitialization.initUserDetails(BmsUserInitialization.java:18)
at bms.entities.enduser.BmsUserDbHandle.initUser(BmsUserDbHandle.java:25)
at bms.entities.enduser.BMSUserLoginAE.perform(BMSUserLoginAE.java:47)
at org.apache.struts.action.Action.execute(Action.java:420)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
** END NESTED EXCEPTION **
regards
Sam
Subject
Written By
Posted
February 13, 2007 07:56AM
February 13, 2007 08:00AM
February 13, 2007 11:07AM
February 13, 2007 01:52PM
February 13, 2007 02:25PM
February 13, 2007 02:33PM
February 13, 2007 02:42PM
February 13, 2007 02:47PM
February 14, 2007 07:45AM
February 15, 2007 07:58AM
February 25, 2009 12:39AM
Re: Communications link failure due to underlying exception...various network exceptions
May 24, 2007 02:04AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.