[Netarchivesuite-devel] Broken Pipe

[Søren Vejrup Carlsen]

Hi A.
There has been significant changes by Nicolas to the connection logic. So this cannot be seen as a reoccurring of the old bug, but a new one.

So please open a new issue for this problem in JIRA.


Best Regards
Søren
________________________________________
Fra: netarchivesuite-devel-bounces at lists.gforge.statsbiblioteket.dk [netarchivesuite-devel-bounces at lists.gforge.statsbiblioteket.dk] på vegne af aponb at gmx.at [aponb at gmx.at]
Sendt: 28. april 2011 10:24
Til: netarchivesuite-devel at lists.gforge.statsbiblioteket.dk
Emne: [Netarchivesuite-devel] Broken Pipe

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)



_______________________________________________
Netarchivesuite-devel mailing list
Netarchivesuite-devel at lists.gforge.statsbiblioteket.dk
https://lists.gforge.statsbiblioteket.dk/mailman/listinfo/netarchivesuite-devel