[Netarchivesuite-devel] Broken Pipe

[aponb at gmx.at]

During my tests the bug https://sbforge.org/jira/browse/NAS-1060 seems 
to be back again. I get a Borken 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).
Did the changes affect the DBConnection?

Regards
a.


Enclosed the exception:

WARNUNG: JSP page threw exception: 
dk.netarkivet.common.exceptions.IOFailure: 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)