Migrate values to zoekt_settings (!148014) · Merge requests · GitLab.org / GitLab

Ravi Kumar requested to merge 389765-migrate-values-to-zoekt_settings into master Mar 27, 2024

What does this MR do and why?

Add a migration to set the values of zoekt_settings column in the table application_settings. The values are derived from the feature flags.

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Screenshots or screen recordings

Screenshots are required for UI changes, and strongly recommended for all other merge requests.

Before	After

How to set up and validate locally

Check out the branch

git fetch && git checkout 389765-migrate-values-to-zoekt_settings

Open the rails console

bin/rails c

Check the existing ApplicationSetting record. The value of zoekt_settings should be {}. Following should return true

ApplicationSetting.last.zoekt_settings == {}

Run the migration in a new terminal tab

bin/rails db:migrate

Verify the value of zoekt_settings matches with the feature flags. Following should return true

ApplicationSetting.last.zoekt_settings == { 'zoekt_indexing_enabled' => Feature.enabled?(:index_code_with_zoekt), 'zoekt_indexing_paused' => Feature.enabled?(:zoekt_pause_indexing, type: :ops), 'zoekt_search_enabled' => Feature.enabled?(:search_code_with_zoekt) }

Query plan

UPDATE "application_settings"
SET "zoekt_settings" = '{"zoekt_indexing_enabled":true,"zoekt_indexing_paused":false,"zoekt_search_enabled":true}',
    "updated_at" = '2024-04-02 09:01:41.479208'
WHERE "application_settings"."id" = 1

https://console.postgres.ai/shared/339cf839-adb7-4af1-81da-369711377fc7

SELECT "application_settings"."id",
       "application_settings"."default_projects_limit",
       "application_settings"."signup_enabled",
       "application_settings"."gravatar_enabled",
       "application_settings"."sign_in_text",
       "application_settings"."created_at",
       "application_settings"."updated_at",
       "application_settings"."home_page_url",
       "application_settings"."default_branch_protection",
       "application_settings"."help_text",
       "application_settings"."restricted_visibility_levels",
       "application_settings"."version_check_enabled",
       "application_settings"."max_attachment_size",
       "application_settings"."default_project_visibility",
       "application_settings"."default_snippet_visibility",
       "application_settings"."user_oauth_applications",
       "application_settings"."after_sign_out_path",
       "application_settings"."session_expire_delay",
       "application_settings"."import_sources",
       "application_settings"."help_page_text",
       "application_settings"."require_admin_two_factor_authentication",
       "application_settings"."shared_runners_enabled",
       "application_settings"."max_artifacts_size",
       "application_settings"."runners_registration_token",
       "application_settings"."max_pages_size",
       "application_settings"."require_two_factor_authentication",
       "application_settings"."two_factor_grace_period",
       "application_settings"."metrics_enabled",
       "application_settings"."metrics_host",
       "application_settings"."metrics_pool_size",
       "application_settings"."metrics_timeout",
       "application_settings"."metrics_method_call_threshold",
       "application_settings"."recaptcha_enabled",
       "application_settings"."metrics_port",
       "application_settings"."akismet_enabled",
       "application_settings"."metrics_sample_interval",
       "application_settings"."email_author_in_body",
       "application_settings"."default_group_visibility",
       "application_settings"."repository_checks_enabled",
       "application_settings"."shared_runners_text",
       "application_settings"."metrics_packet_size",
       "application_settings"."disabled_oauth_sign_in_sources",
       "application_settings"."health_check_access_token",
       "application_settings"."container_registry_token_expire_delay",
       "application_settings"."after_sign_up_text",
       "application_settings"."user_default_external",
       "application_settings"."elasticsearch_indexing",
       "application_settings"."elasticsearch_search",
       "application_settings"."enabled_git_access_protocol",
       "application_settings"."usage_ping_enabled",
       "application_settings"."sign_in_text_html",
       "application_settings"."help_page_text_html",
       "application_settings"."shared_runners_text_html",
       "application_settings"."after_sign_up_text_html",
       "application_settings"."rsa_key_restriction",
       "application_settings"."dsa_key_restriction",
       "application_settings"."ecdsa_key_restriction",
       "application_settings"."ed25519_key_restriction",
       "application_settings"."housekeeping_enabled",
       "application_settings"."housekeeping_bitmaps_enabled",
       "application_settings"."housekeeping_incremental_repack_period",
       "application_settings"."housekeeping_full_repack_period",
       "application_settings"."housekeeping_gc_period",
       "application_settings"."html_emails_enabled",
       "application_settings"."plantuml_url",
       "application_settings"."plantuml_enabled",
       "application_settings"."shared_runners_minutes",
       "application_settings"."repository_size_limit",
       "application_settings"."terminal_max_session_time",
       "application_settings"."unique_ips_limit_per_user",
       "application_settings"."unique_ips_limit_time_window",
       "application_settings"."unique_ips_limit_enabled",
       "application_settings"."default_artifacts_expire_in",
       "application_settings"."elasticsearch_url",
       "application_settings"."elasticsearch_aws",
       "application_settings"."elasticsearch_aws_region",
       "application_settings"."elasticsearch_aws_access_key",
       "application_settings"."geo_status_timeout",
       "application_settings"."uuid",
       "application_settings"."polling_interval_multiplier",
       "application_settings"."cached_markdown_version",
       "application_settings"."check_namespace_plan",
       "application_settings"."mirror_max_delay",
       "application_settings"."mirror_max_capacity",
       "application_settings"."mirror_capacity_threshold",
       "application_settings"."prometheus_metrics_enabled",
       "application_settings"."authorized_keys_enabled",
       "application_settings"."help_page_hide_commercial_content",
       "application_settings"."help_page_support_url",
       "application_settings"."slack_app_enabled",
       "application_settings"."slack_app_id",
       "application_settings"."performance_bar_allowed_group_id",
       "application_settings"."allow_group_owners_to_manage_ldap",
       "application_settings"."hashed_storage_enabled",
       "application_settings"."project_export_enabled",
       "application_settings"."auto_devops_enabled",
       "application_settings"."throttle_unauthenticated_enabled",
       "application_settings"."throttle_unauthenticated_requests_per_period",
       "application_settings"."throttle_unauthenticated_period_in_seconds",
       "application_settings"."throttle_authenticated_api_enabled",
       "application_settings"."throttle_authenticated_api_requests_per_period",
       "application_settings"."throttle_authenticated_api_period_in_seconds",
       "application_settings"."throttle_authenticated_web_enabled",
       "application_settings"."throttle_authenticated_web_requests_per_period",
       "application_settings"."throttle_authenticated_web_period_in_seconds",
       "application_settings"."gitaly_timeout_default",
       "application_settings"."gitaly_timeout_medium",
       "application_settings"."gitaly_timeout_fast",
       "application_settings"."mirror_available",
       "application_settings"."password_authentication_enabled_for_web",
       "application_settings"."password_authentication_enabled_for_git",
       "application_settings"."auto_devops_domain",
       "application_settings"."external_authorization_service_enabled",
       "application_settings"."external_authorization_service_url",
       "application_settings"."external_authorization_service_default_label",
       "application_settings"."pages_domain_verification_enabled",
       "application_settings"."user_default_internal_regex",
       "application_settings"."external_authorization_service_timeout",
       "application_settings"."external_auth_client_cert",
       "application_settings"."encrypted_external_auth_client_key",
       "application_settings"."encrypted_external_auth_client_key_iv",
       "application_settings"."encrypted_external_auth_client_key_pass",
       "application_settings"."encrypted_external_auth_client_key_pass_iv",
       "application_settings"."email_additional_text",
       "application_settings"."enforce_terms",
       "application_settings"."file_template_project_id",
       "application_settings"."pseudonymizer_enabled",
       "application_settings"."hide_third_party_offers",
       "application_settings"."snowplow_enabled",
       "application_settings"."snowplow_collector_hostname",
       "application_settings"."snowplow_cookie_domain",
       "application_settings"."user_show_add_ssh_key_message",
       "application_settings"."custom_project_templates_group_id",
       "application_settings"."usage_stats_set_by_user_id",
       "application_settings"."receive_max_input_size",
       "application_settings"."diff_max_patch_bytes",
       "application_settings"."archive_builds_in_seconds",
       "application_settings"."commit_email_hostname",
       "application_settings"."protected_ci_variables",
       "application_settings"."runners_registration_token_encrypted",
       "application_settings"."local_markdown_version",
       "application_settings"."first_day_of_week",
       "application_settings"."elasticsearch_limit_indexing",
       "application_settings"."default_project_creation",
       "application_settings"."lets_encrypt_notification_email",
       "application_settings"."lets_encrypt_terms_of_service_accepted",
       "application_settings"."geo_node_allowed_ips",
       "application_settings"."encrypted_lets_encrypt_private_key",
       "application_settings"."encrypted_lets_encrypt_private_key_iv",
       "application_settings"."required_instance_ci_template",
       "application_settings"."dns_rebinding_protection_enabled",
       "application_settings"."default_project_deletion_protection",
       "application_settings"."grafana_enabled",
       "application_settings"."lock_memberships_to_ldap",
       "application_settings"."time_tracking_limit_to_hours",
       "application_settings"."grafana_url",
       "application_settings"."login_recaptcha_protection_enabled",
       "application_settings"."outbound_local_requests_whitelist",
       "application_settings"."raw_blob_request_limit",
       "application_settings"."allow_local_requests_from_web_hooks_and_services",
       "application_settings"."allow_local_requests_from_system_hooks",
       "application_settings"."asset_proxy_enabled",
       "application_settings"."asset_proxy_url",
       "application_settings"."encrypted_asset_proxy_secret_key",
       "application_settings"."encrypted_asset_proxy_secret_key_iv",
       "application_settings"."static_objects_external_storage_url",
       "application_settings"."max_personal_access_token_lifetime",
       "application_settings"."throttle_protected_paths_enabled",
       "application_settings"."throttle_protected_paths_requests_per_period",
       "application_settings"."throttle_protected_paths_period_in_seconds",
       "application_settings"."protected_paths",
       "application_settings"."throttle_incident_management_notification_enabled",
       "application_settings"."throttle_incident_management_notification_period_in_seconds",
       "application_settings"."throttle_incident_management_notification_per_period",
       "application_settings"."push_event_hooks_limit",
       "application_settings"."push_event_activities_limit",
       "application_settings"."custom_http_clone_url_root",
       "application_settings"."deletion_adjourned_period",
       "application_settings"."license_trial_ends_on",
       "application_settings"."eks_integration_enabled",
       "application_settings"."eks_account_id",
       "application_settings"."eks_access_key_id",
       "application_settings"."encrypted_eks_secret_access_key_iv",
       "application_settings"."encrypted_eks_secret_access_key",
       "application_settings"."snowplow_app_id",
       "application_settings"."productivity_analytics_start_date",
       "application_settings"."default_ci_config_path",
       "application_settings"."sourcegraph_enabled",
       "application_settings"."sourcegraph_url",
       "application_settings"."sourcegraph_public_only",
       "application_settings"."snippet_size_limit",
       "application_settings"."minimum_password_length",
       "application_settings"."encrypted_akismet_api_key",
       "application_settings"."encrypted_akismet_api_key_iv",
       "application_settings"."encrypted_elasticsearch_aws_secret_access_key",
       "application_settings"."encrypted_elasticsearch_aws_secret_access_key_iv",
       "application_settings"."encrypted_recaptcha_private_key",
       "application_settings"."encrypted_recaptcha_private_key_iv",
       "application_settings"."encrypted_recaptcha_site_key",
       "application_settings"."encrypted_recaptcha_site_key_iv",
       "application_settings"."encrypted_slack_app_secret",
       "application_settings"."encrypted_slack_app_secret_iv",
       "application_settings"."encrypted_slack_app_verification_token",
       "application_settings"."encrypted_slack_app_verification_token_iv",
       "application_settings"."force_pages_access_control",
       "application_settings"."updating_name_disabled_for_users",
       "application_settings"."elasticsearch_indexed_field_length_limit",
       "application_settings"."elasticsearch_max_bulk_size_mb",
       "application_settings"."elasticsearch_max_bulk_concurrency",
       "application_settings"."disable_overriding_approvers_per_merge_request",
       "application_settings"."prevent_merge_requests_author_approval",
       "application_settings"."prevent_merge_requests_committers_approval",
       "application_settings"."email_restrictions_enabled",
       "application_settings"."email_restrictions",
       "application_settings"."npm_package_requests_forwarding",
       "application_settings"."container_expiration_policies_enable_historic_entries",
       "application_settings"."issues_create_limit",
       "application_settings"."push_rule_id",
       "application_settings"."group_owners_can_manage_default_branch_protection",
       "application_settings"."container_registry_vendor",
       "application_settings"."container_registry_version",
       "application_settings"."container_registry_features",
       "application_settings"."spam_check_endpoint_url",
       "application_settings"."spam_check_endpoint_enabled",
       "application_settings"."elasticsearch_pause_indexing",
       "application_settings"."repository_storages_weighted",
       "application_settings"."max_import_size",
       "application_settings"."compliance_frameworks",
       "application_settings"."notify_on_unknown_sign_in",
       "application_settings"."default_branch_name",
       "application_settings"."project_import_limit",
       "application_settings"."project_export_limit",
       "application_settings"."project_download_export_limit",
       "application_settings"."group_import_limit",
       "application_settings"."group_export_limit",
       "application_settings"."group_download_export_limit",
       "application_settings"."maintenance_mode",
       "application_settings"."maintenance_mode_message",
       "application_settings"."wiki_page_max_content_bytes",
       "application_settings"."elasticsearch_indexed_file_size_limit_kb",
       "application_settings"."enforce_namespace_storage_limit",
       "application_settings"."container_registry_delete_tags_service_timeout",
       "application_settings"."kroki_url",
       "application_settings"."kroki_enabled",
       "application_settings"."elasticsearch_client_request_timeout",
       "application_settings"."gitpod_enabled",
       "application_settings"."gitpod_url",
       "application_settings"."abuse_notification_email",
       "application_settings"."require_admin_approval_after_user_signup",
       "application_settings"."help_page_documentation_base_url",
       "application_settings"."automatic_purchased_storage_allocation",
       "application_settings"."encrypted_ci_jwt_signing_key",
       "application_settings"."encrypted_ci_jwt_signing_key_iv",
       "application_settings"."container_registry_expiration_policies_worker_capacity",
       "application_settings"."elasticsearch_analyzers_smartcn_enabled",
       "application_settings"."elasticsearch_analyzers_smartcn_search",
       "application_settings"."elasticsearch_analyzers_kuromoji_enabled",
       "application_settings"."elasticsearch_analyzers_kuromoji_search",
       "application_settings"."secret_detection_token_revocation_enabled",
       "application_settings"."secret_detection_token_revocation_url",
       "application_settings"."encrypted_secret_detection_token_revocation_token",
       "application_settings"."encrypted_secret_detection_token_revocation_token_iv",
       "application_settings"."domain_denylist_enabled",
       "application_settings"."domain_denylist",
       "application_settings"."domain_allowlist",
       "application_settings"."new_user_signups_cap",
       "application_settings"."encrypted_cloud_license_auth_token",
       "application_settings"."encrypted_cloud_license_auth_token_iv",
       "application_settings"."secret_detection_revocation_token_types_url",
       "application_settings"."disable_feed_token",
       "application_settings"."personal_access_token_prefix",
       "application_settings"."rate_limiting_response_text",
       "application_settings"."invisible_captcha_enabled",
       "application_settings"."container_registry_cleanup_tags_service_max_list_size",
       "application_settings"."git_two_factor_session_expiry",
       "application_settings"."keep_latest_artifact",
       "application_settings"."notes_create_limit",
       "application_settings"."notes_create_limit_allowlist",
       "application_settings"."kroki_formats",
       "application_settings"."asset_proxy_whitelist",
       "application_settings"."admin_mode",
       "application_settings"."external_pipeline_validation_service_timeout",
       "application_settings"."encrypted_external_pipeline_validation_service_token",
       "application_settings"."encrypted_external_pipeline_validation_service_token_iv",
       "application_settings"."external_pipeline_validation_service_url",
       "application_settings"."throttle_unauthenticated_packages_api_requests_per_period",
       "application_settings"."throttle_unauthenticated_packages_api_period_in_seconds",
       "application_settings"."throttle_authenticated_packages_api_requests_per_period",
       "application_settings"."throttle_authenticated_packages_api_period_in_seconds",
       "application_settings"."throttle_unauthenticated_packages_api_enabled",
       "application_settings"."throttle_authenticated_packages_api_enabled",
       "application_settings"."deactivate_dormant_users",
       "application_settings"."whats_new_variant",
       "application_settings"."encrypted_spam_check_api_key",
       "application_settings"."encrypted_spam_check_api_key_iv",
       "application_settings"."floc_enabled",
       "application_settings"."elasticsearch_username",
       "application_settings"."encrypted_elasticsearch_password",
       "application_settings"."encrypted_elasticsearch_password_iv",
       "application_settings"."diff_max_lines",
       "application_settings"."diff_max_files",
       "application_settings"."valid_runner_registrars",
       "application_settings"."encrypted_mailgun_signing_key",
       "application_settings"."encrypted_mailgun_signing_key_iv",
       "application_settings"."mailgun_events_enabled",
       "application_settings"."usage_ping_features_enabled",
       "application_settings"."encrypted_customers_dot_jwt_signing_key",
       "application_settings"."encrypted_customers_dot_jwt_signing_key_iv",
       "application_settings"."pypi_package_requests_forwarding",
       "application_settings"."throttle_unauthenticated_files_api_requests_per_period",
       "application_settings"."throttle_unauthenticated_files_api_period_in_seconds",
       "application_settings"."throttle_authenticated_files_api_requests_per_period",
       "application_settings"."throttle_authenticated_files_api_period_in_seconds",
       "application_settings"."throttle_unauthenticated_files_api_enabled",
       "application_settings"."throttle_authenticated_files_api_enabled",
       "application_settings"."max_yaml_size_bytes",
       "application_settings"."max_yaml_depth",
       "application_settings"."throttle_authenticated_git_lfs_requests_per_period",
       "application_settings"."throttle_authenticated_git_lfs_period_in_seconds",
       "application_settings"."throttle_authenticated_git_lfs_enabled",
       "application_settings"."user_deactivation_emails_enabled",
       "application_settings"."throttle_unauthenticated_api_enabled",
       "application_settings"."throttle_unauthenticated_api_requests_per_period",
       "application_settings"."throttle_unauthenticated_api_period_in_seconds",
       "application_settings"."jobs_per_stage_page_size",
       "application_settings"."sidekiq_job_limiter_mode",
       "application_settings"."sidekiq_job_limiter_compression_threshold_bytes",
       "application_settings"."sidekiq_job_limiter_limit_bytes",
       "application_settings"."suggest_pipeline_enabled",
       "application_settings"."throttle_unauthenticated_deprecated_api_requests_per_period",
       "application_settings"."throttle_unauthenticated_deprecated_api_period_in_seconds",
       "application_settings"."throttle_unauthenticated_deprecated_api_enabled",
       "application_settings"."throttle_authenticated_deprecated_api_requests_per_period",
       "application_settings"."throttle_authenticated_deprecated_api_period_in_seconds",
       "application_settings"."throttle_authenticated_deprecated_api_enabled",
       "application_settings"."dependency_proxy_ttl_group_policy_worker_capacity",
       "application_settings"."content_validation_endpoint_url",
       "application_settings"."encrypted_content_validation_api_key",
       "application_settings"."encrypted_content_validation_api_key_iv",
       "application_settings"."content_validation_endpoint_enabled",
       "application_settings"."sentry_enabled",
       "application_settings"."sentry_dsn",
       "application_settings"."sentry_clientside_dsn",
       "application_settings"."sentry_environment",
       "application_settings"."max_ssh_key_lifetime",
       "application_settings"."static_objects_external_storage_auth_token_encrypted",
       "application_settings"."future_subscriptions",
       "application_settings"."packages_cleanup_package_file_worker_capacity",
       "application_settings"."container_registry_import_max_tags_count",
       "application_settings"."container_registry_import_max_retries",
       "application_settings"."container_registry_import_start_max_retries",
       "application_settings"."container_registry_import_max_step_duration",
       "application_settings"."container_registry_import_target_plan",
       "application_settings"."container_registry_import_created_before",
       "application_settings"."runner_token_expiration_interval",
       "application_settings"."group_runner_token_expiration_interval",
       "application_settings"."project_runner_token_expiration_interval",
       "application_settings"."ecdsa_sk_key_restriction",
       "application_settings"."ed25519_sk_key_restriction",
       "application_settings"."users_get_by_id_limit",
       "application_settings"."users_get_by_id_limit_allowlist",
       "application_settings"."container_registry_expiration_policies_caching",
       "application_settings"."search_rate_limit",
       "application_settings"."search_rate_limit_unauthenticated",
       "application_settings"."encrypted_database_grafana_api_key",
       "application_settings"."encrypted_database_grafana_api_key_iv",
       "application_settings"."database_grafana_api_url",
       "application_settings"."database_grafana_tag",
       "application_settings"."public_runner_releases_url",
       "application_settings"."password_uppercase_required",
       "application_settings"."password_lowercase_required",
       "application_settings"."password_number_required",
       "application_settings"."password_symbol_required",
       "application_settings"."encrypted_arkose_labs_public_api_key",
       "application_settings"."encrypted_arkose_labs_public_api_key_iv",
       "application_settings"."encrypted_arkose_labs_private_api_key",
       "application_settings"."encrypted_arkose_labs_private_api_key_iv",
       "application_settings"."arkose_labs_verify_api_url",
       "application_settings"."delete_inactive_projects",
       "application_settings"."inactive_projects_delete_after_months",
       "application_settings"."inactive_projects_min_size_mb",
       "application_settings"."inactive_projects_send_warning_email_after_months",
       "application_settings"."maven_package_requests_forwarding",
       "application_settings"."arkose_labs_namespace",
       "application_settings"."max_export_size",
       "application_settings"."encrypted_slack_app_signing_secret",
       "application_settings"."encrypted_slack_app_signing_secret_iv",
       "application_settings"."container_registry_pre_import_timeout",
       "application_settings"."container_registry_import_timeout",
       "application_settings"."pipeline_limit_per_project_user_sha",
       "application_settings"."dingtalk_integration_enabled",
       "application_settings"."encrypted_dingtalk_corpid",
       "application_settings"."encrypted_dingtalk_corpid_iv",
       "application_settings"."encrypted_dingtalk_app_key",
       "application_settings"."encrypted_dingtalk_app_key_iv",
       "application_settings"."encrypted_dingtalk_app_secret",
       "application_settings"."encrypted_dingtalk_app_secret_iv",
       "application_settings"."jira_connect_application_key",
       "application_settings"."globally_allowed_ips",
       "application_settings"."container_registry_pre_import_tags_rate",
       "application_settings"."license_usage_data_exported",
       "application_settings"."phone_verification_code_enabled",
       "application_settings"."max_number_of_repository_downloads",
       "application_settings"."max_number_of_repository_downloads_within_time_period",
       "application_settings"."feishu_integration_enabled",
       "application_settings"."encrypted_feishu_app_key",
       "application_settings"."encrypted_feishu_app_key_iv",
       "application_settings"."encrypted_feishu_app_secret",
       "application_settings"."encrypted_feishu_app_secret_iv",
       "application_settings"."error_tracking_enabled",
       "application_settings"."error_tracking_api_url",
       "application_settings"."git_rate_limit_users_allowlist",
       "application_settings"."error_tracking_access_token_encrypted",
       "application_settings"."invitation_flow_enforcement",
       "application_settings"."package_registry_cleanup_policies_worker_capacity",
       "application_settings"."deactivate_dormant_users_period",
       "application_settings"."auto_ban_user_on_excessive_projects_download",
       "application_settings"."max_pages_custom_domains_per_project",
       "application_settings"."cube_api_base_url",
       "application_settings"."encrypted_cube_api_key",
       "application_settings"."encrypted_cube_api_key_iv",
       "application_settings"."dashboard_limit_enabled",
       "application_settings"."dashboard_limit",
       "application_settings"."can_create_group",
       "application_settings"."lock_maven_package_requests_forwarding",
       "application_settings"."lock_pypi_package_requests_forwarding",
       "application_settings"."lock_npm_package_requests_forwarding",
       "application_settings"."jira_connect_proxy_url",
       "application_settings"."password_expiration_enabled",
       "application_settings"."password_expires_in_days",
       "application_settings"."password_expires_notice_before_days",
       "application_settings"."product_analytics_enabled",
       "application_settings"."email_confirmation_setting",
       "application_settings"."disable_admin_oauth_scopes",
       "application_settings"."default_preferred_language",
       "application_settings"."disable_download_button",
       "application_settings"."encrypted_telesign_customer_xid",
       "application_settings"."encrypted_telesign_customer_xid_iv",
       "application_settings"."encrypted_telesign_api_key",
       "application_settings"."encrypted_telesign_api_key_iv",
       "application_settings"."disable_personal_access_tokens",
       "application_settings"."max_terraform_state_size_bytes",
       "application_settings"."bulk_import_enabled",
       "application_settings"."allow_runner_registration_token",
       "application_settings"."user_defaults_to_private_profile",
       "application_settings"."allow_possible_spam",
       "application_settings"."default_syntax_highlighting_theme",
       "application_settings"."search_max_shard_size_gb",
       "application_settings"."search_max_docs_denominator",
       "application_settings"."search_min_docs_before_rollover",
       "application_settings"."deactivation_email_additional_text",
       "application_settings"."jira_connect_public_key_storage_enabled",
       "application_settings"."git_rate_limit_users_alertlist",
       "application_settings"."allow_deploy_tokens_and_keys_with_external_authn",
       "application_settings"."security_policy_global_group_approvers_enabled",
       "application_settings"."projects_api_rate_limit_unauthenticated",
       "application_settings"."deny_all_requests_except_allowed",
       "application_settings"."product_analytics_data_collector_host",
       "application_settings"."lock_memberships_to_saml",
       "application_settings"."gitlab_dedicated_instance",
       "application_settings"."update_runner_versions_enabled",
       "application_settings"."encrypted_openai_api_key",
       "application_settings"."encrypted_openai_api_key_iv",
       "application_settings"."database_max_running_batched_background_migrations",
       "application_settings"."encrypted_product_analytics_configurator_connection_string",
       "application_settings"."encrypted_product_analytics_configurator_connection_string_iv",
       "application_settings"."silent_mode_enabled",
       "application_settings"."package_metadata_purl_types",
       "application_settings"."ci_max_includes",
       "application_settings"."remember_me_enabled",
       "application_settings"."encrypted_anthropic_api_key",
       "application_settings"."encrypted_anthropic_api_key_iv",
       "application_settings"."diagramsnet_enabled",
       "application_settings"."diagramsnet_url",
       "application_settings"."allow_account_deletion",
       "application_settings"."wiki_asciidoc_allow_uri_includes",
       "application_settings"."namespace_aggregation_schedule_lease_duration_in_seconds",
       "application_settings"."container_registry_data_repair_detail_worker_max_concurrency",
       "application_settings"."vertex_ai_host",
       "application_settings"."encrypted_vertex_ai_credentials",
       "application_settings"."encrypted_vertex_ai_credentials_iv",
       "application_settings"."vertex_ai_project",
       "application_settings"."delete_unconfirmed_users",
       "application_settings"."unconfirmed_users_delete_after_days",
       "application_settings"."default_branch_protection_defaults",
       "application_settings"."gitlab_shell_operation_limit",
       "application_settings"."elasticsearch_requeue_workers",
       "application_settings"."elasticsearch_worker_number_of_shards",
       "application_settings"."protected_paths_for_get_request",
       "application_settings"."namespace_storage_forks_cost_factor",
       "application_settings"."package_registry_allow_anyone_to_pull_option",
       "application_settings"."bulk_import_max_download_file_size",
       "application_settings"."max_import_remote_file_size",
       "application_settings"."max_decompressed_archive_size",
       "application_settings"."sentry_clientside_traces_sample_rate",
       "application_settings"."prometheus_alert_db_indicators_settings",
       "application_settings"."ci_max_total_yaml_size_bytes",
       "application_settings"."decompress_archive_file_timeout",
       "application_settings"."search_rate_limit_allowlist",
       "application_settings"."snowplow_database_collector_hostname",
       "application_settings"."container_registry_db_enabled",
       "application_settings"."failed_login_attempts_unlock_period_in_minutes",
       "application_settings"."max_login_attempts",
       "application_settings"."encrypted_vertex_ai_access_token",
       "application_settings"."encrypted_vertex_ai_access_token_iv",
       "application_settings"."project_jobs_api_rate_limit",
       "application_settings"."math_rendering_limits_enabled",
       "application_settings"."service_access_tokens_expiration_enforced",
       "application_settings"."make_profile_private",
       "application_settings"."enable_artifact_external_redirect_warning_page",
       "application_settings"."allow_project_creation_for_guest_and_below",
       "application_settings"."update_namespace_name_rate_limit",
       "application_settings"."pre_receive_secret_detection_enabled",
       "application_settings"."can_create_organization",
       "application_settings"."bulk_import_concurrent_pipeline_batch_limit",
       "application_settings"."web_ide_oauth_application_id",
       "application_settings"."instance_level_ai_beta_features_enabled",
       "application_settings"."security_txt_content",
       "application_settings"."encrypted_arkose_labs_data_exchange_key",
       "application_settings"."encrypted_arkose_labs_data_exchange_key_iv",
       "application_settings"."toggle_security_policy_custom_ci",
       "application_settings"."lock_toggle_security_policy_custom_ci",
       "application_settings"."toggle_security_policies_policy_scope",
       "application_settings"."lock_toggle_security_policies_policy_scope",
       "application_settings"."rate_limits",
       "application_settings"."elasticsearch_max_code_indexing_concurrency",
       "application_settings"."enable_member_promotion_management",
       "application_settings"."lock_math_rendering_limits_enabled",
       "application_settings"."security_approval_policies_limit",
       "application_settings"."encrypted_arkose_labs_client_xid",
       "application_settings"."encrypted_arkose_labs_client_xid_iv",
       "application_settings"."encrypted_arkose_labs_client_secret",
       "application_settings"."encrypted_arkose_labs_client_secret_iv",
       "application_settings"."asciidoc_max_includes",
       "application_settings"."duo_features_enabled",
       "application_settings"."lock_duo_features_enabled",
       "application_settings"."clickhouse",
       "application_settings"."include_optional_metrics_in_service_ping",
       "application_settings"."zoekt_settings"
FROM "application_settings"
ORDER BY "application_settings"."id" DESC
LIMIT 1

https://console.postgres.ai/shared/1e7e4669-abcc-4157-9ce4-3a89c3e375cb

Related to #389765 (closed)

#452021 (closed)

Edited Apr 02, 2024 by Ravi Kumar

Migrate values to zoekt_settings

What does this MR do and why?

MR acceptance checklist

Screenshots or screen recordings

How to set up and validate locally

Query plan

Merge request reports