最近,我们开始将代码库从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
更多推荐
运行sidekiq数据库配置时,Rails 6未指定适配器
发布评论