Bug #15038
closedmigrate_foreman error upgrading from 6.1 to 6.2 -> error: users.helptips_enabled does not exist
Description
Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1335675
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]...