Bug #34944
closedUpgrade to Satellite 6.10.5.1 fails with error message "PG::NotNullViolation: ERROR: null value in column "erratum_package_id" violates not-null constraint"
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