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

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.1.0, 2.2.0
• Fix Version/s: 2.1.0, 2.2.0
• Component/s: Traffic Ops API
• Assignee: Jeremy Mitchell
• Reporter: Robert Scrimo
• Created: 01/Aug/17 22:30
• Updated: 21/Aug/17 19:59
• Resolved: 21/Aug/17 19:59

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.

Issue Links

• links to: PR #824
• links to: PR #840