Description of problem: I am unable delete the discovered hosts from foreman, when I attempt to do it, I am getting following error. I have also ensured environment set to non discover (production) and cancelled any build in progress. Warning! ERROR: update or delete on table "hosts" violates foreign key constraint "discovery_attribute_sets_host_id_fk" on table "discovery_attribute_sets" DETAIL: Key (id)=(2) is still referenced from table "discovery_attribute_sets". Logged a case with foreman team and they have suggested to log a BUG here, please see foreman notes on the issue below: "There is now a related fix by lzap and hopefully it will be merged soon: https://github.com/theforeman/foreman_discovery/pull/161 This fix isn't enough to solve your problem, staypuft needs to change the code for assigning hosts to use the change. More information here: http://projects.theforeman.org/issues/9546. You can open up an issue for staypuft to make the needed change here: https://bugzilla.redhat.com/buglist.cgi?component=rubygem-staypuft&list_id=3263530&product=Red%20Hat%20OpenStack" Version-Release number of selected component (if applicable): Installed foreman-version: foreman-1.7.2-1.el6.noarch ruby193-rubygem-foreman_discovery-2.0.0-0.1.rc2.el6.noarch foreman-installer-staypuft-0.5.6-1.el6.noarch foreman-installer-staypuft-client-0.5.6-1.el6.noarch ruby193-rubygem-staypuft-0.5.19-2.el6.noarch How reproducible: Steps to Reproduce: 1. 2. 3. Actual results: Expected results: Additional info:
Closing list of bugs for RHEL OSP Installer since its support cycle has already ended [0]. If there is some bug closed by mistake, feel free to re-open. For new deployments, please, use RHOSP director (starting with version 7). -- Jaromir Coufal -- Sr. Product Manager -- Red Hat OpenStack Platform [0] https://access.redhat.com/support/policy/updates/openstack/platform