[
https://issues.apache.org/jira/browse/TC-492?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Robert Scrimo updated TC-492:
-----------------------------
Description:
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.
was:
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 to remove the association(s) before
deleting the delivery service.
NOTE: Other versions of Traffic Ops may be affected.
> 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
> 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)
