[jira] [Created] (TC-491) Deleting Delivery Service with associated job in job table fails due to foreign key constraint violation

["Robert Scrimo (JIRA)" <ji...@apache.org>]

Robert Scrimo created TC-491:
--------------------------------

             Summary: Deleting Delivery Service with associated job in job table fails due to foreign key constraint violation
                 Key: TC-491
                 URL: https://issues.apache.org/jira/browse/TC-491
             Project: Traffic Control
          Issue Type: Bug
          Components: Traffic Ops API
    Affects Versions: 2.1.0
            Reporter: Robert Scrimo


Deleting Delivery Service with associated job in job table fails due to foreign key constraint violation.

E.g.
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_job_deliveryservice1" on table "job"
DETAIL:  Key (id)=(714) is still referenced from table "job". [for Statement "DELETE FROM deliveryservice WHERE ( id = ? )" with ParamValues: 1='714'] at /opt/traffic_ops/app/lib/API/Deliveryservice.pm line 642

Workaround: No API end-point to delete the associated job.  Delete associated job from database.

NOTE: Other Traffic Ops versions may also be affected.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)