[Thread Prev][Thread Next][Index]

Re: [las_users] Timeout Question

Hi Lucas,

Sorry we have not responded before now.
The issue is the communication between the MySQL database and the user interface server. What version of MySQL are you running? Is your server available to the public? If so, can you please send the URL? Thanks. 

Roland

Lucas Moxey wrote:

Dear fellow LAS community
I am writing because I need your help. I've installed LAS (LAS Ver 6.5.2.1 and Ferret Ver 6.05) in my server and it seems to work just fine. However, I noticed that if I don't use it for a while, I get an error message that says "las javax.servlet.ServletException: Communications link failure due to underlying exception:"
I am not sure, but it looks like the LAS is timing out. I've set up a cron job that will restart the LAS every 2 hours (this is less than the default LAS timeout of 180 min.), but this doesn't seem to make any difference. 

Below is the full error message that I am getting.

ANY suggestions & thoughts would be really helpful! Thanks!

                    Lucas

<html>
<body>
<h3>LAS server error</h3>
<p><b>You have encountered an unexpected User Interface error! Please <a href="dataset">click here</a> to return to the Datasets page. If this error persists please contact the LAS administrator for this site.</b></p> 
<p><hr><p>
The following error occurred:<br><pre>
javax.servlet.ServletException: 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:1842)
 at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2288)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
 at com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)
at gov.noaa.pmel.tmap.db.DbaseObject.doDeserializeAggregate(DbaseObject.java:255) at gov.noaa.pmel.tmap.db.DbaseObject.deserializeAggregate(DbaseObject.java:332) at gov.noaa.pmel.tmap.db.DbaseObject.deserializeAggregate(DbaseObject.java:353) at gov.noaa.pmel.tmap.db.DbaseObject.deserializeAggregate(DbaseObject.java:341) 
 at gov.noaa.pmel.tmap.db.Config.getConfigs(Config.java:91)
 at gov.noaa.pmel.tmap.DatasetItem.getItems(DatasetItem.java:83)
 at gov.noaa.pmel.tmap.DatasetItem.getItems(DatasetItem.java:25)
at gov.noaa.pmel.tmap.SessionFilter.initDefaultContexts(SessionFilter.java:128) 
 at gov.noaa.pmel.tmap.SessionFilter.checkSession(SessionFilter.java:476)
 at gov.noaa.pmel.tmap.SessionFilter.doFilter(SessionFilter.java:505)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 
 at gov.noaa.pmel.tmap.ExceptionFilter.doFilter(ExceptionFilter.java:24)
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)


** END NESTED EXCEPTION **
at gov.noaa.pmel.tmap.SessionFilter.initDefaultContexts(SessionFilter.java:339) 
 at gov.noaa.pmel.tmap.SessionFilter.checkSession(SessionFilter.java:476)
 at gov.noaa.pmel.tmap.SessionFilter.doFilter(SessionFilter.java:505)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 
 at gov.noaa.pmel.tmap.ExceptionFilter.doFilter(ExceptionFilter.java:24)
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)

Root cause of servlet exception was:
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:1842)
 at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2288)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
 at com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)
at gov.noaa.pmel.tmap.db.DbaseObject.doDeserializeAggregate(DbaseObject.java:255) at gov.noaa.pmel.tmap.db.DbaseObject.deserializeAggregate(DbaseObject.java:332) at gov.noaa.pmel.tmap.db.DbaseObject.deserializeAggregate(DbaseObject.java:353) at gov.noaa.pmel.tmap.db.DbaseObject.deserializeAggregate(DbaseObject.java:341) 
 at gov.noaa.pmel.tmap.db.Config.getConfigs(Config.java:91)
 at gov.noaa.pmel.tmap.DatasetItem.getItems(DatasetItem.java:83)
 at gov.noaa.pmel.tmap.DatasetItem.getItems(DatasetItem.java:25)
at gov.noaa.pmel.tmap.SessionFilter.initDefaultContexts(SessionFilter.java:128) 
 at gov.noaa.pmel.tmap.SessionFilter.checkSession(SessionFilter.java:476)
 at gov.noaa.pmel.tmap.SessionFilter.doFilter(SessionFilter.java:505)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 
 at gov.noaa.pmel.tmap.ExceptionFilter.doFilter(ExceptionFilter.java:24)
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)


** END NESTED EXCEPTION **


 at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2500)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
 at com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)
at gov.noaa.pmel.tmap.db.DbaseObject.doDeserializeAggregate(DbaseObject.java:255) at gov.noaa.pmel.tmap.db.DbaseObject.deserializeAggregate(DbaseObject.java:332) at gov.noaa.pmel.tmap.db.DbaseObject.deserializeAggregate(DbaseObject.java:353) at gov.noaa.pmel.tmap.db.DbaseObject.deserializeAggregate(DbaseObject.java:341) 
 at gov.noaa.pmel.tmap.db.Config.getConfigs(Config.java:91)
 at gov.noaa.pmel.tmap.DatasetItem.getItems(DatasetItem.java:83)
 at gov.noaa.pmel.tmap.DatasetItem.getItems(DatasetItem.java:25)
at gov.noaa.pmel.tmap.SessionFilter.initDefaultContexts(SessionFilter.java:128) 
 at gov.noaa.pmel.tmap.SessionFilter.checkSession(SessionFilter.java:476)
 at gov.noaa.pmel.tmap.SessionFilter.doFilter(SessionFilter.java:505)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 
 at gov.noaa.pmel.tmap.ExceptionFilter.doFilter(ExceptionFilter.java:24)
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)
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:1842)
 at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2288)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
 at com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)
at gov.noaa.pmel.tmap.db.DbaseObject.doDeserializeAggregate(DbaseObject.java:255) at gov.noaa.pmel.tmap.db.DbaseObject.deserializeAggregate(DbaseObject.java:332) at gov.noaa.pmel.tmap.db.DbaseObject.deserializeAggregate(DbaseObject.java:353) at gov.noaa.pmel.tmap.db.DbaseObject.deserializeAggregate(DbaseObject.java:341) 
 at gov.noaa.pmel.tmap.db.Config.getConfigs(Config.java:91)
 at gov.noaa.pmel.tmap.DatasetItem.getItems(DatasetItem.java:83)
 at gov.noaa.pmel.tmap.DatasetItem.getItems(DatasetItem.java:25)
at gov.noaa.pmel.tmap.SessionFilter.initDefaultContexts(SessionFilter.java:128) 
 at gov.noaa.pmel.tmap.SessionFilter.checkSession(SessionFilter.java:476)
 at gov.noaa.pmel.tmap.SessionFilter.doFilter(SessionFilter.java:505)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 
 at gov.noaa.pmel.tmap.ExceptionFilter.doFilter(ExceptionFilter.java:24)
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)


** END NESTED EXCEPTION **


 at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2500)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2788)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
 at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
 at com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)
at gov.noaa.pmel.tmap.db.DbaseObject.doDeserializeAggregate(DbaseObject.java:255) at gov.noaa.pmel.tmap.db.DbaseObject.deserializeAggregate(DbaseObject.java:332) at gov.noaa.pmel.tmap.db.DbaseObject.deserializeAggregate(DbaseObject.java:353) at gov.noaa.pmel.tmap.db.DbaseObject.deserializeAggregate(DbaseObject.java:341) 
 at gov.noaa.pmel.tmap.db.Config.getConfigs(Config.java:91)
 at gov.noaa.pmel.tmap.DatasetItem.getItems(DatasetItem.java:83)
 at gov.noaa.pmel.tmap.DatasetItem.getItems(DatasetItem.java:25)
at gov.noaa.pmel.tmap.SessionFilter.initDefaultContexts(SessionFilter.java:128) 
 at gov.noaa.pmel.tmap.SessionFilter.checkSession(SessionFilter.java:476)
 at gov.noaa.pmel.tmap.SessionFilter.doFilter(SessionFilter.java:505)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 
 at gov.noaa.pmel.tmap.ExceptionFilter.doFilter(ExceptionFilter.java:24)
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)
</pre></body>
</html>
[Thread Prev][Thread Next][Index]
Contact Us
Dept of Commerce / NOAA / OAR / PMEL / TMAP

Privacy Policy | Disclaimer | Accessibility Statement