Uploaded image for project: 'Traffic Control'
  1. Traffic Control
  2. TC-492

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

    XMLWordPrintableJSON

    Details

    • 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
    • Labels:
      None

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mitchell852@apache.org Jeremy Mitchell
                Reporter:
                rscrimojr Robert Scrimo
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: