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

Job rescheduling: duplicate key value violates unique constraint "job_configs_pkey"

    XMLWordPrintable

Details

    • Bug
    • Resolution: Cannot Reproduce
    • Trivial
    • None
    • 3.20.0
    • None
    • None

    Description

      log4j:WARN No appenders could be found for logger (com.mchange.v2.log.MLog).
      log4j:WARN Please initialize the log4j system properly.
      Starting dk.netarkivet.harvester.scheduler.HarvestJobManager
      Version: 3.20.0 status CODEFREEZE (r2397)
      dk.netarkivet.harvester.scheduler.HarvestJobManager Running
      Jul 5, 2012 2:25:04 PM dk.netarkivet.harvester.datamodel.JobDBDAO rescheduleJob
      WARNING: SQL error rescheduling job in database
      SQLException trace:
      SQL State:23505
      Error Code:0
      org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "job_configs_pkey"
      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:257)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
      at dk.netarkivet.harvester.datamodel.JobDBDAO.rescheduleJob(JobDBDAO.java:983)
      at dk.netarkivet.harvester.scheduler.JobSupervisor.rescheduleLeftOverJobs(JobSupervisor.java:94)
      at dk.netarkivet.harvester.scheduler.JobSupervisor$1.run(JobSupervisor.java:63)
      at java.lang.Thread.run(Thread.java:619)
      End of SQLException trace
      org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "job_configs_pkey"
      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:257)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
      at dk.netarkivet.harvester.datamodel.JobDBDAO.rescheduleJob(JobDBDAO.java:983)
      at dk.netarkivet.harvester.scheduler.JobSupervisor.rescheduleLeftOverJobs(JobSupervisor.java:94)
      at dk.netarkivet.harvester.scheduler.JobSupervisor$1.run(JobSupervisor.java:63)
      at java.lang.Thread.run(Thread.java:619)
      Exception in thread "Thread-12" dk.netarkivet.common.exceptions.IOFailure: SQL error rescheduling job in database
      SQLException trace:
      SQL State:23505
      Error Code:0
      org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "job_configs_pkey"
      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:257)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
      at dk.netarkivet.harvester.datamodel.JobDBDAO.rescheduleJob(JobDBDAO.java:983)
      at dk.netarkivet.harvester.scheduler.JobSupervisor.rescheduleLeftOverJobs(JobSupervisor.java:94)
      at dk.netarkivet.harvester.scheduler.JobSupervisor$1.run(JobSupervisor.java:63)
      at java.lang.Thread.run(Thread.java:619)
      End of SQLException trace
      at dk.netarkivet.harvester.datamodel.JobDBDAO.rescheduleJob(JobDBDAO.java:997)
      at dk.netarkivet.harvester.scheduler.JobSupervisor.rescheduleLeftOverJobs(JobSupervisor.java:94)
      at dk.netarkivet.harvester.scheduler.JobSupervisor$1.run(JobSupervisor.java:63)
      at java.lang.Thread.run(Thread.java:619)
      Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "job_configs_pkey"
      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:257)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
      at dk.netarkivet.harvester.datamodel.JobDBDAO.rescheduleJob(JobDBDAO.java:983)
      ... 3 more

      Attachments

        Activity

          People

            svc Søren Vejrup Carlsen (Inactive)
            nicl@kb.dk Nicholas Clarke (Inactive)
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: