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

ERROR: "4.9E-324" is out of range for type double precision

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • 4.1
    • None
    • Harvest Monitor
    • None
    • Hide

      1. Make a selective harvest of domain cewe-photobook.com with only seed http://www.cewe-photobook.com. Make sure that configuration is changed to only harvest 10 objects
      3. Check a warning in the GUI log stating this
      "Found illegal double value '4.9E-324'. Changed it to 0.0"

      Show
      1. Make a selective harvest of domain cewe-photobook.com with only seed http://www.cewe-photobook.com . Make sure that configuration is changed to only harvest 10 objects 3. Check a warning in the GUI log stating this "Found illegal double value '4.9E-324'. Changed it to 0.0"

    Description

      WARNING: SQL error writing records for job ID 172760 and filterId TopTotalEnqueuesFilter
      SQLException trace:
      SQL State:22003
      Error Code:0
      java.sql.BatchUpdateException: Batch entry 34 INSERT INTO frontierReportMonitor(jobId, filterId, tstamp, domainName, currentSize, totalEnqueues, sessionBalance, lastCost, averageCost, lastDequeueTime, wakeTime, totalSpend, totalBudget, errorCount, lastPeekUri, lastQueuedUri) VALUES ('172760','TopTotalEnqueuesFilter','2013-02-10 21:11:51.184000 +01:00:00','cewe-photobook.com','2','2','3000','0.0','4.9E-324','','','0','-1','0','dns:www.cewe-photobook.com','http://www.cewe-photobook.com/') was aborted. Call getNextException to see the cause.
      at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2569)
      at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:459)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1796)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2708)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
      at dk.netarkivet.harvester.datamodel.RunningJobsInfoDBDAO.storeFrontierReport(RunningJobsInfoDBDAO.java:875)
      at dk.netarkivet.harvester.harvesting.monitor.HarvestMonitor.visit(HarvestMonitor.java:215)
      at dk.netarkivet.harvester.harvesting.distribute.FrontierReportMessage.accept(FrontierReportMessage.java:65)
      at dk.netarkivet.harvester.distribute.HarvesterMessageHandler.onMessage(HarvesterMessageHandler.java:80)
      at com.sun.messaging.jmq.jmsclient.MessageConsumerImpl.deliverAndAcknowledge(MessageConsumerImpl.java:338)
      at com.sun.messaging.jmq.jmsclient.MessageConsumerImpl.onMessage(MessageConsumerImpl.java:273)
      at com.sun.messaging.jmq.jmsclient.SessionReader.deliver(SessionReader.java:113)
      at com.sun.messaging.jmq.jmsclient.ConsumerReader.run(ConsumerReader.java:186)
      at java.lang.Thread.run(Thread.java:619)
      NextException:
      SQL State:22003
      Error Code:0
      org.postgresql.util.PSQLException: ERROR: "4.9E-324" is out of range for type double precision
      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2708)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
      at dk.netarkivet.harvester.datamodel.RunningJobsInfoDBDAO.storeFrontierReport(RunningJobsInfoDBDAO.java:875)
      at dk.netarkivet.harvester.harvesting.monitor.HarvestMonitor.visit(HarvestMonitor.java:215)
      at dk.netarkivet.harvester.harvesting.distribute.FrontierReportMessage.accept(FrontierReportMessage.java:65)
      at dk.netarkivet.harvester.distribute.HarvesterMessageHandler.onMessage(HarvesterMessageHandler.java:80)
      at com.sun.messaging.jmq.jmsclient.MessageConsumerImpl.deliverAndAcknowledge(MessageConsumerImpl.java:338)
      at com.sun.messaging.jmq.jmsclient.MessageConsumerImpl.onMessage(MessageConsumerImpl.java:273)
      at com.sun.messaging.jmq.jmsclient.SessionReader.deliver(SessionReader.java:113)
      at com.sun.messaging.jmq.jmsclient.ConsumerReader.run(ConsumerReader.java:186)
      at java.lang.Thread.run(Thread.java:619)
      End of SQLException trace
      java.sql.BatchUpdateException: Batch entry 34 INSERT INTO frontierReportMonitor(jobId, filterId, tstamp, domainName, currentSize, totalEnqueues, sessionBalance, lastCost, averageCost, lastDequeueTime, wakeTime, totalSpend, totalBudget, errorCount, lastPeekUri, lastQueuedUri) VALUES ('172760','TopTotalEnqueuesFilter','2013-02-10 21:11:51.184000 +01:00:00','cewe-photobook.com','2','2','3000','0.0','4.9E-324','','','0','-1','0','dns:www.cewe-photobook.com','http://www.cewe-photobook.com/') was aborted. Call getNextException to see the cause.
      at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2569)
      at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:459)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1796)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2708)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
      at dk.netarkivet.harvester.datamodel.RunningJobsInfoDBDAO.storeFrontierReport(RunningJobsInfoDBDAO.java:875)

      Attachments

        Activity

          People

            svc Søren Vejrup Carlsen (Inactive)
            svc Søren Vejrup Carlsen (Inactive)
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: