Project

General

Profile

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:
Category:
Errata Management
Target version:
Difficulty:
Triaged:
Yes
Bugzilla link:
Fixed in Releases:
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"

#3 Updated by Ian Ballou 10 months ago

  • Target version changed from Katello 4.4.1 to Katello 4.5.0

#4 Updated by The Foreman Bot 10 months ago

  • Fixed in Releases Katello 4.5.0 added

#5 Updated by Samir Jha 10 months ago

  • Status changed from Ready For Testing to Closed

Also available in: Atom PDF