[jira] [Assigned] (TC-492) Deleting Delivery Service with associated static dns entry(s) in staticdnsentry table fails due to foreign key constraint violation

["Jeremy Mitchell (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TC-492?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jeremy Mitchell reassigned TC-492:
----------------------------------

    Assignee: Jeremy Mitchell

> 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
>            Assignee: Jeremy Mitchell
>            Priority: Critical
>
> 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: Use the UI 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)