search

fuel9 / DisplayMonkey

Display Monkey digital signage solution
Other
126 stars 50 forks source link

Timeout period elapsed prior to obtaining a connection from the pool #131

Open shep2644 opened 5 years ago

shep2644 commented 5 years ago

Getting an error across all my displays. I am on version 1.5.2.162. Error states

"The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached."

We have been running well for about a 1 year. We do no recall any changes having taken place but this just started occurring over the weekend. Any help is appreciated.

michaelmalmgren commented 5 years ago

Hi,

It sounds that you may need to set a higher Max Pool Size value in web.config. I suggest giving it try and see if it fix the issue.

https://social.msdn.microsoft.com/Forums/en-US/a781e91b-d29f-4910-8154-b1b723d1394d/what-is-maximum-allowable-value-of-quotmax-pool-sizequot-in-sql-connection-string?forum=adodotnetdataproviders

shep2644 commented 5 years ago

I tried that. I originally did not see a "Pool Size" or "Pooling" option in my web.config so I added. See below. That still did not resolve

<add name="DisplayMonkeyDB" connectionString="Data Source=DSignPRSQL.ad.hs.uab.edu;Initial Catalog="DisplayMonkey";Persist Security Info=True;User ID=XXXXXXXXXX;Password=XXXXXXXXXX;Max Pool Size=200;Pooling=true"

michaelmalmgren commented 5 years ago

It is a bit of a shot in the dark but why don't you try to increase the number of maximum worker threads in the application pool:

https://user-images.githubusercontent.com/48595580/54740554-09b06200-4bbc-11e9-83db-0433bd6eebd5.jpg