Project

General

Profile

Actions

Bug #34944

closed

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 over 2 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
High
Assignee:
Category:
Errata Management
Target version:
Difficulty:
Triaged:
Yes
Fixed in Releases:
Found in Releases:

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

Actions #1

Updated by The Foreman Bot over 2 years ago

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

Updated by Ian Ballou over 2 years ago

  • 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"
  • Target version set to Katello 4.4.1
  • Triaged changed from No to Yes
Actions #3

Updated by Ian Ballou over 2 years ago

  • Target version changed from Katello 4.4.1 to Katello 4.5.0
Actions #4

Updated by The Foreman Bot over 2 years ago

  • Fixed in Releases Katello 4.5.0 added
Actions #5

Updated by Samir Jha over 2 years ago

  • Status changed from Ready For Testing to Closed
Actions

Also available in: Atom PDF