[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