运行sidekiq数据库配置时，Rails 6未指定适配器

本文介绍了运行sidekiq数据库配置时，Rails 6未指定适配器的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

最近，我们开始将代码库从rails 5迁移到rails 6.每当我们尝试在生产模式下运行sidekiq时，总是会抛出错误数据库配置未指定适配器.我很确定我们已经在database.yml中提到了一个适配器.有人可以帮忙解决此问题吗?

Recently we started migrating our codebase from rails 5 to rails 6. Everything seems to work fine except sidekiq. Whenever we tried to run sidekiq in production mode it always throws an error database configuration does not specify adapter. I am pretty sure that we have mentioned an adapter in database.yml. Can someone please help to resolve this issue?

供参考

Rails 6.0.3.4

Rails 6.0.3.4

Sidekiq 6.1.2

Sidekiq 6.1.2

Ruby 2.7.1p83

Ruby 2.7.1p83

databsae.yml文件

databsae.yml file

default: &default adapter: postgresql pool: <%= ENV['DATABASE_POOL'] %> timeout: 5000 database: anajmandi development: primary: <<: *default url: <%= ENV['DATABASE_URL'] %> multidb: fallback: true follower: <<: *default url: <%= ENV['DATABASE_SLAVE_URL'] %> replica: true multidb: fallback: true test: <<: *default database: db/test.sqlite3 production: primary: <<: *default url: <%= ENV['DATABASE_URL'] %> multidb: fallback: true follower: <<: *default url: <%= ENV['DATABASE_SLAVE_URL'] %> replica: true multidb: fallback: true

和sidekiq.rb文件

and sidekiq.rb file

# typed: strict if Rails.env.production? # three unicorns = 3 connections Sidekiq.configure_client do |config| config.redis = { :size => 1 } end Sidekiq.configure_server do |config| config.redis = { url: ENV['REDIS_URL'], size: 22 } Rails.application.config.after_initialize do Rails.logger.info("DB Connection Pool size for Sidekiq Server before disconnect is: #{ActiveRecord::Base.connection.pool.instance_variable_get('@size')}") ActiveRecord::Base.connection_pool.disconnect! ActiveSupport.on_load(:active_record) do config = Rails.application.config.database_configuration[Rails.env] config['reaping_frequency'] = ENV['DATABASE_REAP_FREQ'] || 10 # seconds config['pool'] = ENV['WORKER_DB_POOL_SIZE'] || Sidekiq.options[:concurrency] ActiveRecord::Base.establish_connection(config) Rails.logger.info("DB Connection Pool size for Sidekiq Server is now: #{ActiveRecord::Base.connection.pool.instance_variable_get('@size')}") end end end end

这是运行命令 bundle exec sidekiq -e production -C config/sidekiq.yml

DB Connection Pool size for Sidekiq Server before disconnect is: 5 database configuration does not specify adapter /Users/yadusingla/.rvm/gems/ruby-2.7.1/gems/activerecord-6.0.3.4/lib/active_record/connection_adapters/connection_specification.rb:161:in `spec' /Users/yadusingla/.rvm/gems/ruby-2.7.1/gems/activerecord-6.0.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:1052:in `establish_connection' /Users/yadusingla/.rvm/gems/ruby-2.7.1/gems/activerecord-6.0.3.4/lib/active_record/connection_handling.rb:51:in `establish_connection' /Users/yadusingla/.rvm/gems/ruby-2.7.1/gems/activerecord-import-1.0.6/lib/activerecord-import/import.rb:250:in `establish_connection' /Users/yadusingla/spars/procol-backend/config/initializers/sidekiq.rb:19:in `block (3 levels) in <top (required)>' /Users/yadusingla/.rvm/gems/ruby-2.7.1/gems/activesupport-6.0.3.4/lib/active_support/lazy_load_hooks.rb:71:in `class_eval' /Users/yadusingla/.rvm/gems/ruby-2.7.1/gems/activesupport-6.0.3.4/lib/active_support/lazy_load_hooks.rb:71:in `block in execute_hook' /Users/yadusingla/.rvm/gems/ruby-2.7.1/gems/activesupport-6.0.3.4/lib/active_support/lazy_load_hooks.rb:61:in `with_execution_control' /Users/yadusingla/.rvm/gems/ruby-2.7.1/gems/activesupport-6.0.3.4/lib/active_support/lazy_load_hooks.rb:66:in `execute_hook' /Users/yadusingla/.rvm/gems/ruby-2.7.1/gems/activesupport-6.0.3.4/lib/active_support/lazy_load_hooks.rb:43:in `block in on_load' /Users/yadusingla/.rvm/gems/ruby-2.7.1/gems/activesupport-6.0.3.4/lib/active_support/lazy_load_hooks.rb:42:in `each' /Users/yadusingla/.rvm/gems/ruby-2.7.1/gems/activesupport-6.0.3.4/lib/active_support/lazy_load_hooks.rb:42:in `on_load'

推荐答案

此处我使用的是3层配置，因此对于3层配置初始化器未正确定义.如果我们通过环境变量选择配置，那么我们将获得两个，即主要变量和关注者变量.Rails不知道要访问哪一个，所以应用程序必须选择正确的一个.

Here I am using a 3-tier configuration, so for 3 tier configuration initializer isn't correctly defined. If we select configurations by environment variable then we'll get two, both primary and follower. Rails don't know which one to access so the app has to select the right one.

将 config = Rails.application.config.database_configuration [Rails.env] 更改为

self.configurations = Rails.application.config.database_configuration

config = configuration.configs_for(env_name:Rails.env，spec_name:"primary").config

请参阅此链接 github/rails/rails/issues/40640