Uploaded image for project: 'Tupelo'
  1. Tupelo
  2. TUP-245

MySQL context impl does not recover from MySQL dropping pooled connections

XMLWordPrintableJSON

      > After idle time of couple of hours
      > (Dont know exactly how much?), there is some kind of communication
      > link failure between mysql context and jdbc. Given below is the
      > detailed stack trace.
      >
      > It will start responding nicely after sometime if there is
      > some automatic restart of server or some other batch process to create
      > context.
      >
      > ** BEGIN NESTED EXCEPTION **
      > com.mysql.jdbc.CommunicationsException
      > MESSAGE: Communications link failure due to underlying exception:
      >
      > ** BEGIN NESTED EXCEPTION **
      >
      > java.net.SocketException
      > MESSAGE: Broken pipe
      >
      > STACKTRACE:
      >
      > java.net.SocketException: Broken pipe
      > at java.net.SocketOutputStream.socketWrite0(Native Method)
      > at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
      > at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
      > at
      > java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
      > at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
      > at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2637)
      > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1554)
      > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
      > at com.mysql.jdbc.Connection.execSQL(Connection.java:3176)
      > at
      > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1153)
      > at
      > com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1266)
      > at org.tupeloproject.sql.SqlContext.perform(SqlContext.java:374)
      > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      > at
      > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      > at
      > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      > at java.lang.reflect.Method.invoke(Method.java:597)
      > at org.tupeloproject.kernel.Context.perform(Context.java:105)
      > at
      > org.tupeloproject.browser.TupeloBrowser.doBrowse(TupeloBrowser.java:204)
      > at
      > org.tupeloproject.browser.TupeloBrowser.doGet(TupeloBrowser.java:241)
      > at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
      > at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      > at
      > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      > at
      > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      > at
      > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
      > at
      > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
      > at
      > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
      > at
      > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      > at
      > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
      > at
      > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
      > at
      > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
      > at
      > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
      > at
      > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
      > at
      > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
      > at
      > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
      > at
      > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
      > at java.lang.Thread.run(Thread.java:619)
      >
      >
      > ** END NESTED EXCEPTION **

              futrelle Joe Futrelle (Inactive)
              Anonymous Anonymous
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: