Bug 1747654
Summary: | Upgrade to 6.6 failed at foreman-rake db:migrate - undefined method `searchable_value=' | ||
---|---|---|---|
Product: | Red Hat Satellite | Reporter: | Nikhil Kathole <nkathole> |
Component: | Upgrades | Assignee: | Kavita <kgaikwad> |
Status: | CLOSED ERRATA | QA Contact: | Nikhil Kathole <nkathole> |
Severity: | high | Docs Contact: | |
Priority: | unspecified | ||
Version: | 6.6.0 | CC: | bkearney, desingh, inecas, kgaikwad, mbacovsk, vijsingh |
Target Milestone: | 6.6.0 | Keywords: | Regression, Triaged |
Target Release: | Unused | ||
Hardware: | Unspecified | ||
OS: | Unspecified | ||
Whiteboard: | |||
Fixed In Version: | foreman-1.22.0.24-1 | Doc Type: | If docs needed, set a value |
Doc Text: | Story Points: | --- | |
Clone Of: | Environment: | ||
Last Closed: | 2019-10-22 12:47:58 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: | |||
Bug Depends On: | |||
Bug Blocks: | 1737488 |
Description
Nikhil Kathole
2019-08-31 13:34:08 UTC
@Nikhil, I have raised pull-request to fix migration(https://github.com/theforeman/foreman/pull/7010). Would it be possible to verify with this patch upgrade runs successfully on your reproducer & not giving any migration failures? Or let me know if I can do testing on reproducer with this patch change. Thank you for the quick fix Kavita. I tested the patch and the upgrade completed successfully with it. Thank you Bryan. I got the review comment from Shim on the pull-request. I will do appropriate changes as per suggestions. Moving this bug to POST for triage into Satellite 6 since the upstream issue https://projects.theforeman.org/issues/27745 has been resolved. VERIFIED Version tested: Satellite 6.6.0 snap 20 Satellite upgrade completed successfully. Upgrade Step: migrate_foreman... API controllers newer than Apipie cache! Run apipie:cache rake task to regenerate cache. == 20171109095957 AddKeyTypeToParameters: migrating =========================== -- add_column(:parameters, :key_type, :string, {:limit=>255}) -> 0.0057s == 20171109095957 AddKeyTypeToParameters: migrated (0.0059s) ================== == 20180129143410 CreateJwtSecrets: migrating ================================= -- adapter_name() -> 0.0000s -- create_table(:jwt_secrets, {}) -> 1.0294s == 20180129143410 CreateJwtSecrets: migrated (1.0297s) ======================== == 20180628125416 AddAnsibleRoleIdToLookupKeys: migrating ===================== -- add_column(:lookup_keys, :ansible_role_id, :integer, {}) -> 0.0039s -- add_index(:lookup_keys, :ansible_role_id) -> 0.1290s == 20180628125416 AddAnsibleRoleIdToLookupKeys: migrated (0.1332s) ============ == 20180705230311 SmartProxyCapabilities: migrating =========================== -- rename_table(:features_smart_proxies, :smart_proxy_features) -> 0.0158s -- change_table(:smart_proxy_features, {:bulk=>true}) -> 0.0747s == 20180705230311 SmartProxyCapabilities: migrated (0.0908s) ================== == 20180823081502 RemoveForemanDockerSupport: migrating ======================= -- table_exists?(:docker_images) -> 0.0018s -- table_exists?(:docker_tags) -> 0.0031s -- table_exists?(:docker_container_wizard_states_images) -> 0.0017s -- column_exists?(:docker_container_wizard_states_images, :capsule_id) -> 0.0070s -- remove_column(:docker_container_wizard_states_images, :capsule_id) -> 0.0040s -- table_exists?(:containers) -> 0.0017s -- column_exists?(:containers, :capsule_id) -> 0.0119s -- remove_column(:containers, :capsule_id) -> 0.0048s == 20180823081502 RemoveForemanDockerSupport: migrated (0.0373s) ============== == 20181005065724 FilterAndExcludeHostParents: migrating ====================== -- add_column(:foreman_virt_who_configure_configs, :filter_host_parents, :text) -> 0.0028s -- add_column(:foreman_virt_who_configure_configs, :exclude_host_parents, :text) -> 0.0013s == 20181005065724 FilterAndExcludeHostParents: migrated (0.0044s) ============= == 20181019135324 AddRemoteTaskOperation: migrating =========================== -- add_column(:foreman_tasks_remote_tasks, :operation, :string, {}) -> 0.0036s == 20181019135324 AddRemoteTaskOperation: migrated (0.0037s) ================== == 20181031155025 AddTrendCounterCreatedAtUniqueConstraint: migrating ========= -- add_index(:trend_counters, [:trend_id, :created_at], {:unique=>true}) -> 0.0101s == 20181031155025 AddTrendCounterCreatedAtUniqueConstraint: migrated (0.0631s) == 20181105061336 CastKeyTypesAndValuesInParameters: migrating ================ == 20181105061336 CastKeyTypesAndValuesInParameters: migrated (0.3100s) ======= == 20181116104823 FixedIgnoreTaxonomiesForAuditFilters: migrating ============= == 20181116104823 FixedIgnoreTaxonomiesForAuditFilters: migrated (1.2530s) ==== == 20181224174419 AddIndexToEnvironmentClassByLookupKeyAndPuppetclass: migrating -- add_index(:environment_classes, [:puppetclass_lookup_key_id, :puppetclass_id], {:name=>"index_env_classes_on_lookup_key_and_class"}) -> 0.0327s == 20181224174419 AddIndexToEnvironmentClassByLookupKeyAndPuppetclass: migrated (0.0329s) == 20190103093409 AddDeploymentOptionToPolicy: migrating ====================== -- add_column(:foreman_openscap_policies, :deploy_by, :string) -> 0.0106s -- change_column(:foreman_openscap_policies, :deploy_by, :string, {:null=>false}) -> 0.0024s == 20190103093409 AddDeploymentOptionToPolicy: migrated (0.1695s) ============= == 20190104125749 AddKubeconfigToConfig: migrating ============================ -- add_column(:foreman_virt_who_configure_configs, :kubeconfig_path, :string, {:null=>true}) -> 0.0014s == 20190104125749 AddKubeconfigToConfig: migrated (0.0017s) =================== == 20190107160723 UnitsUuidToBackendIdent: migrating ========================== -- rename_column("katello_rpms", :uuid, :pulp_id) -> 0.0085s -- rename_column("katello_errata", :uuid, :pulp_id) -> 0.0094s -- rename_column("katello_package_groups", :uuid, :pulp_id) -> 0.0057s -- rename_column("katello_files", :uuid, :pulp_id) -> 0.0076s -- rename_column("katello_yum_metadata_files", :uuid, :pulp_id) -> 0.0041s -- rename_column("katello_srpms", :uuid, :pulp_id) -> 0.0082s -- rename_column("katello_module_streams", :uuid, :pulp_id) -> 0.0037s -- rename_column("katello_debs", :uuid, :pulp_id) -> 0.0079s -- rename_column("katello_docker_tags", :uuid, :pulp_id) -> 0.0079s -- rename_column("katello_docker_manifests", :uuid, :pulp_id) -> 0.0031s -- rename_column("katello_docker_manifest_lists", :uuid, :pulp_id) -> 0.0029s -- rename_column("katello_puppet_modules", :uuid, :pulp_id) -> 0.0056s -- rename_column("katello_ostree_branches", :uuid, :pulp_id) -> 0.0032s == 20190107160723 UnitsUuidToBackendIdent: migrated (0.0794s) ================= == 20190108151133 DebReleaseNameUnknown: migrating ============================ == 20190108151133 DebReleaseNameUnknown: migrated (0.0225s) =================== == 20190111153330 RemoveRemoteExecutionWithoutProxySetting: migrating ========= == 20190111153330 RemoveRemoteExecutionWithoutProxySetting: migrated (0.0030s) == 20190116120705 RemoveTimestampsFromLogs: migrating ========================= -- remove_column(:logs, :created_at, :datetime) -> 0.0023s -- remove_column(:logs, :updated_at, :datetime) -> 0.0011s == 20190116120705 RemoveTimestampsFromLogs: migrated (0.0037s) ================ == 20190121084601 ChangeComputeResourcePasswordLength: migrating ============== -- change_column(:compute_resources, :password, :text, {:limit=>nil}) -> 0.0032s == 20190121084601 ChangeComputeResourcePasswordLength: migrated (0.0034s) ===== == 20190122115421 RenameHostStatusesReport: migrating ========================= == 20190122115421 RenameHostStatusesReport: migrated (0.0713s) ================ == 20190219152921 AddPulp3Attributes: migrating =============================== -- create_table(:katello_distribution_references) -> 0.0269s -- create_table(:katello_repository_references) -> 0.0449s -- add_column(:katello_repositories, :remote_href, :string) -> 0.0017s -- add_column(:katello_repositories, :publication_href, :string) -> 0.0013s -- add_column(:katello_repositories, :version_href, :string) -> 0.0013s == 20190219152921 AddPulp3Attributes: migrated (0.0766s) ====================== == 20190221201724 AddDependencySolvingToKatelloContentView: migrating ========= -- add_column(:katello_content_views, :solve_dependencies, :boolean, {:default=>false}) -> 0.0421s == 20190221201724 AddDependencySolvingToKatelloContentView: migrated (0.0423s) == 20190225115728 CreateStoredValues: migrating =============================== -- create_table(:stored_values) -> 0.0194s == 20190225115728 CreateStoredValues: migrated (0.0196s) ====================== == 20190228160047 AddValueTypeAndResourceTypeToTemplateInput: migrating ======= -- add_column(:template_inputs, :value_type, :string, {:default=>"plain", :null=>false}) -> 0.0198s -- add_column(:template_inputs, :resource_type, :string) -> 0.0013s == 20190228160047 AddValueTypeAndResourceTypeToTemplateInput: migrated (0.0214s) == 20190318094437 AddImportedAttrToAnsibleVariables: migrating ================ -- add_column(:lookup_keys, :imported, :boolean) -> 0.0013s == 20190318094437 AddImportedAttrToAnsibleVariables: migrated (0.0542s) ======= == 20190318153925 AddTaskStateUpdatedAt: migrating ============================ -- add_column(:foreman_tasks_tasks, :state_updated_at, :timestamp, {:index=>true}) -> 0.0015s == 20190318153925 AddTaskStateUpdatedAt: migrated (0.0017s) =================== == 20190328114657 RemoveTopLevelAnsibleVariablesSetting: migrating ============ == 20190328114657 RemoveTopLevelAnsibleVariablesSetting: migrated (0.0060s) === == 20190404030833 RemoveEnabledFromSyncPlans: migrating ======================= -- remove_column(:katello_sync_plans, :enabled) -> 0.0026s == 20190404030833 RemoveEnabledFromSyncPlans: migrated (0.0027s) ============== == 20190510082811 AddTaxonomyIdTaxableTypeIndicesToTaxableTaxonomies: migrating -- add_index(:taxable_taxonomies, ["taxonomy_id", "taxable_type"]) -> 0.1936s -- remove_index(:taxable_taxonomies, :taxonomy_id) -> 0.0083s == 20190510082811 AddTaxonomyIdTaxableTypeIndicesToTaxableTaxonomies: migrated (0.2023s) == 20190702182118 AddMetadataProcessAfterToKatelloEvent: migrating ============ -- add_column(:katello_events, :metadata, :text) -> 0.0073s -- add_column(:katello_events, :process_after, :datetime) -> 0.0010s == 20190702182118 AddMetadataProcessAfterToKatelloEvent: migrated (0.0086s) === == 20190705060630 AddSearchableValueToParameters: migrating =================== -- add_column(:parameters, :searchable_value, :text) -> 0.0015s == 20190705060630 AddSearchableValueToParameters: migrated (0.0469s) ========== 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:3172 |