django-db-pool icon indicating copy to clipboard operation
django-db-pool copied to clipboard

Published 20 hours ago • verified publisher icon gmcguire

PoolError: connection pool exausted

Open guytamir1 opened this issue 11 years ago • 3 comments

Hey there,

Started working with django-db-pool. Once I changed the settings and deployed to Heroku I saw immediate improvements in response times.

For some reason when I'm running in dev mode on my machine I'm getting PoolError: connection pool exausted

This happens on the second time I try to query the DB. First time I log in (check DB for data) and all is well, when the next page loads I get the error..

Same code is running great in production.. Any ideas?

guytamir1 avatar Jan 09 '14 09:01 guytamir1

How are you running django on your dev machine? What pool options are you using?

gmcguire avatar Jan 09 '14 19:01 gmcguire

running with foreman.

Update - the same problem now happens in production. Not using any special pool options (Using autocommit - not sure if relavant)

guytamir1 avatar Jan 12 '14 12:01 guytamir1

Depending upon your app server's process/threading model you may need to raise the number of connections in the pool for each process. See the MAX_CONNS parameter in the readme.

gmcguire avatar Jan 24 '14 00:01 gmcguire