-
Work Task
-
Resolution: Done
-
Major
-
None
-
None
The changeset 20100312-SGF-295.xml throws the following error when it runs:
/Users/hannah/Documents/workspace/gateway-webapp/Ant/liquibase-tasks.ant.xml:145: liquibase.exception.MigrationFailedException: Migration failed for change set /liquibase/update/changesets/20100312-SGF-295.xml::20100312-SGF-295::nch:
Reason: liquibase.exception.JDBCException: Error executing SQL ALTER TABLE metrics.file_download ADD CONSTRAINT fkey_file_download_2 FOREIGN KEY (file_access_point_id) REFERENCES metadata.file_access_point(id) ON DELETE CASCADE INITIALLY DEFERRED:
Caused By: Error executing SQL ALTER TABLE metrics.file_download ADD CONSTRAINT fkey_file_download_2 FOREIGN KEY (file_access_point_id) REFERENCES metadata.file_access_point(id) ON DELETE CASCADE INITIALLY DEFERRED:
Caused By: ERROR: insert or update on table "file_download" violates foreign key constraint "fkey_file_download_2"
Detail: Key (file_access_point_id)=(a620418f-e2c2-4f23-a1fa-22fb6ddec32d) is not present in table "file_access_point".
There have been files that have been physically removed from the CADIS database some of which were recorded in the metrics database before they were removed. These file entries must be removed from the metrics.file_download table.
/Users/hannah/Documents/workspace/gateway-webapp/Ant/liquibase-tasks.ant.xml:145: liquibase.exception.MigrationFailedException: Migration failed for change set /liquibase/update/changesets/20100312-SGF-295.xml::20100312-SGF-295::nch:
Reason: liquibase.exception.JDBCException: Error executing SQL ALTER TABLE metrics.file_download ADD CONSTRAINT fkey_file_download_2 FOREIGN KEY (file_access_point_id) REFERENCES metadata.file_access_point(id) ON DELETE CASCADE INITIALLY DEFERRED:
Caused By: Error executing SQL ALTER TABLE metrics.file_download ADD CONSTRAINT fkey_file_download_2 FOREIGN KEY (file_access_point_id) REFERENCES metadata.file_access_point(id) ON DELETE CASCADE INITIALLY DEFERRED:
Caused By: ERROR: insert or update on table "file_download" violates foreign key constraint "fkey_file_download_2"
Detail: Key (file_access_point_id)=(a620418f-e2c2-4f23-a1fa-22fb6ddec32d) is not present in table "file_access_point".
There have been files that have been physically removed from the CADIS database some of which were recorded in the metrics database before they were removed. These file entries must be removed from the metrics.file_download table.