Details
-
Bug
-
Resolution: Fixed
-
Minor
-
None
-
None
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)