Bug #38370: Can't delete hosts due to type null host statuses - Foreman

Actions

Copy link

Bug #38370

closed

Can't delete hosts due to type null host statuses

Added by Adam Lazik about 1 month ago. Updated 9 days ago.

Status:

Closed

Priority:

High

Assignee:

Adam Lazik

Category:

Target version:

Difficulty:

Triaged:

Yes

Bugzilla link:

Pull request:

https://github.com/theforeman/foreman/pull/10520

Fixed in Releases:

3.15.0

Found in Releases:

Red Hat JIRA:

SAT-26487

Description

{}hammer host delete --organization "example" --name "example.host.com"
Could not delete the host:
PG::ForeignKeyViolation: ERROR: update or delete on table "hosts" violates foreign key constraint "host_status_hosts_host_id_fk" on table "host_status"
DETAIL: Key (id)=(3724) is still referenced from table "host_status".

Removing the type null host status entries for the host workarounds the error.