Bug 1652909

Connecting redmine issue https://projects.theforeman.org/issues/25544 from this bug

VERIFIED

Version tested:
Satellite 6.5 snap 6

Upgrade Step: migrate_foreman...
<trimmed>

 == 20180618195941 AddDescriptionToRepository: migrating =======================
 -- add_column(:katello_repositories, :description, :text, {:null=>true})
    -> 0.0165s
 == 20180618195941 AddDescriptionToRepository: migrated (0.0167s) ==============
 
 == 20180622105300 AddDockerTagsWhitelistToRepository: migrating ===============
 -- add_column(:katello_repositories, :docker_tags_whitelist, :text)
    -> 0.0012s
 == 20180622105300 AddDockerTagsWhitelistToRepository: migrated (0.0015s) ======
 
 == 20180625082051 RemoveAssociationsFromPtableSnippets: migrating =============
 == 20180625082051 RemoveAssociationsFromPtableSnippets: migrated (0.0302s) ====
 
 == 20180702102759 RemoveParamsValueLimit: migrating ===========================
 -- adapter_name()
    -> 0.0000s
 -- clear_cache!()
    -> 0.0000s
 -- quote_table_name(:parameters)
    -> 0.0001s
 -- execute("ALTER TABLE \"parameters\" ALTER COLUMN \"value\" TYPE text")
    -> 0.0034s
 -- adapter_name()
    -> 0.0000s
 -- clear_cache!()
    -> 0.0001s
 -- quote_table_name(:lookup_values)
    -> 0.0001s
 -- execute("ALTER TABLE \"lookup_values\" ALTER COLUMN \"value\" TYPE text")
    -> 0.0089s
 -- adapter_name()
    -> 0.0000s
 -- clear_cache!()
    -> 0.0000s
 -- quote_table_name(:lookup_keys)
    -> 0.0001s
 -- execute("ALTER TABLE \"lookup_keys\" ALTER COLUMN \"default_value\" TYPE text")
    -> 0.0032s
 == 20180702102759 RemoveParamsValueLimit: migrated (0.0175s) ==================
 
 == 20180705164601 RemoveLegacyPuppetHostnameSetting: migrating ================
 == 20180705164601 RemoveLegacyPuppetHostnameSetting: migrated (0.0102s) =======
 
 == 20180705191153 AddUpgradeTask: migrating ===================================
 -- adapter_name()
    -> 0.0000s
 -- create_table(:upgrade_tasks, {})
    -> 0.0198s
 -- add_index(:upgrade_tasks, :name, {:unique=>true})
    -> 0.0081s
 == 20180705191153 AddUpgradeTask: migrated (0.0282s) ==========================
 
 == 20180713154128 AddIndexOnRoleNames: migrating ==============================
 -- add_index(:roles, :name, {:unique=>true})
    -> 0.0099s
 == 20180713154128 AddIndexOnRoleNames: migrated (0.0101s) =====================
 
 == 20180715202514 OptimizeIndices: migrating ==================================
 -- remove_index(:audits, :id)
    -> 0.0131s
 -- remove_index(:audits, {:name=>"auditable_parent_index"})
    -> 0.0125s
 -- remove_index(:audits, {:name=>"associated_index"})
    -> 0.0011s
 -- add_index(:audits, [:associated_type, :associated_id])
    -> 0.0829s
 -- remove_index(:audits, {:name=>"auditable_index"})
    -> 0.0013s
 -- add_index(:audits, [:auditable_type, :auditable_id, :version])
    -> 0.1288s
 -- remove_index(:audits, [:user_id, :user_type])
    -> 0.0094s
 -- add_index(:audits, [:user_type, :user_id])
    -> 0.0284s
 -- remove_index(:bookmarks, [:owner_id, :owner_type])
    -> 0.0077s
 -- add_index(:bookmarks, [:owner_type, :owner_id])
    -> 0.0176s
 -- remove_index(:fact_names, :ancestry)
    -> 0.0084s
 -- remove_index(:fact_values, :fact_name_id)
    -> 0.0085s
 -- remove_index(:hosts, :type)
    -> 0.0194s
 -- index_name_exists?(:lookup_values, "index_lookup_values_on_priority")
    -> 0.0019s
 -- remove_index(:lookup_values, {:name=>"index_lookup_values_on_priority"})
    -> 0.0014s
 -- remove_index(:nics, {:name=>"index_by_type"})
    -> 0.0014s
 -- remove_index(:notification_recipients, :user_id)
    -> 0.0112s
 -- index_name_exists?(:parameters, "index_parameters_on_domain_id_and_type")
    -> 0.0020s
 -- index_name_exists?(:parameters, "index_parameters_on_hostgroup_id_and_type")
    -> 0.0018s
 -- index_name_exists?(:parameters, "index_parameters_on_host_id_and_type")
    -> 0.0019s
 -- remove_index(:parameters, {:name=>"index_parameters_on_host_id_and_type"})
    -> 0.0013s
 -- index_exists?(:parameters, [:reference_id, :type])
    -> 0.0051s
 -- remove_index(:parameters, :type)
    -> 0.0059s
 -- remove_index(:permissions, :name)
    -> 0.0068s
 -- remove_index(:reports, :host_id)
    -> 0.0141s
 -- remove_index(:reports, :type)
    -> 0.0130s
 -- remove_index(:reports, :reported_at)
    -> 0.0110s
 -- remove_index(:reports, [:reported_at, :host_id])
    -> 0.0094s
 -- remove_index(:taxable_taxonomies, [:taxable_id, :taxable_type])
    -> 0.0073s
 -- remove_index(:taxable_taxonomies, {:name=>"taxable_index"})
    -> 0.0012s
 -- add_index(:taxable_taxonomies, [:taxable_type, :taxable_id, :taxonomy_id], {:name=>"taxable_index", :unique=>true})
    -> 0.0470s
 -- remove_index(:user_roles, :owner_type)
    -> 0.0075s
 -- remove_index(:user_roles, [:owner_id, :owner_type])
    -> 0.0057s
 -- add_index(:user_roles, [:owner_type, :owner_id])
    -> 0.0096s
 == 20180715202514 OptimizeIndices: migrated (0.5102s) =========================
 
 == 20180806205420 AddIndexToContentViewVersion: migrating =====================
 -- add_index(:katello_content_view_versions, [:content_view_id, :major, :minor], {:unique=>true, :name=>"version_index"})
    -> 0.0121s
 == 20180806205420 AddIndexToContentViewVersion: migrated (0.0123s) ============
 
 == 20180807145652 CreateKatelloModuleStreams: migrating =======================
 -- adapter_name()
    -> 0.0000s
 -- create_table(:katello_module_streams, {})
    -> 0.0410s
 -- adapter_name()
    -> 0.0000s
 -- create_table(:katello_repository_module_streams, {})
    -> 0.0240s
 -- adapter_name()
    -> 0.0000s
 -- create_table(:katello_module_profiles, {})
    -> 0.0279s
 -- adapter_name()
    -> 0.0000s
 -- create_table(:katello_module_profile_rpms, {})
    -> 0.0236s
 -- adapter_name()
    -> 0.0000s
 -- create_table(:katello_module_stream_artifacts, {})
    -> 0.0215s
 -- add_index(:katello_repository_module_streams, [:repository_id, :module_stream_id], {:unique=>true, :name=>:katello_module_streams_repo_stream_uniq})
    -> 0.0082s
 -- add_index(:katello_module_stream_artifacts, [:module_stream_id, :name], {:unique=>true, :name=>:katello_module_stream_artifacts_name_mod_stream_id_uniq})
    -> 0.0078s
 -- add_foreign_key(:katello_repository_module_streams, :katello_repositories, {:column=>:repository_id, :name=>:katello_repo_mod_stream_repo_id_fk})
    -> 0.0060s
 -- add_foreign_key(:katello_repository_module_streams, :katello_module_streams, {:column=>:module_stream_id, :name=>:katello_repo_mod_stream_mod_stream_id_fk})
    -> 0.0028s
 -- add_foreign_key(:katello_module_profiles, :katello_module_streams, {:column=>:module_stream_id, :name=>:katello_mod_profile_mod_stream_id_fk})
    -> 0.0036s
 -- add_foreign_key(:katello_module_profile_rpms, :katello_module_profiles, {:column=>:module_profile_id, :name=>:katello_mod_profile_rpm_mod_profile_id_fk})
    -> 0.0029s
 -- add_foreign_key(:katello_module_stream_artifacts, :katello_module_streams, {:column=>:module_stream_id, :name=>:katello_mod_stream_artifacts_mod_stream_id_fk})
    -> 0.0029s
 == 20180807145652 CreateKatelloModuleStreams: migrated (0.1746s) ==============
 
 == 20180807164405 RemoveRepositoryCpLabel: migrating ==========================
 -- remove_column(:katello_repositories, :cp_label)
    -> 0.0029s
 == 20180807164405 RemoveRepositoryCpLabel: migrated (0.0031s) =================
 
 == 20180808013432 AddSystemPurposeAttrs: migrating ============================
 -- adapter_name()
    -> 0.0001s
 -- create_table(:katello_purpose_addons, {})
    -> 0.0149s
 -- adapter_name()
    -> 0.0001s
 -- create_table(:katello_purpose_roles, {})
    -> 0.0149s
 -- adapter_name()
    -> 0.0001s
 -- create_table(:katello_purpose_usages, {})
    -> 0.0184s
 -- adapter_name()
    -> 0.0001s
 -- create_table(:katello_subscription_facet_purpose_addons, {})
    -> 0.0317s
 -- adapter_name()
    -> 0.0000s
 -- create_table(:katello_subscription_facet_purpose_roles, {})
    -> 0.0246s
 -- adapter_name()
    -> 0.0000s
 -- create_table(:katello_subscription_facet_purpose_usages, {})
    -> 0.0250s
 -- add_foreign_key(:katello_subscription_facet_purpose_addons, :katello_subscription_facets, {:column=>:subscription_facet_id, :name=>:katello_sub_facet_purpose_addon_facet_id})
    -> 0.0050s
 -- add_foreign_key(:katello_subscription_facet_purpose_addons, :katello_purpose_addons, {:column=>:purpose_addon_id, :name=>:katello_sub_facet_purpose_addon_purpose_addon_id})
    -> 0.0027s
 -- add_foreign_key(:katello_subscription_facet_purpose_roles, :katello_subscription_facets, {:column=>:subscription_facet_id, :name=>:katello_sub_facet_purpose_role_facet_id})
    -> 0.0039s
 -- add_foreign_key(:katello_subscription_facet_purpose_roles, :katello_purpose_roles, {:column=>:purpose_role_id, :name=>:katello_sub_facet_purpose_role_purpose_role_id})
    -> 0.0036s
 -- add_foreign_key(:katello_subscription_facet_purpose_usages, :katello_subscription_facets, {:column=>:subscription_facet_id, :name=>:katello_sub_facet_purpose_usage_facet_id})
    -> 0.0033s
 -- add_foreign_key(:katello_subscription_facet_purpose_usages, :katello_purpose_usages, {:column=>:purpose_usage_id, :name=>:katello_sub_facet_purpose_usage_purpose_usage_id})
    -> 0.0026s
 == 20180808013432 AddSystemPurposeAttrs: migrated (0.1539s) ===================
 
 == 20180814202747 AddRecurringLogicToSyncPlan: migrating ======================
 -- add_column(:katello_sync_plans, :foreman_tasks_recurring_logic_id, :integer)
    -> 0.0017s
 -- add_column(:katello_sync_plans, :cron_expression, :string)
    -> 0.0010s
 -- add_foreign_key(:katello_sync_plans, :foreman_tasks_recurring_logics, {:name=>"katello_sync_plan_foreman_tasks_recurring_logic_fk", :column=>"foreman_tasks_recurring_logic_id"})
    -> 0.0040s
 == 20180814202747 AddRecurringLogicToSyncPlan: migrated (0.0071s) =============
 
 == 20180816110716 AddHttpbootDoSubnet: migrating ==============================
 -- add_column(:subnets, :httpboot_id, :integer)
    -> 0.0015s
 -- add_index(:subnets, :httpboot_id)
    -> 0.0099s
 == 20180816110716 AddHttpbootDoSubnet: migrated (0.0117s) =====================
 
 == 20180816142044 AddDescriptionToKatelloModuleStreams: migrating =============
 -- add_column(:katello_module_streams, :description, :text)
    -> 0.0013s
 -- add_column(:katello_module_streams, :summary, :text)
    -> 0.0010s
 == 20180816142044 AddDescriptionToKatelloModuleStreams: migrated (0.0026s) ====
 
 == 20180820072858 AddHelpTextToTemplateKinds: migrating =======================
 -- add_column(:template_kinds, :description, :text)
    -> 0.0071s
 == 20180820072858 AddHelpTextToTemplateKinds: migrated (0.0073s) ==============
 
 == 20180821144248 AddCronLogicToSyncPlans: migrating ==========================
 == 20180821144248 AddCronLogicToSyncPlans: migrated (0.0000s) =================
 
 == 20180828161400 RemoveJoinTableForRoleAndUsage: migrating ===================
 -- remove_foreign_key(:katello_subscription_facet_purpose_roles, :katello_subscription_facets)
    -> 0.0121s
 -- remove_foreign_key(:katello_subscription_facet_purpose_roles, :katello_purpose_roles)
    -> 0.0091s
 -- remove_foreign_key(:katello_subscription_facet_purpose_usages, :katello_subscription_facets)
    -> 0.0098s
 -- remove_foreign_key(:katello_subscription_facet_purpose_usages, :katello_purpose_usages)
    -> 0.0091s
 -- drop_table(:katello_subscription_facet_purpose_roles)
    -> 0.0037s
 -- drop_table(:katello_subscription_facet_purpose_usages)
    -> 0.0024s
 -- drop_table(:katello_subscription_facet_purpose_addons)
    -> 0.0035s
 -- drop_table(:katello_purpose_roles)
    -> 0.0022s
 -- drop_table(:katello_purpose_usages)
    -> 0.0022s
 -- drop_table(:katello_purpose_addons)
    -> 0.0022s
 -- add_column(:katello_subscription_facets, :purpose_usage, :text)
    -> 0.0014s
 -- add_column(:katello_subscription_facets, :purpose_role, :text)
    -> 0.0010s
 -- add_column(:katello_subscription_facets, :purpose_addons, :text)
    -> 0.0009s
 == 20180828161400 RemoveJoinTableForRoleAndUsage: migrated (0.0611s) ==========
 
 == 20180831115634 AddUniquenessToPuppetclassName: migrating ===================
 -- remove_index(:puppetclasses, :name)
    -> 0.0051s
 -- add_index(:puppetclasses, :name, {:unique=>true})
    -> 0.0099s
 == 20180831115634 AddUniquenessToPuppetclassName: migrated (0.1384s) ==========
 
 == 20180903154354 RemoveModulepathSetting: migrating ==========================
 == 20180903154354 RemoveModulepathSetting: migrated (0.0026s) =================
 
 == 20180920123913 DropRepoModuleStreamsTimestampNotNull: migrating ============
 -- change_column(:katello_repository_module_streams, :created_at, :datetime, {:null=>true})
    -> 0.0013s
 -- change_column(:katello_repository_module_streams, :updated_at, :datetime, {:null=>true})
    -> 0.0010s
 -- change_column(:katello_repository_module_streams, :repository_id, :integer, {:null=>true})
    -> 0.0261s
 == 20180920123913 DropRepoModuleStreamsTimestampNotNull: migrated (0.0289s) ===
 
 == 20180920171008 ChangeRepositoryPasswordToText: migrating ===================
 -- change_column(:katello_repositories, :upstream_password, :text)
    -> 0.0016s
 == 20180920171008 ChangeRepositoryPasswordToText: migrated (0.0018s) ==========
 
 == 20180920214134 CreateRepositoryRoot: migrating =============================
 -- adapter_name()
    -> 0.0000s
 -- create_table("katello_root_repositories", {})
    -> 0.0238s
 -- add_foreign_key("katello_root_repositories", "katello_products", {:name=>"katello_root_repositories_product_id", :column=>"product_id"})
    -> 0.0052s
 -- add_foreign_key("katello_root_repositories", "katello_gpg_keys", {:name=>"katello_root_repositories_gpg_key_id", :column=>"gpg_key_id"})
    -> 0.0041s
 -- add_foreign_key("katello_root_repositories", "katello_gpg_keys", {:name=>"katello_root_repositories_ssl_ca_cert_id", :column=>"ssl_ca_cert_id"})
    -> 0.0034s
 -- add_foreign_key("katello_root_repositories", "katello_gpg_keys", {:name=>"katello_root_repositories_ssl_client_cert_id", :column=>"ssl_client_cert_id"})
    -> 0.0032s
 -- add_foreign_key("katello_root_repositories", "katello_gpg_keys", {:name=>"katello_root_repositories_ssl_client_key_id", :column=>"ssl_client_key_id"})
    -> 0.0028s
 -- add_column(:katello_repositories, :root_id, :integer, {:null=>true})
    -> 0.0015s
 -- add_foreign_key("katello_repositories", "katello_root_repositories", {:name=>"katello_root_repositories_repo_id", :column=>"root_id"})
    -> 0.0061s
 -- adapter_name()
    -> 0.0000s
 -- clear_cache!()
    -> 0.0002s
 -- quote_table_name(:katello_repositories)
    -> 0.0001s
 -- execute("ALTER TABLE \"katello_repositories\" ALTER COLUMN \"root_id\" TYPE integer")
    -> 0.0040s
 -- change_column_null(:katello_repositories, :root_id, false, nil)
    -> 0.0010s
 -- rename_column(:katello_repositories, :checksum_type, :saved_checksum_type)
    -> 0.0139s
 -- remove_column(:katello_repositories, :source_repo_checksum_type)
    -> 0.0012s
 -- remove_column(:katello_repositories, "name")
    -> 0.0011s
 -- remove_column(:katello_repositories, "created_at")
    -> 0.0008s
 -- remove_column(:katello_repositories, "updated_at")
    -> 0.0009s
 -- remove_column(:katello_repositories, "major")
    -> 0.0010s
 -- remove_column(:katello_repositories, "minor")
    -> 0.0009s
 -- remove_column(:katello_repositories, "gpg_key_id")
    -> 0.0028s
 -- remove_column(:katello_repositories, "content_id")
    -> 0.0011s
 -- remove_column(:katello_repositories, "arch")
    -> 0.0018s
 -- remove_column(:katello_repositories, "label")
    -> 0.0011s
 -- remove_column(:katello_repositories, "url")
    -> 0.0011s
 -- remove_column(:katello_repositories, "unprotected")
    -> 0.0014s
 -- remove_column(:katello_repositories, "content_type")
    -> 0.0012s
 -- remove_column(:katello_repositories, "product_id")
    -> 0.0029s
 -- remove_column(:katello_repositories, "docker_upstream_name")
    -> 0.0012s
 -- remove_column(:katello_repositories, "mirror_on_sync")
    -> 0.0018s
 -- remove_column(:katello_repositories, "download_policy")
    -> 0.0011s
 -- remove_column(:katello_repositories, "verify_ssl_on_sync")
    -> 0.0016s
 -- remove_column(:katello_repositories, "upstream_username")
    -> 0.0009s
 -- remove_column(:katello_repositories, "upstream_password")
    -> 0.0009s
 -- remove_column(:katello_repositories, "ostree_upstream_sync_policy")
    -> 0.0009s
 -- remove_column(:katello_repositories, "ostree_upstream_sync_depth")
    -> 0.0009s
 -- remove_column(:katello_repositories, "deb_releases")
    -> 0.0011s
 -- remove_column(:katello_repositories, "deb_components")
    -> 0.0009s
 -- remove_column(:katello_repositories, "deb_architectures")
    -> 0.0009s
 -- remove_column(:katello_repositories, "ignore_global_proxy")
    -> 0.0016s
 -- remove_column(:katello_repositories, "ssl_ca_cert_id")
    -> 0.0028s
 -- remove_column(:katello_repositories, "ssl_client_cert_id")
    -> 0.0021s
 -- remove_column(:katello_repositories, "ssl_client_key_id")
    -> 0.0020s
 -- remove_column(:katello_repositories, "ignorable_content")
    -> 0.0009s
 -- remove_column(:katello_repositories, "description")
    -> 0.0009s
 -- remove_column(:katello_repositories, "docker_tags_whitelist")
    -> 0.0010s
 == 20180920214134 CreateRepositoryRoot: migrated (1.4676s) ====================
 
 == 20181001141138 IgnoreTaxonomiesForAuditFilters: migrating ==================
 == 20181001141138 IgnoreTaxonomiesForAuditFilters: migrated (0.0419s) =========
 
 == 20181008201422 AddModulesToErrataPackages: migrating =======================
 -- create_table(:katello_module_stream_erratum_packages)
    -> 0.0245s
 -- add_index(:katello_module_stream_erratum_packages, [:module_stream_id, :erratum_package_id], {:unique=>true, :name=>:katello_module_stream_erratum_package_uniq})
    -> 0.0078s
 -- add_foreign_key(:katello_module_stream_erratum_packages, :katello_module_streams, {:column=>:module_stream_id, :name=>:katello_msep_mod_stream_id_fk})
    -> 0.0036s
 -- add_foreign_key(:katello_module_stream_erratum_packages, :katello_erratum_packages, {:column=>:erratum_package_id, :name=>:katello_msep_erratum_package_id_fk})
    -> 0.0049s
 -- change_column(:katello_module_stream_erratum_packages, :created_at, :datetime, {:null=>true})
    -> 0.0015s
 -- change_column(:katello_module_stream_erratum_packages, :updated_at, :datetime, {:null=>true})
    -> 0.0012s
 == 20181008201422 AddModulesToErrataPackages: migrated (0.0444s) ==============
 
 == 20181017181806 AvailableModuleStreams: migrating ===========================
 -- create_table(:katello_available_module_streams)
    -> 0.0260s
 -- create_table(:katello_host_available_module_streams)
    -> 0.0210s
 -- add_index(:katello_available_module_streams, [:name, :stream], {:unique=>true, :name=>:katello_available_module_streams_name_stream})
    -> 0.0079s
 -- add_foreign_key(:katello_host_available_module_streams, :hosts, {:name=>:katello_hems_host_id_fk, :column=>:host_id})
    -> 0.0040s
 -- add_foreign_key(:katello_host_available_module_streams, :katello_available_module_streams, {:name=>:katello_hems_available_module_stream_id_fk, :column=>:available_module_stream_id})
    -> 0.0044s
 -- add_index(:katello_host_available_module_streams, :available_module_stream_id, {:name=>:index_katello_hems_available_module_stream_id})
    -> 0.0075s
 == 20181017181806 AvailableModuleStreams: migrated (0.0716s) ==================
 
 == 20181027014323 AddApplicableModules: migrating =============================
 -- create_table("katello_content_facet_applicable_module_streams")
    -> 0.0256s
 -- add_foreign_key(:katello_content_facet_applicable_module_streams, :katello_module_streams, {:column=>:module_stream_id, :name=>:katello_cfams_mod_stream_id_fk})
    -> 0.0029s
 -- add_foreign_key(:katello_content_facet_applicable_module_streams, :katello_content_facets, {:column=>:content_facet_id, :name=>:katello_cfams_cf_fk})
    -> 0.0041s
 -- add_index("katello_content_facet_applicable_module_streams", ["module_stream_id", "content_facet_id"], {:name=>"katello_content_facet_module_stream_rid_cfid", :unique=>true})
    -> 0.0075s
 -- add_column(:katello_content_facets, :applicable_module_stream_count, :integer, {:null=>false, :default=>0})
    -> 0.0284s
 -- add_column(:katello_content_facets, :upgradable_module_stream_count, :integer, {:null=>false, :default=>0})
    -> 0.0263s
 == 20181027014323 AddApplicableModules: migrated (0.0960s) ====================
 
 == 20181108171732 ChangeBlogUrl: migrating ====================================
 == 20181108171732 ChangeBlogUrl: migrated (0.0088s) ===========================
 
 foreman-rake db:migrate finished successfully!

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/RHSA-2019:1222