Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.
Bug 1584874 - When upgrading from 6.2 to 6.3 content_source_id value is not migrated
When upgrading from 6.2 to 6.3 content_source_id value is not migrated
Status: CLOSED ERRATA
Product: Red Hat Satellite 6
Classification: Red Hat
Component: Upgrades (Show other bugs)
6.3.1
Unspecified Unspecified
unspecified Severity urgent (vote)
: 6.3.2
: Unused
Assigned To: Stephen Benjamin
Harshad More
: PrioBumpGSS, Regression, Triaged
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2018-05-31 16:34 EDT by Paul Dudley
Modified: 2018-06-19 16:17 EDT (History)
6 users (show)

See Also:
Fixed In Version: tfm-rubygem-katello-3.4.5.73-1
Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2018-06-19 16:17:05 EDT
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)


External Trackers
Tracker ID Priority Status Summary Last Updated
Foreman Issue Tracker 23781 None None None 2018-06-01 11:51 EDT
Red Hat Product Errata RHBA-2018:1950 None None None 2018-06-19 16:17 EDT

  None (edit)
Description Paul Dudley 2018-05-31 16:34:54 EDT
Description of problem:
When upgrading from 6.2 to 6.3 the content_source_id parameter from hosts is moved from the hosts table to the katello_content_facets table. As seen in the satellite.log form an upgrade here:

---
 -- add_column(:katello_content_facets, :content_source_id, :integer)
 -- add_index(:katello_content_facets, :content_source_id)
 -- add_foreign_key(:katello_content_facets, :smart_proxies, {:name=>"katello_content_facets_content_source_id_fk", :column=>"content_source_id"})
 -- remove_foreign_key(:hosts, {:name=>"hosts_content_source_id_fk"})
 -- remove_index(:hosts, :content_source_id)
 -- remove_column(:hosts, :content_source_id)
---

The problem here is that it doesn't appear that the value set for the content_source_id parameter in the hosts table is migrated to the katello_content_facets table when the new column is created. All values in the new column are blank.

For example:
===
6.2.14 (before upgrade)
foreman=# select count(id) from hosts where content_source_id is null;
 count 
-------
    24
(1 row)

foreman=# select count(id) from hosts where content_source_id is not null;
 count 
-------
   105
(1 row)
===
6.3.1 (after upgrade)
foreman=# select count(id) from katello_content_facets where content_source_id is null;
 count 
-------
   117
(1 row)

foreman=# select count(id) from katello_content_facets where content_source_id is not null;
 count 
-------
     0
(1 row)
===

Actual results:
Table values are not migrated

Expected results:
Table values are migrated and kept
Comment 3 Stephen Benjamin 2018-06-01 11:51:14 EDT
Created redmine issue http://projects.theforeman.org/issues/23781 from this bug
Comment 7 pm-sat@redhat.com 2018-06-01 14:06:18 EDT
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/23781 has been resolved.
Comment 11 errata-xmlrpc 2018-06-19 16:17:05 EDT
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHBA-2018:1950

Note You need to log in before you can comment on or make changes to this bug.