SCM

[#1000575] Timeout while getting a connection from pool

View Trackers | Bugs | Download .csv | Monitor

Date:
2006-03-01 00:23
Priority:
3
State:
Open
Submitted by:
Nobody
Assigned to:
Nobody (None)
Npgsql Version:
None
Category:
Group:
Resolution:
None
Summary:
Timeout while getting a connection from pool

Detailed description
Under load Npgsql returns the following error.

Error Type:System.Exception
Error Message:Timeout while getting a connection from pool.
Stack Trace: at Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection)
at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection)
at Npgsql.NpgsqlConnection.Open()
at GetAws.OrderDB.ReadSearchRememeber(String User)
at GetAws.OrderDB.SearchRemember(String User, String Url)
at GetAws.SiteAdmin.AwsOrderManager.Search_Click(Object sender, EventArgs e)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain()

Once this error occurs all subsequent requests result in the same error until the application pool is cleared of IIS is restarted.

I can connect to the postgres server and restarting postgres has no effect.

Followup

Message
Date: 2012-04-05 12:49
Sender: Jochen Wezel

I used a connection string like
SERVER=mydbserver;MINPOOLSIZE=3;MaxPoolSize=15;ConnectionLifeTime=7;DATABASE=Test DB;UID=user;PWD=pass

but it didn't worked for me using npgsql v2.0.11.92
Date: 2009-08-26 16:52
Sender: Ron Leisti

Using Npgsql for the first time, I experienced this same error. I was able to resolve this simply by specifying a minimum connection pool size in the connection string (I also happened to specify a maximum at the same time, and did not test to see if only specifying the minimum was sufficient).

ie. "DATABASE=...;POOLING=True;MINPOOLSIZE=10;MAXPOOLSIZE=20"

Attached Files:

Changes:

No Changes Have Been Made to This Item

Powered By FusionForge