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

Question

1.80/5 (4 votes)

See more:

, +

Does any one know what is going on with this error and how can i solve it ?

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. at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open()

Thanks in advance

Posted 17-Jul-12 23:00pm

rushdi obeidat

Updated 15-Jan-19 1:32am

Add a Solution

5 solutions

Solution 4

I got this issue recently as one function is creating DbDataReader and returns to other function for iterating. After closing the dataReader in the consumer function it was not closing the connections. So used the below method to create DbDataReader which force to close the connection when the reader closes.

C#

Dim reader As DbDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection)
Return reader

Posted 16-Jan-14 20:46pm

Joy George K

Solution 8

getting This Issue because of the exceeding max pool size.
Note: The default pool size is max 100 and 15 seconds for the connection timeout

To Resolve this issue check the following things...
1 You are closing the connection after using it.
Example:
SqlConnection con= new SqlConnection(connString);
SqlCommand cmd= new SqlCommand("SELECT * FROM ReatilersDetails", con);
con.Open();
SqlDataReader sdr = cmd.ExecuteReader();
sdr.Close();
con.Close();

2) Explicitly close the connection when done.
con.Close();

3) Use the connection in a Using block.
using(SqlConnection con= new SqlConnection(connString))
{
};

Posted 15-Jan-19 1:32am

Sr. Rohi Ghatage

Updated 15-Jan-19 1:33am

Comments

aalhussein 1-Apr-20 15:42pm

Hi Rohi,
If I use the word " using ", is it going to close the connection automatically after getting the data from the DB.
I wil lpost my code for your review and do appreciate your comments to improve and to avoid exceeding connection:
public int InsertUpdateDelete(string mySql, Dictionary<string, object=""> myPara)
{
int rtn = 0;
using (SqlCommand cmd = new SqlCommand(mySql, con))
{
cmd.CommandType = CommandType.Text;
foreach (KeyValuePair<string, object=""> p in myPara)
{
cmd.Parameters.AddWithValue(p.Key, p.Value);
}
using (con)
{
con.Open();
rtn = cmd.ExecuteNonQuery();
con.Close();
}
}
return rtn;
}

public DataSet getDataSetPassSqlDic(string mySql, Dictionary<string, object=""> myPara)
{
DataSet ds;
using (SqlConnection cn = new SqlConnection(conStr))
{
using (SqlCommand cmd = new SqlCommand(mySql, cn))
{
foreach (KeyValuePair<string, object=""> p in myPara)
{
cmd.Parameters.AddWithValue(p.Key, p.Value);
}
SqlDataAdapter da = new SqlDataAdapter(cmd);
ds = new DataSet();
using (cn)
{
cn.Open();
da.Fill(ds);
return ds;
}
}
}
}

public SqlDataReader getDrPassSql(string mySql, Dictionary<string, object=""> myPara)
{
using (SqlCommand cmd = new SqlCommand(mySql, con))
{
foreach (KeyValuePair<string, object=""> p in myPara)
{
// can put validation here to see if the value is empty or not
cmd.Parameters.AddWithValue(p.Key, p.Value);
}
con.Open();
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
return dr;
}
}

Solution 5

use SqlConnection.ClearAllpools(); method in Page_Unload event this will close all the connections

it worked out for me .

or otherwise close all connections explicitly

Posted 16-Jan-14 20:50pm

ank170989

Comments

Rohit_shrma 14-Aug-14 9:53am

SqlConnection doesnt have method ClearAllpools()

Member 11893178 13-Jun-21 15:50pm

use SqlConnection.ClearAllPools();

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Accepted Answer · 2012-07-17T23:04:00

Yes. The timeout expired. The timeout expired 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 this (plain English) message means is that your code waited for a database connection but the timeout ( which you set ) expired before it could get a connection, probably because the number of connection in the pool ( which you set ) was too low for the number of connections you were attempting, or there was a network time out, i.e. the connection between your IIS and your SQL Server was too slow to serve a connection.

pradiprenushe · Accepted Answer · 2012-07-18T00:32:00

Solution 3

Execute this query on SqlServerStudio

SELECT 
    DB_NAME(dbid) as DBName, 
    COUNT(dbid) as NumberOfConnections,
    loginame as LoginName
FROM
    sys.sysprocesses
WHERE 
    dbid > 0
GROUP BY 
    dbid, loginame

You will get the idea how many connections are open for your database.
I think you are not properly closing connections. Or may be connection is opened somewhere in loop.

Posted 18-Jul-12 0:32am

pradiprenushe

Comments

rushdi obeidat 18-Jul-12 6:42am

thx a lot i will try it.

pradiprenushe 18-Jul-12 6:43am

welcome.

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

5 solutions

Solution 1

Solution 3

Solution 4

Solution 8

Solution 5

Add your solution here

Preview 0

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

5 solutions

Solution 1

Solution 3

Solution 4

Solution 8

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us