Details
-
Bug
-
Resolution: Cannot Reproduce
-
Blocker
-
None
-
I47
-
None
-
None
Description
WARNING: SQL error updating database with sql: ALTER TABLE configurations ADD COLUMN maxobjects_new bigint NOT NULL DEFAULT -1 SQLException trace: SQL State:X0Y32 Error Code:-1 java.sql.SQLException: Column 'MAXOBJECTS_NEW' already exists in Table/View '"APP"."CONFIGURATIONS"'. at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) at org.apache.derby.client.am.PreparedStatement.executeUpdate(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105) at dk.netarkivet.common.utils.DBUtils.executeSQL(DBUtils.java:889) at dk.netarkivet.harvester.datamodel.HarvestDBConnection.updateTable(HarvestDBConnection.java:152) at dk.netarkivet.harvester.datamodel.DerbySpecifics.migrateConfigurationsv4tov5(DerbySpecifics.java:321) at dk.netarkivet.harvester.datamodel.DBSpecifics.updateTable(DBSpecifics.java:224) at dk.netarkivet.harvester.datamodel.DomainDBDAO.<init>(DomainDBDAO.java:93) at dk.netarkivet.harvester.datamodel.DomainDAO.getInstance(DomainDAO.java:58) at dk.netarkivet.harvester.tools.HarvestdatabaseUpdateApplication.main(HarvestdatabaseUpdateApplication.java:48)
and here is the current prod schema for this table:
CREATE TABLE "APP"."CONFIGURATIONS" ("CONFIG_ID" BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1), "NAME" VARCHAR(300) NOT NULL, "COMMENTS" VARCHAR(30000), "DOMAIN_ID" BIGINT NOT NULL, "TEMPLATE_ID" BIGINT NOT NULL, "MAXOBJECTS" INTEGER, "MAXRATE" INTEGER, "OVERRIDELIMITS" INTEGER, "MAXBYTES" BIGINT DEFAULT -1);