473,324 Members | 2,581 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Error when load testing web application: all pooled connections were in use or max pool size was reached

I have a web application (ASP.Net V2) that fetches stuff from the database.
I've created a test project in Visual Studio 2005.
In the webtest I fetch data from some webservices that query the database.
It responds in 0.02 to 0,10 seconds for the queries in the webtest (5
queries).
When I loadtest the webtest with 1 user and no wait time I get about 40
responses, then I get the error:
--------
System.InvalidOperationException: 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.GetCo nnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
....
-----------

In my dataaccess I use "using" on the connection everywhere I can (whenever
I don't return a datareader)
When I return a datareader I use CommandBehavior.CloseConnection
And every place I fetch a datareader I use "using" on the datareader.

So why do I get the error above? Is it because the connections can't be
reused as fast as I am using them? Or must it be because I'm not closing my
connections properly (I've checked everything twice, I'll check again).

Kind Regards,
Allan Ebdrup
May 14 '07 #1
1 1458
I just re-compiled my dll's and updated references again and the problem
dissappeared.
May 14 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Silvia | last post by:
I have a application web and when execute this for a long time generated this error: Server Error in '/RAIMServer' Application. -----------------------------------------------------------...
2
by: Brian | last post by:
Hello, I'm having a recurring error whenever I try to debug a asp.net web page is retrieving data from a SQL server. The error msg is: "Timeout expired. The timeout period elapsed prior to...
4
by: Guoqi Zheng | last post by:
Dear sir, I keep getting the following errors on one of my sites after clicking for many times. Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This...
4
by: Nevyn Twyll | last post by:
I've been working on an asp.net application and everything's been great. But suddenly, whether I'm tyring to use a database on my own machine, or on my server, I'm getting a timeout when trying to...
3
by: DougS | last post by:
We have an ASP.Net (framework 1.1) app that does a lot of database reads and updates. The app has a dozen pages and we're about 90% done and all of a sudden I'm getting this error: Timeout...
3
by: RTT | last post by:
I keep receiving an SQL error. Not everytime but frequently. Does anyone know what to problem could be? This is the error i recieve: Timeout expired. The timeout period elapsed prior to obtaining...
3
by: serge calderara | last post by:
Dear all, I have an asp.net 1.1 application which collect data from an sql server database So far it was working fine and suddenly I get the following error : "Timeout expired. The timeout...
2
by: NEWS | last post by:
Hi Could anyone pls guide . I am getting this error : Thankx in anticipation Server Error in '/webpdms' Application....
1
by: ramneekm | last post by:
hi all, i am working on a asp.net web app and using ado.net 's SqlClient Data Provider to connect to sqlserver 2005. I am getting the exception "Timeout expired. The timeout period elapsed...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.