I failed to call Dispose()
-
A bit amateur-hour, that. I've spent 2 hours trying to work out why things work great for 5 page views and then die a horrible death-by-timeout for every cache call. Several hundred lines of extra logging calls and there it was: the connection pool was being exhausted because I wasn't using a
usingstatement. But of course the kicker is that the original error message telling me that it was a connection pool issue had been staring me in the face all that time :doh:cheers Chris Maunder
-
A bit amateur-hour, that. I've spent 2 hours trying to work out why things work great for 5 page views and then die a horrible death-by-timeout for every cache call. Several hundred lines of extra logging calls and there it was: the connection pool was being exhausted because I wasn't using a
usingstatement. But of course the kicker is that the original error message telling me that it was a connection pool issue had been staring me in the face all that time :doh:cheers Chris Maunder
Shit happens :)
A person who never made a mistake never tried anything new -Einstein, Albert
-
A bit amateur-hour, that. I've spent 2 hours trying to work out why things work great for 5 page views and then die a horrible death-by-timeout for every cache call. Several hundred lines of extra logging calls and there it was: the connection pool was being exhausted because I wasn't using a
usingstatement. But of course the kicker is that the original error message telling me that it was a connection pool issue had been staring me in the face all that time :doh:cheers Chris Maunder
Oh, you're one of THOSE guys, eh? Had one at a previous job. Only, he wrote a massive website over 5+ years, so there were undisposed SQL connections everywhere. I eventually got it all fixed up by naming the connection strings and tracking down the locations that left the most unclosed connections. Took much longer than 2 hours!
-
A bit amateur-hour, that. I've spent 2 hours trying to work out why things work great for 5 page views and then die a horrible death-by-timeout for every cache call. Several hundred lines of extra logging calls and there it was: the connection pool was being exhausted because I wasn't using a
usingstatement. But of course the kicker is that the original error message telling me that it was a connection pool issue had been staring me in the face all that time :doh:cheers Chris Maunder
You've had a long week, these things happen ... at least it didn't get out into the outside world, where 10.46 Million members might find out. Oh... :laugh:
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
-
A bit amateur-hour, that. I've spent 2 hours trying to work out why things work great for 5 page views and then die a horrible death-by-timeout for every cache call. Several hundred lines of extra logging calls and there it was: the connection pool was being exhausted because I wasn't using a
usingstatement. But of course the kicker is that the original error message telling me that it was a connection pool issue had been staring me in the face all that time :doh:cheers Chris Maunder
-
A bit amateur-hour, that. I've spent 2 hours trying to work out why things work great for 5 page views and then die a horrible death-by-timeout for every cache call. Several hundred lines of extra logging calls and there it was: the connection pool was being exhausted because I wasn't using a
usingstatement. But of course the kicker is that the original error message telling me that it was a connection pool issue had been staring me in the face all that time :doh:cheers Chris Maunder
Oh, so you're indisposed now? I'll get my coat, officer...
Software Zen:
delete this; -
Oh, you're one of THOSE guys, eh? Had one at a previous job. Only, he wrote a massive website over 5+ years, so there were undisposed SQL connections everywhere. I eventually got it all fixed up by naming the connection strings and tracking down the locations that left the most unclosed connections. Took much longer than 2 hours!
Real Programmers don't Dispose. They hide the object in a rolled up carpet in the back of an abandoned car.
cheers Chris Maunder
-
A bit amateur-hour, that. I've spent 2 hours trying to work out why things work great for 5 page views and then die a horrible death-by-timeout for every cache call. Several hundred lines of extra logging calls and there it was: the connection pool was being exhausted because I wasn't using a
usingstatement. But of course the kicker is that the original error message telling me that it was a connection pool issue had been staring me in the face all that time :doh:cheers Chris Maunder
'There is nothing more deceptive than an obvious fact.' Sherlock Holmes Quote -The Bascombe Valley Mystery
Along with Antimatter and Dark Matter they've discovered the existence of Doesn't Matter which appears to have no effect on the universe whatsoever! Rich Tennant 5th Wave
-
A bit amateur-hour, that. I've spent 2 hours trying to work out why things work great for 5 page views and then die a horrible death-by-timeout for every cache call. Several hundred lines of extra logging calls and there it was: the connection pool was being exhausted because I wasn't using a
usingstatement. But of course the kicker is that the original error message telling me that it was a connection pool issue had been staring me in the face all that time :doh:cheers Chris Maunder
