Re: How to reslove Pool error Timeout waiting for idle object
Posted by: Todd Farmer
Date: February 11, 2014 12:45PM

Hi Satish,

Any configuration change I can recommend will only address this particular *symptom* of the problem, not the fundamental problem itself. Almost certainly there is some application behavior or interaction with the database which is poorly-tuned, causing connections to stack up - or the connection pool itself isn't well sized for the workload the application is driving. Those problems will only be identified and solved by much more comprehensive and focused investigation than is possible here (MySQL Support can help).

That said, the reported symptom seems to be lack of idle connections in the DBCP pool, so you might increase both maxActive and maxIdle configuration options:

http://commons.apache.org/proper/commons-dbcp/configuration.html

Another option would be to tell DBCP to simply wait longer before timing out, while waiting for an idle connection, by increasing maxWait. I'm guessing that has been explicitly set already, since the default behavior is to wait indefinitely. Perhaps that value is set irrationally low for current workloads?

Hope that helps!

--
Todd Farmer
MySQL @ Oracle
http://www.oracle.com/mysql/

Options: ReplyQuote


Subject
Written By
Posted
Re: How to reslove Pool error Timeout waiting for idle object
February 11, 2014 12:45PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.