Description of problem:
Katello Monitor Event Queue encounters the following postgresql error:
PG::Error: ERROR: insert or update on table \"katello_subscription_facet_pools\" violates foreign key constraint \"katello_sub_facet_pools_sf_id_fk\"\nDETAIL: Key (subscription_facet_id)=(283617) is not present in table \"katello_subscription_facets\".\n: INSERT INTO \"katello_subscription_facet_pools\" (\"pool_id\", \"subscription_facet_id\") VALUES ($1, $2) RETURNING \"id\"
Version-Release number of selected component (if applicable):
Monitor Event Queue encounters this often, and normally continues running, but sometimes crashes. The crash may or may not be related to this error.
Steps to Reproduce:
1. Watch the output of the Monitor Event Queue
See the error
Connecting redmine issue http://projects.theforeman.org/issues/23096 from this bug
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/23096 has been resolved.
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, and where to find the updated
files, follow the link below.
If the solution does not work for you, open a new bug report.
*** Bug 1510665 has been marked as a duplicate of this bug. ***