[
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16138481#comment-16138481
]
ASF GitHub Bot commented on TC-491:
-----------------------------------
Github user asfgit commented on the issue:
https://github.com/apache/incubator-trafficcontrol/pull/856
Refer to this link for build results (access rights to CI server needed):
https://builds.apache.org/job/incubator-trafficcontrol-PR-trafficops-test/85/
> 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)
