Search code examples
ruby-on-railspostgresqlconcurrencysidekiq

Sidekiq - could not obtain a database connection within 5.000 seconds

I get the following warning with Rails 4 and Sidekiq on os x on development

10:13:39 worker.1 | 2014-09-22T07:13:39.857Z 86981 TID-oug0oog10 WARN: could not obtain a database connection within 5.000 seconds (waited 5.002 seconds)
10:13:39 worker.1 | 2014-09-22T07:13:39.857Z 86981 TID-oug0oog10 WARN: /Users/me/.rvm/gems/ruby-2.1.3/gems/activerecord-4.1.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:190:in `block in wait_poll'

I read other answers that say to reduce the concurrency I give to sidekiq to allow more for other things, but with

worker: bundle exec sidekiq -c 10

it still doesn't work

I am using Postgres.app

What should the numbers/concurrency be in localhost?

Solution

  • I set database pool to sidekiq concurrency and now it works for me.

    bundle exec sidekiq -c 10

    in my database.yml

    development:
  adapter: postgresql
  ...
  host: localhost
  pool: 10