Bug #6216: Trying to delete a subnet that is associated with a host group throws foreign key error - Foreman

Actions

Copy link

Bug #6216

closed

Trying to delete a subnet that is associated with a host group throws foreign key error

Added by Dominic Cleal over 10 years ago. Updated over 6 years ago.

Status:

Closed

Priority:

Low

Assignee:

Joseph Magen

Category:

Rails

Target version:

1.5.2

Difficulty:

Triaged:

Bugzilla link:

1109315

Pull request:

Fixed in Releases:

Found in Releases:

Red Hat JIRA:

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1109315
Description of problem:

Version-Release number of selected component (if applicable):

How reproducible:

Steps to Reproduce:
1. Manually create a subnet ('mysubnet', 192.168.100.1, 255.255.255.0)
2. Associate this subnet with a hostgroup
3. Try to delete the subnet

Actual results:
Oops, we're sorry but something went wrong

×
Error

ERROR: update or delete on table "subnets" violates foreign key constraint "hostgroups_subnet_id_fk" on table "hostgroups" DETAIL: Key (id)=(2) is still referenced from table "hostgroups".
If you feel this is an error with Foreman itself, please open a new issue with Foreman ticketing system, You would probably need to attach the Full trace and relevant log entries.

Expected results:
A handled exception and perhaps a UI block on trying to delete a subnet that is already associated.

Additional info:

Actions

Copy link

Updated by Dominic Cleal over 10 years ago

Category set to Rails

Missing an EnsureNotUsedBy.new(:hostgroups) on the subnet. Worth double checking all other foreign keys have similar before_destroy hooks for friendly errors.

Actions

Copy link