Caused by: com.mysql.jdbc.CommunicationsException

[Migrated From Jforum.net]

freemarker.template.TemplateModelException: Method public static net.jforum.entities.LastPostInfo 
net.jforum.repository.ForumRepository.getLastPostInfo(int) throws java.lang.Exception threw an exception
	at freemarker.ext.beans.OverloadedMethodModel.exec(OverloadedMethodModel.java:129)
	at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93)
	at freemarker.core.Expression.getAsTemplateModel(Expression.java:89)
	at freemarker.core.Assignment.accept(Assignment.java:90)
	at freemarker.core.Environment.visit(Environment.java:196)
	at freemarker.core.MixedContent.accept(MixedContent.java:92)
	at freemarker.core.Environment.visit(Environment.java:196)
	at freemarker.core.IteratorBlock$Context.runLoop(IteratorBlock.java:160)
	at freemarker.core.Environment.visit(Environment.java:351)
	at freemarker.core.IteratorBlock.accept(IteratorBlock.java:95)
	at freemarker.core.Environment.visit(Environment.java:196)
	at freemarker.core.MixedContent.accept(MixedContent.java:92)
	at freemarker.core.Environment.visit(Environment.java:196)
	at freemarker.core.IteratorBlock$Context.runLoop(IteratorBlock.java:160)
	at freemarker.core.Environment.visit(Environment.java:351)
	at freemarker.core.IteratorBlock.accept(IteratorBlock.java:95)
	at freemarker.core.Environment.visit(Environment.java:196)
	at freemarker.core.MixedContent.accept(MixedContent.java:92)
	at freemarker.core.Environment.visit(Environment.java:196)
	at freemarker.core.Environment.process(Environment.java:176)
	at freemarker.template.Template.process(Template.java:231)
	at net.jforum.JForum.service(JForum.java:199)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
	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.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	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:856)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:595)
Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: 

I have the development version of the forum, and I�m getting that issue. Seems that the connection with my database is broken, then I refresh a few times, and click some links again and it starts working fine.

Any idea about what�s the problem?

Tks,


Sannon
[originally posted on jforum.net by Sannon]

[Migrated From Jforum.net]

I am getting similar issue with JForum 2.1.6 and Mysql 5.0 with Resin server.

Does anyone have a solution? Please let me know?



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:1903)

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2349)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2860)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:933)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1027)

at net.jforum.dao.generic.GenericUserDAO.selectById(GenericUserDAO.java:93)

at com.ateapps.tms.common.jforumadapter.UserAdapter.getUserDetails(UserAdapter.java:32)

at com.ateapps.tms.common.jforumadapter.ForumAdapter.addNewForum(ForumAdapter.java:56)

at com.ateapps.tms.common.scheduler.SendListBase.associateForum(SendListBase.java:353)

at com.ateapps.tms.common.scheduler.SendListBase.preProcessTask(SendListBase.java:269)

at com.ateapps.tms.common.scheduler.GeneralTaskSendList.processList(GeneralTaskSendList.java:132)

at com.ateapps.tms.common.messaging.JMSProxy.processSendList(JMSProxy.java:50)

at com.ateapps.tms.common.messaging.JMSProxy.handleMessage(JMSProxy.java:29)

at com.ateapps.tms.common.messaging.TaskSenderJob.execute(TaskSenderJob.java:53)

at org.quartz.core.JobRunShell.run(JobRunShell.java:191)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)





** END NESTED EXCEPTION **







Last packet sent to the server was 177 ms ago.

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:1903)

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2349)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2860)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:933)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1027)

at net.jforum.dao.generic.GenericUserDAO.selectById(GenericUserDAO.java:93)

at com.ateapps.tms.common.jforumadapter.UserAdapter.getUserDetails(UserAdapter.java:32)

at com.ateapps.tms.common.jforumadapter.ForumAdapter.addNewForum(ForumAdapter.java:56)

at com.ateapps.tms.common.scheduler.SendListBase.associateForum(SendListBase.java:353)

at com.ateapps.tms.common.scheduler.SendListBase.preProcessTask(SendListBase.java:269)

at com.ateapps.tms.common.scheduler.GeneralTaskSendList.processList(GeneralTaskSendList.java:132)

at com.ateapps.tms.common.messaging.JMSProxy.processSendList(JMSProxy.java:50)

at com.ateapps.tms.common.messaging.JMSProxy.handleMessage(JMSProxy.java:29)

at com.ateapps.tms.common.messaging.TaskSenderJob.execute(TaskSenderJob.java:53)

at org.quartz.core.JobRunShell.run(JobRunShell.java:191)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)





** END NESTED EXCEPTION **







Last packet sent to the server was 177 ms ago.

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2561)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2860)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:933)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1027)

at net.jforum.dao.generic.GenericUserDAO.selectById(GenericUserDAO.java:93)

at com.ateapps.tms.common.jforumadapter.UserAdapter.getUserDetails(UserAdapter.java:32)

at com.ateapps.tms.common.jforumadapter.ForumAdapter.addNewForum(ForumAdapter.java:56)

at com.ateapps.tms.common.scheduler.SendListBase.associateForum(SendListBase.java:353)

at com.ateapps.tms.common.scheduler.SendListBase.preProcessTask(SendListBase.java:269)

at com.ateapps.tms.common.scheduler.GeneralTaskSendList.processList(GeneralTaskSendList.java:132)

at com.ateapps.tms.common.messaging.JMSProxy.processSendList(JMSProxy.java:50)

at com.ateapps.tms.common.messaging.JMSProxy.handleMessage(JMSProxy.java:29)

at com.ateapps.tms.common.messaging.TaskSenderJob.execute(TaskSenderJob.java:53)

at org.quartz.core.JobRunShell.run(JobRunShell.java:191)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)

2006-10-31 22:09:01,863 ERROR com.ateapps.tms.common.scheduler.GeneralTaskSendList -- : In processList :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:1903)

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2349)

[originally posted on jforum.net by LEENA]