[jira] [Updated] (TC-492) Deleting Delivery Service with associated static dns entry(s) in staticdnsentry table fails due to foreign key constraint violation
[ https://issues.apache.org/jira/browse/TC-492?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hank Beatty updated TC-492: --- Affects Version/s: 2.2.0 > 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, 2.2.0 >Reporter: Robert Scrimo >Assignee: Jeremy Mitchell >Priority: Critical > Fix For: 2.1.0, 2.2.0 > > > 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)
[jira] [Updated] (TC-492) Deleting Delivery Service with associated static dns entry(s) in staticdnsentry table fails due to foreign key constraint violation
[ https://issues.apache.org/jira/browse/TC-492?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hank Beatty updated TC-492: --- Fix Version/s: 2.2.0 2.1.0 > 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, 2.2.0 >Reporter: Robert Scrimo >Assignee: Jeremy Mitchell >Priority: Critical > Fix For: 2.1.0, 2.2.0 > > > 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)
[jira] [Updated] (TC-492) Deleting Delivery Service with associated static dns entry(s) in staticdnsentry table fails due to foreign key constraint violation
[ 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)
[jira] [Updated] (TC-492) Deleting Delivery Service with associated static dns entry(s) in staticdnsentry table fails due to foreign key constraint violation
[ 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: 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. 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 end-point GET "/staticdnsentry/:id/delete" 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 > > 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. -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Updated] (TC-492) Deleting Delivery Service with associated static dns entry(s) in staticdnsentry table fails due to foreign key constraint violation
[ https://issues.apache.org/jira/browse/TC-492?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Scrimo updated TC-492: - Priority: Critical (was: Major) > 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: 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. -- This message was sent by Atlassian JIRA (v6.4.14#64029)