Plugins » Katello

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1122736
Description of problem:
I tried to delete a host and received a trace. Afterwards I could not view the host details though I could see it in the host list

Version-Release number of selected component (if applicable):
ruby193-rubygem-katello-1.5.0-65.el6sat.noarch

How reproducible:
Uncertain, but based on the additional info, probably always

Steps to Reproduce:
1. Create an Activation Key
2. Create a Host and include the activation key

Actual results:
Can't delete the host without error

Expected results:
Host should delete as expected

Additional info:
I had to do the following:
delete from hosts where id = 7;
ERROR: update or delete on table "hosts" violates foreign key constraint "katello_systems_host_id" on table "katello_systems"
DETAIL: Key (id)=(7) is still referenced from table "katello_systems".

delete from katello_systems where id = 11;
ERROR: update or delete on table "katello_systems" violates foreign key constraint "system_activation_keys_system_id_fk" on table "katello_system_activation_keys"
DETAIL: Key (id)=(11) is still referenced from table "katello_system_activation_keys".

foreman=# delete from katello_system_activation_keys where id = 11;
DELETE 1
foreman=# delete from katello_systems where id = 11;
DELETE 1
foreman=# delete from hosts where id = 7;
DELETE 1
foreman=# \q