Details
-
Bug
-
Status: Resolved
-
Critical
-
Resolution: Fixed
-
2.1.0, 2.2.0
-
None
Description
Deleting Delivery Service with associated job in job table fails due to foreign key constraint violation.
E.g.
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: update or delete on table "deliveryservice" violates foreign key constraint "fk_job_deliveryservice1" on table "job"
DETAIL: Key (id)=(714) is still referenced from table "job". [for Statement "DELETE FROM deliveryservice WHERE ( id = ? )" with ParamValues: 1='714'] at /opt/traffic_ops/app/lib/API/Deliveryservice.pm line 642
Workaround: No UI/API end-point to delete the associated job. Delete associated job from database.
NOTE: Other Traffic Ops versions may also be affected.