Cannot delete discovered host

I'm running 1.14.0

When trying to delete a discovered host I get the error:

Cannot delete or update a parent row: a foreign key constraint fails
(foreman.host_status,CONSTRAINT host_status_hosts_host_id_fk FOREIGN
KEY(host_id) REFERENCES hosts (id))

The host does not get removed :frowning:

How do I fix this?

Alright. I got rid of it by trying to provision it and deleting it out of
All Hosts.

··· On Wednesday, June 7, 2017 at 1:34:50 PM UTC-4, Robert Anderson wrote: > > I'm running 1.14.0 > > When trying to delete a discovered host I get the error: > > Cannot delete or update a parent row: a foreign key constraint fails > (`foreman`.`host_status`,CONSTRAINT `host_status_hosts_host_id_fk` FOREIGN > KEY(`host_id`) REFERENCES `hosts` (`id`)) > > The host does not get removed :( > > How do I fix this? >

Hey, known error in 1.14 series. Fixed in 1.15, discovery 9.1 tomorrow.

LZ

··· On Wed, Jun 7, 2017 at 10:51 PM, Robert Anderson wrote: > Alright. I got rid of it by trying to provision it and deleting it out of > All Hosts. > > > On Wednesday, June 7, 2017 at 1:34:50 PM UTC-4, Robert Anderson wrote: >> >> I'm running 1.14.0 >> >> When trying to delete a discovered host I get the error: >> >> Cannot delete or update a parent row: a foreign key constraint fails >> (`foreman`.`host_status`,CONSTRAINT `host_status_hosts_host_id_fk` FOREIGN >> KEY(`host_id`) REFERENCES `hosts` (`id`)) >> >> The host does not get removed :( >> >> How do I fix this? > > -- > You received this message because you are subscribed to the Google Groups > "Foreman users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to foreman-users+unsubscribe@googlegroups.com. > To post to this group, send email to foreman-users@googlegroups.com. > Visit this group at https://groups.google.com/group/foreman-users. > For more options, visit https://groups.google.com/d/optout.


Later,
Lukas @lzap Zapletal