Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

connection pool stalling...

 
Chris Montgomery
Ranch Hand
Posts: 141
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I've used this connection pool for a few years now, but only recently has it been put to the test. Recently, a few bad queries were written to fuel some reports causing the system to come to a hault if run during a busy time. We found that once the queries were done running, the database became healthy again, but the connection pool wouldn't begin to deliver connection threads again.

Yes, the queries are gone, but I'm actually glad to have experienced this, because it exposed an issue with the connection pool.

Why won�t the connection pool �start up� again?

It's almost like there isn't a timeout and once the database goes down, all the threads get used up and they don't let go ever...

Any ideas?

Thanks!



Constructor


GetConnection Code
 
Scott Selikoff
author
Saloon Keeper
Posts: 4032
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm going to go to out on a limb and say your database needs some performance tuning for proper indexes. On a poorly tuned database, even the most simple queries could stall the entire system.
 
Chris Montgomery
Ranch Hand
Posts: 141
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Even if the database was terribly constructed, could that really be the reason why the connection pool doesn't allow you to connect even when the database is no longer over burdened?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic