Project

General

Profile

Bug #20581

in foreman db hosts table, lifecycle_environment_id and content_view_id are not updated.

Added by Brad Buckingham almost 5 years ago. Updated almost 4 years ago.

Status:
Resolved
Priority:
High
Category:
Hosts
Target version:
Difficulty:
Triaged:
Bugzilla link:
Pull request:
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1478420

Description of problem:
When host gets assigned different lifecycle environment or content view, via hammer or webui, values in hosts table of foreman db are not updated.

Values gets updated properly in cp_pool and in katello_systems, but than there are different values for tested host in hosts and katello_systems and cp_pool (in candlepin db) tables

Version-Release number of selected component (if applicable):
6.2.10

How reproducible:
100%

Steps to Reproduce:
1. provision a host
2. check values in foreman database
foreman=# select content_view_id,lifecycle_environment_id from hosts where name='snemeth-hosttable-test.sysmgmt.lan';
[ RECORD 1 ]-----------+--
content_view_id | 1
lifecycle_environment_id | 1

3.change lifecycle environment and content view in webui or using hammer

4. verify hosts table entry in db.

Actual results:

hosts table not updated

katello_systems and cp_pool updated as expected.
Expected results:
update hosts table as well.

History

#1 Updated by Brad Buckingham almost 5 years ago

  • Subject changed from [Satellite 6] in foreman db hosts table, lifecycle_environment_id and content_view_id are not updated. to [Satellite 6] in foreman db hosts table, lifecycle_environment_id and content_view_id are not updated.
  • Assignee set to John Mitsch
  • Target version set to 208

#2 Updated by Eric Helms almost 5 years ago

  • Status changed from New to Assigned
  • Priority changed from Normal to High
  • Legacy Backlogs Release (now unused) set to 286

#3 Updated by John Mitsch almost 5 years ago

  • Subject changed from [Satellite 6] in foreman db hosts table, lifecycle_environment_id and content_view_id are not updated. to in foreman db hosts table, lifecycle_environment_id and content_view_id are not updated.

#4 Updated by Brad Buckingham over 4 years ago

  • Target version changed from 208 to 213

#5 Updated by John Mitsch over 4 years ago

  • Status changed from Assigned to New

#6 Updated by John Mitsch over 4 years ago

  • Assignee deleted (John Mitsch)

#7 Updated by Eric Helms over 4 years ago

  • Legacy Backlogs Release (now unused) changed from 286 to 295

#8 Updated by Brad Buckingham over 4 years ago

  • Assignee set to Brad Buckingham

#9 Updated by Brad Buckingham over 4 years ago

  • Status changed from New to Resolved
  • Legacy Backlogs Release (now unused) changed from 295 to 166

I tested this out on Katello master branch and it is no longer reproducable; therefore, going to close it out.

Also available in: Atom PDF