Uploaded image for project: 'Gateway'
  1. Gateway
  2. GTWY-1241

Changeset for GTWY-1143 will not run against the prototype ESG database.

XMLWordPrintable

    • Icon: Defect Defect
    • Resolution: Done
    • Icon: Blocker Blocker
    • 1.0.0-BETA2
    • 1.0.0-BETA1
    • None
    • None

      When trying to update a copy of the current ESG prototype database an error occurs. (thus wouldn't work against a real update scenario).

      BUILD FAILED
      /home/wilhelmi/workspaces/3.5-default/ESG-CET-Trunk/Ant/liquibase-tasks.ant.xml:135: liquibase.exception.MigrationFailedException: Migration failed for change set /Liquibase/update/changesets/20100119-SGF-1143.xml::20100119-SGF-1143::luca:
           Reason: liquibase.exception.JDBCException: Error executing SQL INSERT INTO metadata.resource (id, name, description, type_id) VALUES('e76ab355-91a0-48a2-a5da-7e34204eb5b9', 'CCSM run b30.044g', 'CCSM 3.0IPCC SRES A1B 720 ppm stabilization scenarioCCSM 3.0 IPCC SRES A1B 720 ppm stabilization scenario', 2):
                Caused By: Error executing SQL INSERT INTO metadata.resource (id, name, description, type_id) VALUES('e76ab355-91a0-48a2-a5da-7e34204eb5b9', 'CCSM run b30.044g', 'CCSM 3.0IPCC SRES A1B 720 ppm stabilization scenarioCCSM 3.0 IPCC SRES A1B 720 ppm stabilization scenario', 2):
                Caused By: ERROR: duplicate key value violates unique constraint "pkey"

      Steps to reproduce:

      1) Back a copy of the current deployed ESG system.
      2) Restore the database on a local instance of postgres.
      3) Run the liquibase updates against the local copy (contexts: core, esg_ncar).
      4) Error message returned.

              luca Luca Cinquini (Inactive)
              wilhelmi Nathan Wilhelmi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: