Created from redmine issue https://projects.theforeman.org/issues/31669
Upstream bug assigned to jturel
There may be other issues fixed by this but the report we received from our user states that existing content hosts (prior to 6.9 upgrade) cannot be deleted / unregistered without getting an error like this:
2021-01-15T11:20:37 [E|bac|] PG::ForeignKeyViolation: ERROR: update or delete on table "hosts" violates foreign key constraint "fk_rails_4c747e18cb" on table "registration_facets"
| DETAIL: Key (id)=(8006) is still referenced from table "registration_facets".
Moving this bug to POST for triage into Satellite since the upstream issue https://projects.theforeman.org/issues/31669 has been resolved.
Hi Jonathon, can you please write me the complete reproducer steps. Firstly I would like to see the problem and then it will be reproduced with the proposed fix.
I am sorry it's not clear enough to me from comment #3
Hey Tomas, sorry for the confusion here. When I first saw the user's report I thought there was a more serious issue so I immediately cloned to bugzulla. I actually think the issue is specific to their environment and the fix delivered likely does not even affect a production environment (only dev!), so I am going to close this one out as NOTABUG considering we haven't had any similar reports from downstream or upstream.