Project

General

Profile

Actions

Bug #23662

closed

Unable to promote content views due to 'null' value for timestamps.

Added by Rimma Ashkinadze almost 6 years ago. Updated almost 6 years ago.

Status:
Closed
Priority:
Normal
Category:
-
Target version:
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

Description

After an upgrade to Foreman 1.17 and Katello 3.6.0

Actions::Katello::Repository::IndexContent
Input:{"id"=>40715, "current_user_id"=>45}
Output:{}
Exception:
ActiveRecord::NotNullViolation: PG::NotNullViolation: ERROR: null value in column "created_at" violates not-null constraint
DETAIL: Failing row contains (279572806, 399867, 40715, null, null).
: insert into katello_repository_rpms (repository_id, rpm_id)
select 40715 as repository_id, rpm_id from katello_repository_rpms
where repository_id = 155539 and rpm_id not in (select rpm_id
from katello_repository_rpms where repository_id = 40715)

foreman=# \d katello_repository_rpms
Table "public.katello_repository_rpms"
Column | Type | Modifiers
---------------+-----------------------------+----------------------------------------------------------------------
id | integer | not null default nextval('katello_repository_rpms_id_seq'::regclass)
rpm_id | integer | not null
repository_id | integer |
created_at | timestamp without time zone | not null
updated_at | timestamp without time zone | not null
Indexes:
"katello_repository_rpms_pkey" PRIMARY KEY, btree (id)
"index_katello_repository_rpms_on_rpm_id_and_repository_id" UNIQUE, btree (rpm_id, repository_id)
"index_katello_repository_rpms_on_repository_id" btree (repository_id)
Foreign-key constraints:
"katello_repository_rpms_repository_id_fk" FOREIGN KEY (repository_id) REFERENCES katello_repositories(id)
"katello_repository_rpms_rpm_id_fk" FOREIGN KEY (rpm_id) REFERENCES katello_rpms(id)

Actions #1

Updated by Justin Sherrill almost 6 years ago

  • Project changed from Foreman to Katello
Actions #2

Updated by The Foreman Bot almost 6 years ago

  • Status changed from New to Ready For Testing
  • Assignee set to Justin Sherrill
  • Pull request https://github.com/Katello/katello/pull/7390 added
Actions #3

Updated by Jonathon Turel almost 6 years ago

  • translation missing: en.field_release set to 338
Actions #4

Updated by Justin Sherrill almost 6 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100
Actions

Also available in: Atom PDF