[Netarchivesuite-users] SQL Exception

[Søren Vejrup Carlsen]

Hi Peter.
(Un)fortunately, yes, The DBConnection class is used in all Database accesses.
So, maybe my fix wasn't enough.
Maybe one should refresh the connections more actively?

/Søren

-----Original Message-----
From: netarchivesuite-users-bounces at lists.gforge.statsbiblioteket.dk on behalf of Peter Moser
Sent: Sat 5/24/2008 2:15 PM
To: netarchivesuite-users at lists.gforge.statsbiblioteket.dk
Subject: [Netarchivesuite-users]  SQL Exception
 
I found another broken pipe, but while trying access the jobs via web 
interface. And yes it was after a long inactivity. That happened with 
the patched getConnection Class. Is this Method used by all Classes?

24.05.2008 13:51:22 dk.netarkivet.common.webinterface.HTMLUtils 
generateHeader
FEIN: Loaded URL 'http://wc01:8070/HarvestDefinition/index.jsp' with 
title 'Main menu'
24.05.2008 13:51:25 dk.netarkivet.common.webinterface.HTMLUtils 
generateHeader
FEIN: Loaded URL 'http://wc01:8070/History/Harveststatus-alljobs.jsp' 
with title 'All Jobs'
24.05.2008 13:51:25 dk.netarkivet.harvester.datamodel.JobDBDAO getStatusInfo
WARNUNG: SQL error asking for job status list in database
com.mysql.jdbc.CommunicationsException: 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:2744)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
        at 
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
        at 
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
        at 
dk.netarkivet.harvester.datamodel.JobDBDAO.getStatusInfo(JobDBDAO.java:506)
        at 
dk.netarkivet.harvester.datamodel.JobDBDAO.getStatusInfo(JobDBDAO.java:583)
        at 
dk.netarkivet.harvester.webinterface.HarvestStatus.getjobStatusList(HarvestStatus.java:172)
        at 
org.apache.jsp.Harveststatus_002dalljobs_jsp._jspService(org.apache.jsp.Harveststatus_002dalljobs_jsp:138)
        at 
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:93)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
        at 
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:470)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:364)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at 
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
        at 
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:362)
        at 
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
        at 
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
        at 
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:722)
        at 
org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:404)
        at 
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
        at 
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
        at org.mortbay.jetty.Server.handle(Server.java:324)
        at 
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
        at 
org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:828)
        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:514)
        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
        at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
        at 
org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)
        at 
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450)


** END NESTED EXCEPTION **



Last packet sent to the server was 0 ms ago.
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2759)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)

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