Bug 1563002 – Monitor Event Queue PG::Error

Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.

Bug 1563002 - Monitor Event Queue PG::Error

Summary:	Monitor Event Queue PG::Error

Status:	CLOSED ERRATA

Aliases:	None

Product:	Red Hat Satellite 6
Classification:	Red Hat
Component:	Subscription Management (Show other bugs)
Sub Component:
Version:	6.3.0
Hardware:	Unspecified Unspecified

Priority	unspecified Severity high (vote)
Target Milestone:	6.3.2
Target Release:	Unused
Assigned To:	Partha Aji
QA Contact:	Ranjan Kumar
Docs Contact:

URL:
Whiteboard:
Keywords:	Triaged

Duplicates:	1510665 (view as bug list)
Depends On:
Blocks:
	Show dependency tree / graph

Reported:	2018-04-02 17:46 EDT by Jason Dickerson
Modified:	2018-09-20 05:06 EDT (History)
CC List:	8 users (show)

See Also:
Fixed In Version:	tfm-rubygem-katello-3.4.5.69-1
Doc Type:	If docs needed, set a value
Doc Text:
Story Points:	---
Clone Of:
Clones:	1572303 (view as bug list)
Environment:
Last Closed:	2018-06-19 16:17:00 EDT
Type:	Bug
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

Attachments	(Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

External Trackers
Tracker	ID	Priority	Status	Summary	Last Updated
Foreman Issue Tracker	23096	None	None	None	2018-04-02 18:55 EDT
Red Hat Product Errata	RHBA-2018:1950	None	None	None	2018-06-19 16:17 EDT

Groups: None (edit)

Description Jason Dickerson 2018-04-02 17:46:20 EDT

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):


How reproducible:

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
2.
3.

Actual results:
See the error

Expected results:
no errors

Additional info:

Comment 1 Partha Aji 2018-04-02 18:55:15 EDT

Connecting redmine issue http://projects.theforeman.org/issues/23096 from this bug

Comment 3 pm-sat@redhat.com 2018-04-04 00:28:38 EDT

Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/23096 has been resolved.

Comment 10 errata-xmlrpc 2018-06-19 16:17:00 EDT

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.

https://access.redhat.com/errata/RHBA-2018:1950

Comment 11 Brad Buckingham 2018-06-25 14:49:04 EDT

*** Bug 1510665 has been marked as a duplicate of this bug. ***

Note You need to log in before you can comment on or make changes to this bug.