Bug #24220
closed
In development: ActiveRecord::ConnectionTimeoutError in the logs..Recovers after a few attempts..
Description
Get this error in the logs and the server takes some time to load since all connections are busy at the moment. ActiveRecord::ConnectionTimeoutError (could not obtain a connection from the pool within 5.000 seconds (waited 5.000 seconds); all pooled connections were in use)
Updated by Justin Sherrill almost 6 years ago
- Project changed from Katello to foreman-tasks
- Subject changed from ActiveRecord::ConnectionTimeoutError in the logs..Recovers after a few attempts.. to In development: ActiveRecord::ConnectionTimeoutError in the logs..Recovers after a few attempts..
- Category deleted (
81)
We've seen this a lot in katello, but it seems to only occur when the dynflow world gets initialized.
Updated by Ivan Necas almost 6 years ago
- Project changed from foreman-tasks to Foreman
I don't think it has anything to do with Foreman-Tasks, it seems that in rails 5, the lock on 1-request at a time was removed, which leads to the dashboard spinning up more concurrent requests that the db pool is ready for. The proper fix should be to increase the db pool in `config/database.yml`.
Updated by The Foreman Bot almost 6 years ago
- Status changed from New to Ready For Testing
- Assignee set to Ivan Necas
- Pull request https://github.com/theforeman/foreman/pull/5827 added
Updated by Ivan Necas almost 6 years ago
- Pull request https://github.com/theforeman/puppet-katello_devel/pull/165 added
I've sent patches to foreman and katello_devel to increase the pool size with numbers I've stopped getting the issues like this.
Updated by Tomer Brisker almost 6 years ago
- Target version set to 1.19.0
- Fixed in Releases 1.19.0 added
Updated by Ivan Necas almost 6 years ago
- Status changed from Ready For Testing to Closed
- % Done changed from 0 to 100
Applied in changeset 8c7be857a81ef4e98128e831c533254e07bbfd63.
Updated by The Foreman Bot almost 6 years ago
- Pull request https://github.com/theforeman/foreman/pull/5822 added
Updated by Ewoud Kohl van Wijngaarden almost 6 years ago
- Category set to Development tools