Uploaded image for project: 'NetarchiveSuite'
  1. NetarchiveSuite
  2. NAS-1060

Database connections to MySQL close down intermittently

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • None
    • 3.4
    • Harvester Controller Server
    • None

    Description

      Running NetarchiveSuite with MySQL 5.0.45 and mysql-connector-java-5.0.8-bin.jar
      as JDBC connector Peter Moser gets the following error:
      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

      Attachments

        Activity

          People

            ngiraud Nicolas Giraud (Inactive)
            svc Søren Vejrup Carlsen (Inactive)
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: