Details
-
Bug
-
Resolution: Fixed
-
Blocker
-
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
- related to
-
NAS-1810 Camel-case table names in SQL scripts and DBSpecifics classes
- Resolved