Re: Communications link failure due to underlying exception...various network exceptions

[Sam M]

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