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

Database dies when job is done

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • None
    • 3.0
    • None

    Description

      During execution of simple_harvest a harvest of fnord.com with 3.2.1 dies when
      the job returns:
      Jul 3 2007 3:41:32 PM
      dk.netarkivet.harvester.distribute.HarvesterMessageHandler onMessage
      WARNING: Error processing message '
      Class: com.sun.messaging.jmq.jmsclient.ObjectMessageImpl
      getJMSMessageID(): ID:47-130.225.25.7(b7:91:53:cf:28:72)-45343-1183470092143
      getJMSTimestamp(): 1183470092143
      getJMSCorrelationID(): null
      JMSReplyTo: null
      JMSDestination: DEV_COMMON_THE_SCHED
      getJMSDeliveryMode(): PERSISTENT
      getJMSRedelivered(): false
      getJMSType(): null
      getJMSExpiration(): 0
      getJMSPriority(): 4
      Properties: null'
      dk.netarkivet.common.exceptions.IOFailure: SQL error while inserting harvest
      info Harvest info for harvest #1 of fnord.com(defaultconfig) on Tue Jul 03
      15:41:32 CEST 2007
      Status: DOWNLOAD_COMPLETE
      4objects / 8677bytes
      for Domain:fnord.com;
      Comment:;
      Configurations:
      defaultconfig;
      Seedlists:
      defaultseeds;
      Passwords:
      ---------------
      at
      dk.netarkivet.harvester.datamodel.DomainDBDAO.insertHarvestInfo(DomainDBDAO.java:624)
      at
      dk.netarkivet.harvester.datamodel.DomainDBDAO.updateHarvestInfo(DomainDBDAO.java:580)
      at
      dk.netarkivet.harvester.datamodel.DomainDBDAO.update(DomainDBDAO.java:256)
      at
      dk.netarkivet.harvester.scheduler.HarvestSchedulerMonitorServer.processCrawlData(HarvestSchedulerMonitorServer.java:274)
      at
      dk.netarkivet.harvester.scheduler.HarvestSchedulerMonitorServer.processCrawlStatusMessage(HarvestSchedulerMonitorServer.java:190)
      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:67)
      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:595)
      Caused by: SQL Exception: The statement was aborted because it would have caused
      a duplicate key value in a unique or primary key constraint or unique index
      identified by 'JOBCONFIGJOB' defined on 'JOB_CONFIGS'.
      at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
      at
      org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
      Source)
      at
      org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
      Source)
      at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
      Source)
      at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
      Source)
      at
      org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
      at
      org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
      at
      dk.netarkivet.harvester.datamodel.DomainDBDAO.insertHarvestInfo(DomainDBDAO.java:621)
      ... 12 more
      NOTE: This bug is originally from Bugzilla bug_id=1037.

      Attachments

        Activity

          People

            svc Søren Vejrup Carlsen (Inactive)
            lars lars [X] (Inactive)
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: