[Netarchivesuite-users] SQL Exception

Søren Vejrup Carlsen svc at kb.dk
Fri May 23 12:17:04 CEST 2008


Hi Peter.
This looks like a MySQL issue.
What version of MySQL and MySQL connector are you using?

/Søren
> -----Original Message-----
> From: netarchivesuite-users-bounces at lists.gforge.statsbiblioteket.dk
> [mailto:netarchivesuite-users-bounces at lists.gforge.statsbiblio
> teket.dk]O
> n Behalf Of Peter Moser
> Sent: Friday, May 23, 2008 9:16 AM
> To: netarchivesuite-users at lists.gforge.statsbiblioteket.dk
> Subject: [Netarchivesuite-users] SQL Exception
> 
> 
> 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(DB
> Connect.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.HarvestSchedulerMonitorServe
> r.processCrawlStatusMessage(HarvestSchedulerMonitorServer.java:103)
>         at 
> dk.netarkivet.harvester.scheduler.HarvestSchedulerMonitorServe
> r.visit(HarvestSchedulerMonitorServer.java:285)
>         at 
> dk.netarkivet.harvester.harvesting.distribute.CrawlStatusMessa
> ge.accept(CrawlStatusMessage.java:133)
>         at 
> dk.netarkivet.harvester.distribute.HarvesterMessageHandler.onM
> essage(HarvesterMessageHandler.java:69)
>         at 
> com.sun.messaging.jmq.jmsclient.MessageConsumerImpl.deliverAnd
> Acknowledge(MessageConsumerImpl.java:330)
>         at 
> com.sun.messaging.jmq.jmsclient.MessageConsumerImpl.onMessage(
> MessageConsumerImpl.java:265)
>         at 
> com.sun.messaging.jmq.jmsclient.SessionReader.deliver(SessionR
> eader.java:102)
>         at 
> com.sun.messaging.jmq.jmsclient.ConsumerReader.run(ConsumerRea
> der.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(PreparedState
> ment.java:1332)
>         at 
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatemen
> t.java:1467)
>         at 
> dk.netarkivet.harvester.datamodel.DBConnect.selectLongValue(DB
> Connect.java:156)
>         at 
> dk.netarkivet.harvester.datamodel.DBConnect.selectLongValue(DB
> Connect.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.HarvestSchedulerMonitorServe
> r.processCrawlStatusMessage(HarvestSchedulerMonitorServer.java:103)
>         at 
> dk.netarkivet.harvester.scheduler.HarvestSchedulerMonitorServe
> r.visit(HarvestSchedulerMonitorServer.java:285)
>         at 
> dk.netarkivet.harvester.harvesting.distribute.CrawlStatusMessa
> ge.accept(CrawlStatusMessage.java:133)
>         at 
> dk.netarkivet.harvester.distribute.HarvesterMessageHandler.onM
> essage(HarvesterMessageHandler.java:69)
>         at 
> com.sun.messaging.jmq.jmsclient.MessageConsumerImpl.deliverAnd
> Acknowledge(MessageConsumerImpl.java:330)
>         at 
> com.sun.messaging.jmq.jmsclient.MessageConsumerImpl.onMessage(
> MessageConsumerImpl.java:265)
>         at 
> com.sun.messaging.jmq.jmsclient.SessionReader.deliver(SessionR
> eader.java:102)
>         at 
> com.sun.messaging.jmq.jmsclient.ConsumerReader.run(ConsumerRea
> der.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(PreparedState
> ment.java:1332)
>         at 
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatemen
> t.java:1467)
>         at 
> dk.netarkivet.harvester.datamodel.DBConnect.selectLongValue(DB
> Connect.java:156)
>         at 
> dk.netarkivet.harvester.datamodel.DBConnect.selectLongValue(DB
> Connect.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.HarvestSchedulerMonitorServe
> r.processCrawlStatusMessage(HarvestSchedulerMonitorServer.java:103)
>         at 
> dk.netarkivet.harvester.scheduler.HarvestSchedulerMonitorServe
> r.visit(HarvestSchedulerMonitorServer.java:285)
>         at 
> dk.netarkivet.harvester.harvesting.distribute.CrawlStatusMessa
> ge.accept(CrawlStatusMessage.java:133)
>         at 
> dk.netarkivet.harvester.distribute.HarvesterMessageHandler.onM
> essage(HarvesterMessageHandler.java:69)
>         at 
> com.sun.messaging.jmq.jmsclient.MessageConsumerImpl.deliverAnd
> Acknowledge(MessageConsumerImpl.java:330)
>         at 
> com.sun.messaging.jmq.jmsclient.MessageConsumerImpl.onMessage(
> MessageConsumerImpl.java:265)
>         at 
> com.sun.messaging.jmq.jmsclient.SessionReader.deliver(SessionR
> eader.java:102)
>         at 
> com.sun.messaging.jmq.jmsclient.ConsumerReader.run(ConsumerRea
> der.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(PreparedState
> ment.java:1332)
>         at 
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatemen
> t.java:1467)
>         at 
> dk.netarkivet.harvester.datamodel.DBConnect.selectLongValue(DB
> Connect.java:156)
>         at 
> dk.netarkivet.harvester.datamodel.DBConnect.selectLongValue(DB
> Connect.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.HarvestSchedulerMonitorServe
> r.processCrawlStatusMessage(HarvestSchedulerMonitorServer.java:103)
>         at 
> dk.netarkivet.harvester.scheduler.HarvestSchedulerMonitorServe
> r.visit(HarvestSchedulerMonitorServer.java:285)
>         at 
> dk.netarkivet.harvester.harvesting.distribute.CrawlStatusMessa
> ge.accept(CrawlStatusMessage.java:133)
>         at 
> dk.netarkivet.harvester.distribute.HarvesterMessageHandler.onM
> essage(HarvesterMessageHandler.java:69)
>         at 
> com.sun.messaging.jmq.jmsclient.MessageConsumerImpl.deliverAnd
> Acknowledge(MessageConsumerImpl.java:330)
>         at 
> com.sun.messaging.jmq.jmsclient.MessageConsumerImpl.onMessage(
> MessageConsumerImpl.java:265)
>         at 
> com.sun.messaging.jmq.jmsclient.SessionReader.deliver(SessionR
> eader.java:102)
>         at 
> com.sun.messaging.jmq.jmsclient.ConsumerReader.run(ConsumerRea
> der.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(D
> BConnect.java:234)
>         at 
> dk.netarkivet.harvester.datamodel.DBConnect.selectLongValue(DB
> Connect.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
> _______________________________________________
> NetarchiveSuite-users mailing list
> NetarchiveSuite-users at lists.gforge.statsbiblioteket.dk
> https://lists.gforge.statsbiblioteket.dk/mailman/listinfo/neta
rchivesuite-users




More information about the NetarchiveSuite-users mailing list