[Netarchivesuite-users] SQL Exception

Peter Moser pemo at gmx.at
Fri May 23 09:15:44 CEST 2008


Another strange thing seems to be happen sometimes and I do not know what the  reason is. The message says that the connection to the db is broken and there couldn't be written any data. The Job in the Userinterface is still shown as submitted although it is not running anymore. This happens at a one-machine installation with Version 3.4.1 and the current trunk version.
Do you know what I can do to avoid this error? See enclosed my log file entry! Thanks again in advance.

onID:279091-127.0.0.1(80:4d:58:62:77:cc)-36587-1211515663558: To PROD_COMMON_THE_ARCREPOS ReplyTo PROD_ONB_THE_BAMON OK' sent from BA monitor to queue: '[Queue 'PROD_COMMON_THE_ARCREPOS']'
23.05.2008 06:07:43 dk.netarkivet.archive.arcrepository.ArcRepository replyOK
INFO: Store OK: '3-metadata-1.arc'
23.05.2008 06:07:43 dk.netarkivet.common.distribute.JMSConnection reply
INFO: Sending message to PROD_COMMON_THIS_HACO_127_0_0_1_8075ID = ID:8829-127.0.0.1(93:76:7:d0:1e:23)-40133-1211515663358
23.05.2008 06:07:44 dk.netarkivet.harvester.distribute.HarvesterMessageHandler onMessage
WARNUNG: Error processing message '
Class:                  com.sun.messaging.jmq.jmsclient.ObjectMessageImpl
getJMSMessageID():      ID:8832-127.0.0.1(93:76:7:d0:1e:23)-40133-1211515664866
getJMSTimestamp():      1211515664866
getJMSCorrelationID():  null
JMSReplyTo:             null
JMSDestination:         PROD_COMMON_THE_SCHED
getJMSDeliveryMode():   PERSISTENT
getJMSRedelivered():    false
getJMSType():           null
getJMSExpiration():     0
getJMSPriority():       4
Properties:             null'
dk.netarkivet.common.exceptions.IOFailure: Error preparing SQL statement SELECT COUNT(*) FROM jobs WHERE job_id = ? args [Ljava.lang.Object;@bd492b
        at dk.netarkivet.harvester.datamodel.DBConnect.selectLongValue(DBConnect.java:190)
        at dk.netarkivet.harvester.datamodel.JobDBDAO.exists(JobDBDAO.java:207)
        at dk.netarkivet.harvester.datamodel.JobDBDAO.read(JobDBDAO.java:306)
        at dk.netarkivet.harvester.scheduler.HarvestSchedulerMonitorServer.processCrawlStatusMessage(HarvestSchedulerMonitorServer.java:103)
        at dk.netarkivet.harvester.scheduler.HarvestSchedulerMonitorServer.visit(HarvestSchedulerMonitorServer.java:285)
        at dk.netarkivet.harvester.harvesting.distribute.CrawlStatusMessage.accept(CrawlStatusMessage.java:133)
        at dk.netarkivet.harvester.distribute.HarvesterMessageHandler.onMessage(HarvesterMessageHandler.java:69)
        at com.sun.messaging.jmq.jmsclient.MessageConsumerImpl.deliverAndAcknowledge(MessageConsumerImpl.java:330)
        at com.sun.messaging.jmq.jmsclient.MessageConsumerImpl.onMessage(MessageConsumerImpl.java:265)
        at com.sun.messaging.jmq.jmsclient.SessionReader.deliver(SessionReader.java:102)
        at com.sun.messaging.jmq.jmsclient.ConsumerReader.run(ConsumerReader.java:174)
        at java.lang.Thread.run(Thread.java:619)
Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:


** 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: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.DBConnect.selectLongValue(DBConnect.java:156)
        at dk.netarkivet.harvester.datamodel.DBConnect.selectLongValue(DBConnect.java:188)
        at dk.netarkivet.harvester.datamodel.JobDBDAO.exists(JobDBDAO.java:207)
        at dk.netarkivet.harvester.datamodel.JobDBDAO.read(JobDBDAO.java:306)
        at dk.netarkivet.harvester.scheduler.HarvestSchedulerMonitorServer.processCrawlStatusMessage(HarvestSchedulerMonitorServer.java:103)
        at dk.netarkivet.harvester.scheduler.HarvestSchedulerMonitorServer.visit(HarvestSchedulerMonitorServer.java:285)
        at dk.netarkivet.harvester.harvesting.distribute.CrawlStatusMessage.accept(CrawlStatusMessage.java:133)
        at dk.netarkivet.harvester.distribute.HarvesterMessageHandler.onMessage(HarvesterMessageHandler.java:69)
        at com.sun.messaging.jmq.jmsclient.MessageConsumerImpl.deliverAndAcknowledge(MessageConsumerImpl.java:330)
        at com.sun.messaging.jmq.jmsclient.MessageConsumerImpl.onMessage(MessageConsumerImpl.java:265)
        at com.sun.messaging.jmq.jmsclient.SessionReader.deliver(SessionReader.java:102)
        at com.sun.messaging.jmq.jmsclient.ConsumerReader.run(ConsumerReader.java:174)
        at java.lang.Thread.run(Thread.java:619)


** END NESTED EXCEPTION **



Last packet sent to the server was 0 ms ago.

STACKTRACE:

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.DBConnect.selectLongValue(DBConnect.java:156)
        at dk.netarkivet.harvester.datamodel.DBConnect.selectLongValue(DBConnect.java:188)
        at dk.netarkivet.harvester.datamodel.JobDBDAO.exists(JobDBDAO.java:207)
        at dk.netarkivet.harvester.datamodel.JobDBDAO.read(JobDBDAO.java:306)
        at dk.netarkivet.harvester.scheduler.HarvestSchedulerMonitorServer.processCrawlStatusMessage(HarvestSchedulerMonitorServer.java:103)
        at dk.netarkivet.harvester.scheduler.HarvestSchedulerMonitorServer.visit(HarvestSchedulerMonitorServer.java:285)
        at dk.netarkivet.harvester.harvesting.distribute.CrawlStatusMessage.accept(CrawlStatusMessage.java:133)
        at dk.netarkivet.harvester.distribute.HarvesterMessageHandler.onMessage(HarvesterMessageHandler.java:69)
        at com.sun.messaging.jmq.jmsclient.MessageConsumerImpl.deliverAndAcknowledge(MessageConsumerImpl.java:330)
        at com.sun.messaging.jmq.jmsclient.MessageConsumerImpl.onMessage(MessageConsumerImpl.java:265)
        at com.sun.messaging.jmq.jmsclient.SessionReader.deliver(SessionReader.java:102)
        at com.sun.messaging.jmq.jmsclient.ConsumerReader.run(ConsumerReader.java:174)
        at java.lang.Thread.run(Thread.java:619)


** 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)
        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.DBConnect.selectLongValue(DBConnect.java:156)
        at dk.netarkivet.harvester.datamodel.DBConnect.selectLongValue(DBConnect.java:188)
        at dk.netarkivet.harvester.datamodel.JobDBDAO.exists(JobDBDAO.java:207)
        at dk.netarkivet.harvester.datamodel.JobDBDAO.read(JobDBDAO.java:306)
        at dk.netarkivet.harvester.scheduler.HarvestSchedulerMonitorServer.processCrawlStatusMessage(HarvestSchedulerMonitorServer.java:103)
        at dk.netarkivet.harvester.scheduler.HarvestSchedulerMonitorServer.visit(HarvestSchedulerMonitorServer.java:285)
        at dk.netarkivet.harvester.harvesting.distribute.CrawlStatusMessage.accept(CrawlStatusMessage.java:133)
        at dk.netarkivet.harvester.distribute.HarvesterMessageHandler.onMessage(HarvesterMessageHandler.java:69)
        at com.sun.messaging.jmq.jmsclient.MessageConsumerImpl.deliverAndAcknowledge(MessageConsumerImpl.java:330)
        at com.sun.messaging.jmq.jmsclient.MessageConsumerImpl.onMessage(MessageConsumerImpl.java:265)
        at com.sun.messaging.jmq.jmsclient.SessionReader.deliver(SessionReader.java:102)
        at com.sun.messaging.jmq.jmsclient.ConsumerReader.run(ConsumerReader.java:174)
        at java.lang.Thread.run(Thread.java:619)


** END NESTED EXCEPTION **


        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888)
        at com.mysql.jdbc.Connection.checkClosed(Connection.java:1932)
        at com.mysql.jdbc.Connection.prepareStatement(Connection.java:4768)
        at com.mysql.jdbc.Connection.prepareStatement(Connection.java:4734)
        at dk.netarkivet.harvester.datamodel.DBConnect.prepareStatement(DBConnect.java:234)
        at dk.netarkivet.harvester.datamodel.DBConnect.selectLongValue(DBConnect.java:186)
        ... 11 more
23.05.2008 06:07:46 dk.netarkivet.harvester.sidekick.SideKick run
INFO: HarvestControllerServer has terminated.
23.05.2008 06:07:46 dk.netarkivet.harvester.sidekick.SideKick runShellScript
INFO: Starting script
23.05.2008 06:07:46 dk.netarkivet.harvester.sidekick.SideKick run
INFO: HarvestControllerServer has been restarted.
23.05.2008 06:07:51 dk.netarkivet.harvester.sidekick.SideKick run
INFO: HarvestControllerServer is running.
23.05.2008 08:50:25 dk.netarkivet.harvester.datamodel.DBConnect getDBConnection

-- 
GMX startet ShortView.de. Hier findest Du Leute mit Deinen Interessen!
Jetzt dabei sein: http://www.shortview.de/?mc=sv_ext_mf@gmx



More information about the NetarchiveSuite-users mailing list