Bug #23662
closedUnable to promote content views due to 'null' value for timestamps.
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)
Updated by Justin Sherrill over 6 years ago
- Project changed from Foreman to Katello
Updated by The Foreman Bot over 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
Updated by Jonathon Turel over 6 years ago
- Translation missing: en.field_release set to 338
Updated by Justin Sherrill over 6 years ago
- Status changed from Ready For Testing to Closed
- % Done changed from 0 to 100
Applied in changeset katello|31b9d1da4ef29a15bba73f71b743690dbdcc5256.