I verified the fix in PR and confirm that it works for New creaated host_status records. The database still had host_status records with type=NULL to be cleaned manual following the KB. After the manual cleanup and with the new PR it works
Moving to POST as upstream PR is merged.
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory (Satellite 6.9.4 Async Bug Fix Update), and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2021:2948
NOTE: If users continue to experience the error outlined in this bug after updating to Satellite 6.9.4 please execute the following: 1) Launch the console from a root shell on the Satellite: # foreman-rake console: 2) Run the following command: HostStatus::Status.where(type: nil).delete_all 3) Exit shell via the 'exit' command 4) resume operations
This bug is not fully resolved, see the follow-on bug here we are tracking to get a fix ASAP: https://bugzilla.redhat.com/show_bug.cgi?id=2004144 we expect to ship a fix for this on Sept 23rd, 2021
*** Bug 1965710 has been marked as a duplicate of this bug. ***
The needinfo request[s] on this closed bug have been removed as they have been unresolved for 500 days