Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.
Red Hat Satellite engineering is moving the tracking of its product development work on Satellite to Red Hat Jira (issues.redhat.com). If you're a Red Hat customer, please continue to file support cases via the Red Hat customer portal. If you're not, please head to the "Satellite project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs will be migrated starting at the end of May. If you cannot log in to RH Jira, please consult article #7032570. That failing, please send an e-mail to the RH Jira admins at rh-issues@redhat.com to troubleshoot your issue as a user management inquiry. The email creates a ServiceNow ticket with Red Hat. Individual Bugzilla bugs that are migrated will be moved to status "CLOSED", resolution "MIGRATED", and set with "MigratedToJIRA" in "Keywords". The link to the successor Jira issue will be found under "Links", have a little "two-footprint" icon next to it, and direct you to the "Satellite project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/SAT-XXXX", where "X" is a digit). This same link will be available in a blue banner at the top of the page informing you that that bug has been migrated.

Bug 1335675

Summary: migrate_foreman error upgrading from 6.1 to 6.2 -> error: users.helptips_enabled does not exist
Product: Red Hat Satellite Reporter: Brad Buckingham <bbuckingham>
Component: ProvisioningAssignee: Brad Buckingham <bbuckingham>
Status: CLOSED ERRATA QA Contact: Sachin Ghai <sghai>
Severity: high Docs Contact:
Priority: unspecified    
Version: 6.2.0CC: cwelton, ehelms, sghai
Target Milestone: UnspecifiedKeywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: foreman-1.11.0.28-1 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-07-27 11:04:01 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
katello.log during upgrade none

Description Brad Buckingham 2016-05-12 20:35:59 UTC
Created attachment 1156881 [details]
katello.log during upgrade

Description of problem:

Attempting to upgrade to an early version of Satellite 6.2 Beta (internal build) from 6.1 is resulting in an error during foreman_migrate.

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

Satellite 6.2 Snap 11

How reproducible:

Always

Steps to Reproduce:
1. install Satellite 6.1
2. update packages to Satellite 6.2
3. patch system to include fixes for bug 1334961
4. satellite-installer --scenario satellite --upgrade --force

Actual results:

# foreman-installer --upgrade
Upgrading...
Upgrade Step: stop_services...
Upgrade Step: start_databases...
Upgrade Step: update_http_conf...
Upgrade Step: migrate_pulp...
Upgrade Step: start_httpd...
Upgrade Step: migrate_candlepin...
Upgrade Step: migrate_foreman...
Upgrade step migrate_foreman failed. Check logs for more information.

Expected results:

No error during the migrate_foreman step.

Additional info:

Note: see attached log for complete installer run.

In the /var/log/foreman-installer/satellite.log, the following is observed:

...[snip]...

PG::Error: ERROR:  column users.helptips_enabled does not exist
LINE 1: ...word_salt" AS t0_r11, "users"."locale" AS t0_r12, "users"."h...
                                                             ^
: SELECT "users"."id" AS t0_r0, "users"."login" AS t0_r1, "users"."firstname" AS t0_r2, "users"."lastname" AS t0_r3, "users"."mail" AS t0_r4, "users"."admin" AS t0_r5, "users"."last_login_on" AS t0_r6, "users"."auth_source_id" AS t0_r7, "users"."created_at" AS t0_r8, "users"."updated_at" AS t0_r9, "users"."password_hash" AS t0_r10, "users"."password_salt" AS t0_r11, "users"."locale" AS t0_r12, "users"."helptips_enabled" AS t0_r13, "users"."page_size" AS t0_r14, "users"."disabled" AS t0_r15, "users"."preferences" AS t0_r16, "users"."remote_id" AS t0_r17, "users"."avatar_hash" AS t0_r18, "users"."default_organization_id" AS t0_r19, "users"."default_location_id" AS t0_r20, "users"."lower_login" AS t0_r21, "users"."mail_enabled" AS t0_r22, "users"."timezone" AS t0_r23, "usergroups"."id" AS t1_r0, "usergroups"."name" AS t1_r1, "usergroups"."created_at" AS t1_r2, "usergroups"."updated_at" AS t1_r3, "usergroups"."admin" AS t1_r4 FROM "users" LEFT OUTER JOIN "cached_usergroup_members" ON "cached_usergroup_members"."user_id" = "users"."id" LEFT OUTER JOIN "usergroups" ON "usergroups"."id" = "cached_usergroup_members"."usergroup_id" WHERE (users.admin = 't' OR usergroups.admin = 't')  ORDER BY firstname/opt/rh/rh-ror41/root/usr/share/gems/gems/activerecord-4.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:822:in `exec'

...[snip]...

/usr/share/foreman/db/migrate/20150612105614_rename_taxonomy_ignored_type_to_provisioning_templates.rb:22:in `block in swap_name'

...[snip]...

Comment 2 Brad Buckingham 2016-05-13 01:27:25 UTC
Created redmine issue http://projects.theforeman.org/issues/15038 from this bug

Comment 3 Brad Buckingham 2016-05-13 01:38:56 UTC
Upstream foreman PR: https://github.com/theforeman/foreman/pull/3522

Comment 4 Bryan Kearney 2016-05-13 02:15:21 UTC
Upstream bug component is Provisioning

Comment 6 Sachin Ghai 2016-06-14 05:52:17 UTC
Verified with upgrade from sat6.1.9 -> sat6.2 GA snap15.2

I don't see this issue whil performing upgrade with 15.2. upgrade was completed successfully.

[root@qe-sat6-upgrade-rhel7 yum.repos.d]# satellite-installer --scenario satellite --upgrade 
Upgrading...
Upgrade Step: stop_services...
Upgrade Step: start_databases...
Upgrade Step: update_http_conf...
Upgrade Step: migrate_pulp...
Upgrade Step: fix_pulp_httpd_conf...
Upgrade Step: start_httpd...
Upgrade Step: start_qpidd...
Upgrade Step: start_pulp...
Upgrade Step: migrate_candlepin...
Upgrade Step: start_tomcat...
Upgrade Step: fix_katello_settings_file...
Upgrade Step: migrate_foreman...
Upgrade Step: remove_nodes_distributors...
Upgrade Step: Running installer...
Installing             Done                                               [100%] [..................................................................]
  The full log is at /var/log/foreman-installer/satellite.log
Upgrade Step: restart_services...
Upgrade Step: db_seed...
Upgrade Step: import_package_groups (this may take a while) ...
Upgrade Step: import_rpms (this may take a while) ...
Upgrade Step: import_distributions (this may take a while) ...
Upgrade Step: import_puppet_modules (this may take a while) ...
Upgrade Step: import_subscriptions (this may take a while) ...
Upgrade Step: elasticsearch_message...
Elasticsearch has been removed as a dependency.  The database files can be removed manually with #rm -rf /var/lib/elasticsearch.  Some packages are no longer needed and can be removed:  #rpm -e ruby193-rubygem-tire tfm-rubygem-tire elasticsearch sigar-java sigar snappy-java lucene4-contrib lucene4
Upgrade Step: remove_docker_v1_content (this may take a while) ...
Upgrade Step: update_puppet_repository_distributors (this may take a while) ...
Upgrade Step: remove_gutterball...
Katello upgrade completed!

Comment 7 Bryan Kearney 2016-07-27 11:04:01 UTC
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-2016:1501