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

Error in update of table "configurations"

    XMLWordPrintable

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);
      

      Attachments

        Activity

          People

            csr Colin Rosenthal
            csr Colin Rosenthal
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: