[ https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16135148#comment-16135148 ]
ASF GitHub Bot commented on TC-491: ----------------------------------- Github user asfgit closed the pull request at: https://github.com/apache/incubator-trafficcontrol/pull/824 > Deleting Delivery Service with associated job in job table fails due to > foreign key constraint violation > -------------------------------------------------------------------------------------------------------- > > Key: TC-491 > URL: https://issues.apache.org/jira/browse/TC-491 > Project: Traffic Control > Issue Type: Bug > Components: Traffic Ops API > Affects Versions: 2.1.0, 2.2.0 > Reporter: Robert Scrimo > Assignee: Jeremy Mitchell > Priority: Critical > Fix For: 2.1.0, 2.2.0 > > > 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. -- This message was sent by Atlassian JIRA (v6.4.14#64029)