Bug 2055312

Summary:	Enabling ISO type repository fails with PG::NotNullViolation: ERROR
Product:	Red Hat Satellite	Reporter:	Vladimír Sedmík <vsedmik>
Component:	Repositories	Assignee:	Ryan Verdile <rverdile>
Status:	CLOSED ERRATA	QA Contact:	addubey
Severity:	high	Docs Contact:
Priority:	unspecified
Version:	6.11.0	CC:	addubey, ahumbe, jsherril, pcreech
Target Milestone:	6.11.0	Keywords:	Regression, Triaged
Target Release:	Unused
Hardware:	x86_64
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:
Clones:	2061780 (view as bug list)		Environment:
Last Closed:	2022-07-05 14:33:19 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Vladimír Sedmík 2022-02-16 16:34:10 UTC

Description of problem:
Enabling an ISO type repository fails with PG::NotNullViolation: ERROR


Version-Release number of selected component (if applicable):
7.0.0 snap 9


How reproducible:
always


Steps to Reproduce:
1. Have a blank SAT, upload manifest into the Default Organization
2. In UI go to Content > Red Hat Repositories
3. Select 'Other' in the combo and try to enable any ISO (e.g rhel-7-server-satellite-6.4-isos)


Actual results:
This error is shown:
PG::NotNullViolation: ERROR: null value in column "root_id" violates not-null constraint DETAIL: Failing row contains (61, bcd54585-335d-4f20-a2e5-748c21595f95, null, 1, Default_Organization/Library/content/dist/rhel/server/7/7Server/..., 1, null, null, null, null, null, null, null, null, null, null, null, 1970-01-01 00:00:00, 1970-01-01 00:00:00, 1970-01-01 00:00:00).


Expected results:
No error or more descriptive error message.


Additional information:
It is a regression since 6.10.3, I was able to enable the ISO repo there.

Comment 2 Ryan Verdile 2022-03-07 20:47:14 UTC

Created redmine issue https://projects.theforeman.org/issues/34568 from this bug

Comment 3 Justin Sherrill 2022-03-08 13:42:23 UTC

This was caused by https://bugzilla.redhat.com/show_bug.cgi?id=2024894  which means its a regression in 6.10.3.  Proposing for 6.10.z

Comment 8 errata-xmlrpc 2022-07-05 14:33:19 UTC

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 (Moderate: Satellite 6.11 Release), 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/RHSA-2022:5498