Timeout expired error in mysql with C# in my asp.net web application? [duplicate]

Question

I have developed one asp.net application with mysql database connection.Some times i am facing the timeout error when looking at the pages.i also set the connection time. but still am receiving the same error dynamically.I couldn't able to figure it out about in which situation it has occurred.

This is the complete error message that i received...

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.

What are all the parameter i have to monitor to solve this error?

Please guide me to solve this...

There is only one escape and it is called using statement

Steve
– Steve

2013-07-20 12:05:37 +00:00
Commented Jul 20, 2013 at 12:05 — Steve
– Steve, Commented Jul 20, 2013 at 12:05

shamcs · Accepted Answer · 2013-07-20 16:11:13Z

1

Did you close the connection after you open it..?

try
{
     conn.Open();
     someCall (myConnection);
}
finally
{
     myConnection.Close();                
}

In MSSQL you can check connection by using this "sp_lock, sp_who" .. Check this site: http://www.xaprb.com/blog/2006/07/31/how-to-analyze-innodb-mysql-locks/ for equivalent in mysql

answered Jul 20, 2013 at 16:11

shamcs

6196 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ehsan · Accepted Answer · 2013-07-20 11:50:14Z

0

It means that you are running out of the connections available in the connection pool. You can increase that in the connection string the max pool size. But it is recommendedthat you check why are you not closing the connections after you have used them.

answered Jul 20, 2013 at 11:50

Ehsan

32.8k6 gold badges61 silver badges66 bronze badges

Collectives™ on Stack Overflow

Timeout expired error in mysql with C# in my asp.net web application? [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related