I had my site running for almost a month, then suddenly when I was away on vacation(Murphy's anyone? :-) ) the site broke down. All I get now is:
Unhandled Error
Error Details
File
Error Timeout expired. 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.
All I know is that two articles where added, a new survey was added and some forum posts where made.
So since I have no control on the hosting site, I've restored a backup on my test machine. The event viewer says that the problem occurs when doing purgelogs(looking at the stacktrace). So I look around and find someone with a similar problem and they jsut deleted all entries in the eventlog. So I do the same. Does not fix the problem.
The site is running 4.4.1, tried on my test machine to upgrade to 4.5 to see if that fixed the problem, but no luck there either.
I did a SQL trace to look for queries that hung or took a long time to complete, but no such luck. Then only fishy thing I found was that the article module I use run the same queries way too many times. Using the articles from www.efficionconsulting.com. That is the only additional module I use to the ones found here.
Not 100% sure on the details of the hosting, but I know it's SQL Express and uses win 2003 server. It's not an issue with SQL Express as my test machine has SQL 2005 and it does exhibit the same behavior.
Been banging my head against the wall on this issue for 4 hrs straight now. Any help would be appreciated.