My last input above did not do the trick for me. What saved me was the content from this article:
And more precisely, following what was entered above by @Vii-98.
DELETE FROM fact_values WHERE host_id=‘354’;
DELETE FROM host_puppet_facets WHERE host_id=‘354’;
DELETE FROM host_facets_reported_data_facets WHERE host_id=‘354’;
DELETE FROM nics WHERE host_id=‘354’;
DELETE FROM reports WHERE host_id=‘354’;
DELETE FROM host_status WHERE host_id=‘354’;
DELETE FROM hosts WHERE id=‘354’;
That resolved my issue.