• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 378
  • Last Modified:

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;"/>
   
0
Tom Knowlton
Asked:
Tom Knowlton
  • 4
  • 4
1 Solution
 
fhillyer1Commented:
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
0
 
fhillyer1Commented:
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
0
 
Tom KnowltonWeb developerAuthor Commented:
How can I find out what version of MySQL connector I am using?
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
Tom KnowltonWeb developerAuthor Commented:
0
 
fhillyer1Commented:
yes, that's the one, hmmm 6.0.4
try to run it without the timeout setting
0
 
Tom KnowltonWeb developerAuthor Commented:
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.
0
 
fhillyer1Commented:
try increasing the pool size
<add name="leadcollatordb" connectionString="server=10.1.1.160; uid=root; pwd='<<hidden>>'; database=leadcollator_dbo; default command timeout=28000; Min Pool Size = 25; Max Pool Size=150"/>

Open in new window

0
 
Tom KnowltonWeb developerAuthor Commented:
I may try that at some point.

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

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now