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

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16138716#comment-16138716
 ] 

ASF GitHub Bot commented on TC-491:
---

Github user rawlinp closed the pull request at:

https://github.com/apache/incubator-trafficcontrol/pull/856


> 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, 2.2.0
>Reporter: Robert Scrimo
>Assignee: Jeremy Mitchell
>Priority: Critical
> Fix For: 2.1.0, 2.2.0
>
>
> 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 UI/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)

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

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16138709#comment-16138709
 ] 

ASF GitHub Bot commented on TC-491:
---

Github user hbeatty commented on the issue:

https://github.com/apache/incubator-trafficcontrol/pull/856
  
@rawlinp Thank you for renaming your branch. This has been merged. Please 
close.


> 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, 2.2.0
>Reporter: Robert Scrimo
>Assignee: Jeremy Mitchell
>Priority: Critical
> Fix For: 2.1.0, 2.2.0
>
>
> 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 UI/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)

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

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16138481#comment-16138481
 ] 

ASF GitHub Bot commented on TC-491:
---

Github user asfgit commented on the issue:

https://github.com/apache/incubator-trafficcontrol/pull/856
  

Refer to this link for build results (access rights to CI server needed): 

https://builds.apache.org/job/incubator-trafficcontrol-PR-trafficops-test/85/



> 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, 2.2.0
>Reporter: Robert Scrimo
>Assignee: Jeremy Mitchell
>Priority: Critical
> Fix For: 2.1.0, 2.2.0
>
>
> 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 UI/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)

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

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16138475#comment-16138475
 ] 

ASF GitHub Bot commented on TC-491:
---

Github user rawlinp commented on the issue:

https://github.com/apache/incubator-trafficcontrol/pull/856
  
@hbeatty renamed my branch and recreated the PR


> 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, 2.2.0
>Reporter: Robert Scrimo
>Assignee: Jeremy Mitchell
>Priority: Critical
> Fix For: 2.1.0, 2.2.0
>
>
> 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 UI/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)

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

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16138472#comment-16138472
 ] 

ASF GitHub Bot commented on TC-491:
---

GitHub user rawlinp opened a pull request:

https://github.com/apache/incubator-trafficcontrol/pull/856

[BACKPORT] [TC-491] [TC-492] - Fix SQL error in downgrade scripts

(cherry picked from commit 4a5962ed53720c6ff2286979a71161e782d725e7)

You can merge this pull request into a Git repository by running:

$ git pull https://github.com/rawlinp/incubator-trafficcontrol 
backport-sql-fix

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafficcontrol/pull/856.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #856


commit e9880975207de5364702da27f4c9929648a0ccbd
Author: Rawlin Peters 
Date:   2017-08-21T22:45:54Z

Fix SQL error in downgrade scripts

(cherry picked from commit 4a5962ed53720c6ff2286979a71161e782d725e7)




> 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, 2.2.0
>Reporter: Robert Scrimo
>Assignee: Jeremy Mitchell
>Priority: Critical
> Fix For: 2.1.0, 2.2.0
>
>
> 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 UI/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)

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

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16138466#comment-16138466
 ] 

ASF GitHub Bot commented on TC-491:
---

Github user rawlinp closed the pull request at:

https://github.com/apache/incubator-trafficcontrol/pull/851


> 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, 2.2.0
>Reporter: Robert Scrimo
>Assignee: Jeremy Mitchell
>Priority: Critical
> Fix For: 2.1.0, 2.2.0
>
>
> 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 UI/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)

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

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16138401#comment-16138401
 ] 

ASF GitHub Bot commented on TC-491:
---

Github user hbeatty commented on the issue:

https://github.com/apache/incubator-trafficcontrol/pull/851
  
@rawlinp Can you please rename your branch?


> 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, 2.2.0
>Reporter: Robert Scrimo
>Assignee: Jeremy Mitchell
>Priority: Critical
> Fix For: 2.1.0, 2.2.0
>
>
> 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 UI/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)

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

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16136901#comment-16136901
 ] 

ASF GitHub Bot commented on TC-491:
---

Github user asfgit commented on the issue:

https://github.com/apache/incubator-trafficcontrol/pull/851
  

Refer to this link for build results (access rights to CI server needed): 
https://builds.apache.org/job/incubator-trafficcontrol-PR/116/



> 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, 2.2.0
>Reporter: Robert Scrimo
>Assignee: Jeremy Mitchell
>Priority: Critical
> Fix For: 2.1.0, 2.2.0
>
>
> 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 UI/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)

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

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16136895#comment-16136895
 ] 

ASF GitHub Bot commented on TC-491:
---

Github user asfgit commented on the issue:

https://github.com/apache/incubator-trafficcontrol/pull/851
  

Refer to this link for build results (access rights to CI server needed): 

https://builds.apache.org/job/incubator-trafficcontrol-PR-trafficops-test/76/



> 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, 2.2.0
>Reporter: Robert Scrimo
>Assignee: Jeremy Mitchell
>Priority: Critical
> Fix For: 2.1.0, 2.2.0
>
>
> 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 UI/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)

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

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16135692#comment-16135692
 ] 

ASF GitHub Bot commented on TC-491:
---

Github user mitchell852 commented on the issue:

https://github.com/apache/incubator-trafficcontrol/pull/840
  
manually closing


> 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, 2.2.0
>Reporter: Robert Scrimo
>Assignee: Jeremy Mitchell
>Priority: Critical
> Fix For: 2.1.0, 2.2.0
>
>
> 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 UI/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)

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

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16135693#comment-16135693
 ] 

ASF GitHub Bot commented on TC-491:
---

Github user mitchell852 closed the pull request at:

https://github.com/apache/incubator-trafficcontrol/pull/840


> 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, 2.2.0
>Reporter: Robert Scrimo
>Assignee: Jeremy Mitchell
>Priority: Critical
> Fix For: 2.1.0, 2.2.0
>
>
> 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 UI/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)

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

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16135487#comment-16135487
 ] 

ASF GitHub Bot commented on TC-491:
---

Github user hbeatty commented on the issue:

https://github.com/apache/incubator-trafficcontrol/pull/840
  
@mitchell852 merged - please close


> 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, 2.2.0
>Reporter: Robert Scrimo
>Assignee: Jeremy Mitchell
>Priority: Critical
> Fix For: 2.1.0, 2.2.0
>
>
> 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 UI/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)

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

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16135231#comment-16135231
 ] 

ASF GitHub Bot commented on TC-491:
---

Github user asfgit commented on the issue:

https://github.com/apache/incubator-trafficcontrol/pull/840
  

Refer to this link for build results (access rights to CI server needed): 
https://builds.apache.org/job/incubator-trafficcontrol-PR/101/



> 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, 2.2.0
>Reporter: Robert Scrimo
>Assignee: Jeremy Mitchell
>Priority: Critical
> Fix For: 2.1.0, 2.2.0
>
>
> 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 UI/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)

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

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16135224#comment-16135224
 ] 

ASF GitHub Bot commented on TC-491:
---

Github user asfgit commented on the issue:

https://github.com/apache/incubator-trafficcontrol/pull/840
  
FAILURE
 No test results found.



> 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, 2.2.0
>Reporter: Robert Scrimo
>Assignee: Jeremy Mitchell
>Priority: Critical
> Fix For: 2.1.0, 2.2.0
>
>
> 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 UI/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)

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

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16135225#comment-16135225
 ] 

ASF GitHub Bot commented on TC-491:
---

Github user asfgit commented on the issue:

https://github.com/apache/incubator-trafficcontrol/pull/840
  

Refer to this link for build results (access rights to CI server needed): 

https://builds.apache.org/job/incubator-trafficcontrol-traffic_ops-test-PR/63/



> 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, 2.2.0
>Reporter: Robert Scrimo
>Assignee: Jeremy Mitchell
>Priority: Critical
> Fix For: 2.1.0, 2.2.0
>
>
> 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 UI/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)

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

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16135222#comment-16135222
 ] 

ASF GitHub Bot commented on TC-491:
---

Github user asfgit commented on the issue:

https://github.com/apache/incubator-trafficcontrol/pull/840
  

Refer to this link for build results (access rights to CI server needed): 

https://builds.apache.org/job/incubator-trafficcontrol-PR-trafficops-test/61/



> 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, 2.2.0
>Reporter: Robert Scrimo
>Assignee: Jeremy Mitchell
>Priority: Critical
> Fix For: 2.1.0, 2.2.0
>
>
> 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 UI/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)

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

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16135214#comment-16135214
 ] 

ASF GitHub Bot commented on TC-491:
---

GitHub user mitchell852 opened a pull request:

https://github.com/apache/incubator-trafficcontrol/pull/840

[BACKPORT] [TC-491] [TC-492]deletes applicable staticdnsentries and 
jobs when a ds is deleted

cherry pick of b7b293718c0ca8174dba5759c01301208d5c6a78

You can merge this pull request into a Git repository by running:

$ git pull https://github.com/mitchell852/incubator-trafficcontrol 
2.1.x-tc-491-492

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafficcontrol/pull/840.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #840






> 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, 2.2.0
>Reporter: Robert Scrimo
>Assignee: Jeremy Mitchell
>Priority: Critical
> Fix For: 2.1.0, 2.2.0
>
>
> 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 UI/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)

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

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16129376#comment-16129376
 ] 

ASF GitHub Bot commented on TC-491:
---

Github user asfgit commented on the issue:

https://github.com/apache/incubator-trafficcontrol/pull/824
  

Refer to this link for build results (access rights to CI server needed): 
https://builds.apache.org/job/incubator-trafficcontrol-PR/83/



> 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, 2.2.0
>Reporter: Robert Scrimo
>Assignee: Jeremy Mitchell
>Priority: Critical
> Fix For: 2.1.0, 2.2.0
>
>
> 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 UI/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)

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

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16129369#comment-16129369
 ] 

ASF GitHub Bot commented on TC-491:
---

Github user asfgit commented on the issue:

https://github.com/apache/incubator-trafficcontrol/pull/824
  

Refer to this link for build results (access rights to CI server needed): 

https://builds.apache.org/job/incubator-trafficcontrol-traffic_ops-test-PR/45/



> 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, 2.2.0
>Reporter: Robert Scrimo
>Assignee: Jeremy Mitchell
>Priority: Critical
> Fix For: 2.1.0, 2.2.0
>
>
> 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 UI/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)

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

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16129367#comment-16129367
 ] 

ASF GitHub Bot commented on TC-491:
---

Github user asfgit commented on the issue:

https://github.com/apache/incubator-trafficcontrol/pull/824
  

Refer to this link for build results (access rights to CI server needed): 

https://builds.apache.org/job/incubator-trafficcontrol-PR-trafficops-test/43/



> 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, 2.2.0
>Reporter: Robert Scrimo
>Assignee: Jeremy Mitchell
>Priority: Critical
> Fix For: 2.1.0, 2.2.0
>
>
> 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 UI/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)

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

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16129365#comment-16129365
 ] 

ASF GitHub Bot commented on TC-491:
---

GitHub user mitchell852 opened a pull request:

https://github.com/apache/incubator-trafficcontrol/pull/824

[TC-491] [TC-492] - deletes applicable staticdnsentries and jobs when a ds 
is deleted



You can merge this pull request into a Git repository by running:

$ git pull https://github.com/mitchell852/incubator-trafficcontrol 
tc-492-staticdnsentry-cascade-delete

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafficcontrol/pull/824.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #824


commit bf048b657ae745b993e4a76e50c491d3c5436327
Author: Jeremy Mitchell 
Date:   2017-08-16T20:32:14Z

deletes applicable staticdnsentries and jobs when a ds is deleted




> 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, 2.2.0
>Reporter: Robert Scrimo
>Assignee: Jeremy Mitchell
>Priority: Critical
> Fix For: 2.1.0, 2.2.0
>
>
> 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 UI/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)

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

[Jeremy Mitchell (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16128807#comment-16128807
 ] 

Jeremy Mitchell commented on TC-491:


[~hbeatty] - yes, it should be fixed. i'm working on it.

> 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
>Assignee: Jeremy Mitchell
>Priority: Critical
>
> 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 UI/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)

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

[Hank Beatty (JIRA)]

[ 
https://issues.apache.org/jira/browse/TC-491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16128726#comment-16128726
 ] 

Hank Beatty commented on TC-491:


[~mitchell...@apache.org] Is this something that needs to be fixed in 2.1 or 
can it wait until 2.2?

> 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
>Assignee: Jeremy Mitchell
>Priority: Critical
>
> 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 UI/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)