Link to home
Start Free TrialLog in
Avatar of Tom Knowlton
Tom KnowltonFlag for United States of America

asked on

Timeout error - MySQL

{"error connecting: 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."}

Error Code:  -2147467259   (is there a list of error codes and troubleshooting error codes, somewhere?)

Here is the connection string:

<add name="leadcollatordb" connectionString="server=10.1.1.160; uid=root; pwd='<<hidden>>'; database=leadcollator_dbo; default command timeout=28000;"/>
   
Avatar of fhillyer1
fhillyer1

http://dev.mysql.com/doc/refman/5.1/en/error-handling.html there is the list about the error codes and let me provide you with a solution on the timeout
give me a sec
What version of MySQL connector Net are you using? there was a bug for this that was fixed http://bugs.mysql.com/bug.php?id=29409
Avatar of Tom Knowlton

ASKER

How can I find out what version of MySQL connector I am using?
yes, that's the one, hmmm 6.0.4
try to run it without the timeout setting
removed default timeout from the connection string.

Still get:

error connecting: 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.
ASKER CERTIFIED SOLUTION
Avatar of fhillyer1
fhillyer1

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I may try that at some point.

I discovered that I had been neglecting to close the connection.