Bug #34944: Upgrade to Satellite 6.10.5.1 fails with error message "PG::NotNullViolation: ERROR: null value in column "erratum_package_id" violates not-null constraint" - Katello - Foreman

Bug #34944

Upgrade to Satellite 6.10.5.1 fails with error message "PG::NotNullViolation: ERROR: null value in column "erratum_package_id" violates not-null constraint"

Added by Samir Jha 10 months ago. Updated 10 months ago.

Status:

Closed

Priority:

High

Assignee:

Samir Jha

Category:

Errata Management

Target version:

Katello 4.5.0

Difficulty:

Triaged:

Yes

Bugzilla link:

2087727

Pull request:

https://github.com/Katello/katello/pull/10122

Fixed in Releases:

Katello 4.5.0

Found in Releases:

Red Hat JIRA:

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=2087727

Description of problem:

ActiveRecord::NotNullViolation: PG::NotNullViolation: ERROR: null value in column "erratum_package_id" violates not-null constraint
DETAIL: Failing row contains (6951, 391, null, 2021-09-01 15:01:50.648184, 2022-05-18 08:36:49.305383).

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

satellite-6.10.5.1-1.el7sat.noarch

Actual results:

Upgrade fails at db migrate stage

Expected results:

Upgrade should be successful.

Additional info:

Following bugzilla related to "20220303160220_remove_duplicate_errata.rb" which is resolved in RHBA-2022:2203. However, it looks hitting the similar error for a different table.

https://bugzilla.redhat.com/show_bug.cgi?id=2075519
https://bugzilla.redhat.com/show_bug.cgi?id=2081931

Associated revisions

Revision 7c5825fa (diff)
Added by Samir Jha 10 months ago

Fixes #34944 - Don't run update if erratum_package doesn't exist (#10122)

History

#1 Updated by The Foreman Bot 10 months ago

Assignee set to Samir Jha
Status changed from New to Ready For Testing
Pull request https://github.com/Katello/katello/pull/10122 added

#2 Updated by Ian Ballou 10 months ago

Triaged changed from No to Yes
Target version set to Katello 4.4.1
Subject changed from Upgrade to Satellite 6.10.5.1 fails with error message "PG::NotNullViolation: ERROR: null value in column "erratum_package_id" violates not-null constraint" to Upgrade to Satellite 6.10.5.1 fails with error message "PG::NotNullViolation: ERROR: null value in column "erratum_package_id" violates not-null constraint"