-
Defect
-
Resolution: Done
-
Blocker
-
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.
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.