Description of problem:

{}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.

How reproducible:{}

Hard

Is this issue a regression from an earlier version:{}

No

Steps to Reproduce:

can not reproduce as the issue is only observed on the customer's side

Actual behavior:

It seems like something is populating the type nil host status  for orphaned hosts. Deleting them will hit above error.

Expected behavior:

Hosts can be deleted and there should be no type null host status generated at all.

Business Impact / Additional info: