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

    • Type: Defect
    • Resolution: Done
    • Priority: Blocker
    • 1.0.0-BETA2
    • Affects Version/s: 1.0.0-BETA1
    • Component/s: 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.

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

                Created:
                Updated:
                Resolved: