Uploaded image for project: 'NetarchiveSuite'
  1. NetarchiveSuite
  2. NAS-1855

Broken Pipe after a long duration of inactivity

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Blocker
    • 3.16.0, I47
    • 3.16.0
    • Common
    • None

    Description

      I get a Broken Pipe after a long duration of inactivity. This happens with mysql-connector-java-5.1.12-bin.jar on a mysql 5.1.41 (ubuntu).

      SQL error getting sparse harvests
      SQLException trace:
      SQL State:08S01
      Error Code:0
      com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 80.555.746 milliseconds ago.  The last packet sent successfully to the server was 80.555.747 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
      	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
      	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
      	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1122)
      	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3317)
      	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1941)
      	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
      	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
      	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
      	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264)
      	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
      	at dk.netarkivet.harvester.datamodel.HarvestDefinitionDBDAO.getAllSparsePartialHarvestDefinitions(HarvestDefinitionDBDAO.java:942)
      	at org.apache.jsp.Definitions_002dselective_002dharvests_jsp._jspService(org.apache.jsp.Definitions_002dselective_002dharvests_jsp:137)
      	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389)
      	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:486)
      	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:380)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      	at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
      	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401)
      	at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
      	at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
      	at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
      	at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450)
      	at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
      	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
      	at org.mortbay.jetty.Server.handle(Server.java:322)
      	at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
      	at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:928)
      	at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549)
      	at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
      	at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
      	at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)
      	at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
      Caused by: 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:3298)
      	... 30 more
      

      Attachments

        Issue Links

          Activity

            People

              ngiraud Nicolas Giraud (Inactive)
              aponb Andreas P
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 2h
                  2h