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

SQL error when updating harvest database schema

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Blocker
    • I47
    • I47
    • None
    • None

    Description

      Not sure what happened here - the DBUpdate code must have tried to create the new table twice.

      May 4, 2011 10:23:01 AM dk.netarkivet.common.utils.DBUtils getTableVersion
      WARNING: Unknown table 'runningjobsmonitor'
      May 4, 2011 10:23:01 AM dk.netarkivet.harvester.datamodel.DBSpecifics updateTable
      INFO: Trying to migrate table 'runningjobsmonitor' from version '0' to version '2'.
      May 4, 2011 10:23:01 AM dk.netarkivet.harvester.datamodel.HarvestDBConnection updateTable
      INFO: Updating table 'runningjobsmonitor' to version 1
      May 4, 2011 10:23:01 AM dk.netarkivet.common.utils.DBUtils executeSQL
      FINE: Executing SQL-statement: CREATE TABLE runningJobsMonitor (jobId bigint NOT NULL, harvestName varchar(300) NOT NULL,hostUrl varchar(300) NOT NULL,progress numeric NOT NULL,queuedFilesCount bigint NOT NULL,totalQueuesCount bigint NOT NULL,activeQueuesCount bigint NOT NULL,exhaustedQueuesCount bigint NOT NULL,elapsedSeconds bigint NOT NULL,alertsCount bigint NOT NULL,downloadedFilesCount bigint NOT NULL,currentProcessedKBPerSec integer NOT NULL,processedKBPerSec integer NOT NULL,currentProcessedDocsPerSec numeric NOT NULL,processedDocsPerSec numeric NOT NULL,activeToeCount integer NOT NULL,status integer NOT NULL,tstamp timestamp NOT NULL, PRIMARY KEY (jobId, harvestName))
      May 4, 2011 10:23:03 AM dk.netarkivet.common.utils.DBUtils executeSQL
      WARNING: SQL error updating database with sql: CREATE TABLE runningJobsMonitor (jobId bigint NOT NULL, harvestName varchar(300) NOT NULL,hostUrl varchar(300) NOT NULL,progress numeric NOT NULL,queuedFilesCount bigint NOT NULL,totalQueuesCount bigint NOT NULL,activeQueuesCount bigint NOT NULL,exhaustedQueuesCount bigint NOT NULL,elapsedSeconds bigint NOT NULL,alertsCount bigint NOT NULL,downloadedFilesCount bigint NOT NULL,currentProcessedKBPerSec integer NOT NULL,processedKBPerSec integer NOT NULL,currentProcessedDocsPerSec numeric NOT NULL,processedDocsPerSec numeric NOT NULL,activeToeCount integer NOT NULL,status integer NOT NULL,tstamp timestamp NOT NULL, PRIMARY KEY (jobId, harvestName))
      SQLException trace:
      SQL State:X0Y32
      Error Code:-1
      java.sql.SQLException: Table/View 'RUNNINGJOBSMONITOR' already exists in Schema 'APP'.
      

      Attachments

        Issue Links

          Activity

            People

              svc Søren Vejrup Carlsen (Inactive)
              csr Colin Rosenthal
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: