ActiveRecord::StatementInvalid (PG::UndefinedColumn: ERROR: column application_settings.user_email_lookup_limit does not exist

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

• Close this issue

After migratinting to gitlab 14.10.3-ce from 14.9.4-ce I get error 500 when trying accessing the gitlab.

Error in gitlab-ctl tail

==> /var/log/gitlab/gitlab-rails/production.log <==

ActiveRecord::StatementInvalid (PG::UndefinedColumn: ERROR:  column application_settings.user_email_lookup_limit does not exist
LINE 1: ...", "application_settings"."future_subscriptions", "applicati...
                                                             ^
):

lib/gitlab/database/load_balancing/connection_proxy.rb:110:in `block in read_using_load_balancer'
lib/gitlab/database/load_balancing/load_balancer.rb:55:in `read'
lib/gitlab/database/load_balancing/connection_proxy.rb:109:in `read_using_load_balancer'
lib/gitlab/database/load_balancing/connection_proxy.rb:54:in `select_all'
app/models/concerns/cacheable_attributes.rb:19:in `current_without_cache'
app/models/concerns/cacheable_attributes.rb:63:in `rescue in current'
app/models/concerns/cacheable_attributes.rb:51:in `current'
lib/gitlab/current_settings.rb:60:in `uncached_application_settings'
lib/gitlab/current_settings.rb:42:in `ensure_application_settings!'
lib/gitlab/current_settings.rb:15:in `block in current_application_settings'
lib/gitlab/safe_request_store.rb:12:in `fetch'
lib/gitlab/current_settings.rb:15:in `current_application_settings'
lib/gitlab/throttle.rb:13:in `settings'
lib/gitlab/rack_attack/request.rb:83:in `throttle_unauthenticated_api?'
lib/gitlab/rack_attack/request.rb:73:in `throttle?'
lib/gitlab/rack_attack.rb:90:in `block (2 levels) in configure_throttles'
lib/gitlab/middleware/read_only/controller.rb:50:in `call'
lib/gitlab/middleware/read_only.rb:18:in `call'
lib/gitlab/middleware/same_site_cookies.rb:27:in `call'
lib/gitlab/middleware/handle_malformed_strings.rb:21:in `call'
lib/gitlab/middleware/basic_health_check.rb:25:in `call'
lib/gitlab/middleware/handle_ip_spoof_attack_error.rb:25:in `call'
lib/gitlab/middleware/request_context.rb:21:in `call'
lib/gitlab/middleware/webhook_recursion_detection.rb:15:in `call'
config/initializers/fix_local_cache_middleware.rb:11:in `call'
lib/gitlab/middleware/compressed_json.rb:26:in `call'
lib/gitlab/middleware/rack_multipart_tempfile_factory.rb:19:in `call'
lib/gitlab/middleware/sidekiq_web_static.rb:20:in `call'
lib/gitlab/metrics/requests_rack_middleware.rb:77:in `call'
lib/gitlab/middleware/release_env.rb:13:in `call'

==> /var/log/gitlab/gitlab-rails/application.log <==
2022-06-04T16:02:27.890Z: Cached record for ApplicationSetting couldn't be loaded, falling back to uncached record: PG::UndefinedColumn: ERROR:  column application_settings.user_email_lookup_limit does not exist
LINE 1: ...", "application_settings"."future_subscriptions", "applicati...
                                                             ^

The column should be removed based on this MR !83358 (merged)

I checked the database and the column is missing because the migration 20220321201912 was applied.