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

SQL truncation error in RunningJobsInfoDBDAO storeFrontierReport()

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 3.16.1
    • 3.14.0
    • Harvest Monitor
    • None
    • NARK-35

    • Confident

    Description

      Jan 10 2011 1:25:00 PM dk.netarkivet.harvester.datamodel.RunningJobsInfoDBDAO storeFrontierReport
      WARNING: SQL error writing records for job ID 751 and filterId TopTotalEnqueuesFilter
      SQLException trace:
      SQL State:XJ208
      Error Code:20000
      org.apache.derby.client.am.BatchUpdateException: Non-atomic batch failure. The batch was submitted but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements.
      at org.apache.derby.client.am.Agent.endBatchedReadChain(Unknown Source)
      at org.apache.derby.client.am.PreparedStatement.executeBatchRequestX(Unknown Source)
      at org.apache.derby.client.am.PreparedStatement.executeBatchX(Unknown Source)
      at org.apache.derby.client.am.PreparedStatement.executeBatch(Unknown Source)
      at dk.netarkivet.harvester.datamodel.RunningJobsInfoDBDAO.storeFrontierReport(RunningJobsInfoDBDAO.java:796)
      at dk.netarkivet.harvester.harvesting.monitor.HarvestMonitorServer.visit(HarvestMonitorServer.java:209)
      at dk.netarkivet.harvester.harvesting.distribute.FrontierReportMessage.accept(FrontierReportMessage.java:63)
      at dk.netarkivet.harvester.distribute.HarvesterMessageHandler.onMessage(HarvesterMessageHandler.java:73)
      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: org.apache.derby.client.am.SqlException: Error for batch element #10: A truncation error was encountered trying to shrink VARCHAR 'http://www.emailguide.dk/forward302.aspx?nepc=eWpDPeDkCn7%2f&' to length 1000.
      at org.apache.derby.client.am.Statement.completeExecute(Unknown Source)
      at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown Source)
      at org.apache.derby.client.net.NetStatementReply.readExecute(Unknown Source)
      at org.apache.derby.client.net.StatementReply.readExecute(Unknown Source)
      at org.apache.derby.client.net.NetPreparedStatement.readExecute_(Unknown Source)
      at org.apache.derby.client.am.PreparedStatement.readExecute(Unknown Source)
      ... 12 more

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 14h
                14h
                Remaining:
                Remaining Estimate - 14h
                14h
                Logged:
                Time Spent - Not Specified
                Not Specified