You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafficcontrol.apache.org by "Robert Scrimo (JIRA)" <ji...@apache.org> on 2017/08/01 22:31:00 UTC
[jira] [Created] (TC-492) Deleting Delivery Service with associated
static dns entry(s) in staticdnsentry table fails due to foreign key
constraint violation
Robert Scrimo created TC-492:
--------------------------------
Summary: Deleting Delivery Service with associated static dns entry(s) in staticdnsentry table fails due to foreign key constraint violation
Key: TC-492
URL: https://issues.apache.org/jira/browse/TC-492
Project: Traffic Control
Issue Type: Bug
Components: Traffic Ops API
Affects Versions: 2.1.0
Reporter: Robert Scrimo
Deleting Delivery Service with associated static dns entry in staticdnsentry table fails due to foreign key constraint violation.
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_staticdnsentry_ds" on table "staticdnsentry"
DETAIL: Key (id)=(180) is still referenced from table "staticdnsentry". [for Statement "DELETE FROM deliveryservice WHERE ( id = ? )" with ParamValues: 1='180'] at /opt/traffic_ops/app/lib/API/Deliveryservice.pm line 642
Workaround: A hack is to use the UI end-point GET "/staticdnsentry/:id/delete" to remove the association(s) before deleting the delivery service.
NOTE: Other versions of Traffic Ops may be affected.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)