Welcome to HostingForumz.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

Error:max pool size was reached

  
   Web Hosting Problem Solving Community! (Home) -> IIS RSS
Related Topics:
Create New Application Pool => Error Service Unavailable - When i create a new pool with a new identity i get error Service the new account is only member of IIS_WPG group. It's working fine using default Service Any ideas? // Mats

Web Site Size - I'm using IIS v5.0 on a win 2000 server with multiple web sites. I would like to limit the size of a web site that a client can publish but I can't find where this is done. I would assume that it's part of the IIS for the..

Log file size above 20Meg - Anyone know of any issues with the IIS log files growing over 20Meg in one day? I could not find anything via google search on this. Thanks

apparent file size limits - We just updated from SBS 2000 to SBS 2003. Under IIS 5, we used an ASP script to send binary files to clients. Under IIS 6, the same script works for smaller files, but it will not send larger files. For example, 124K files are sent but 7MB files are not.

increase response buffer size - How I can increase the response buffer size in Internet Server 6 (windows 2003)? Thanks, Camilo Acosta
Next:  IIS: Cipher strength  
Author Message
hergass

External


Since: Dec 07, 2003
Posts: 1



(Msg. 1) Posted: Sun Dec 07, 2003 4:49 am
Post subject: Error:max pool size was reached
Archived from groups: microsoft>public>inetserver>iis (more info?)
Hi!
Since I installed the Visual Studio 2003 I got a problem:
every few hours I got an error that I can't open the
connection to the SQL Server database:

"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. "

then I must run IISRESET before I can continue.

* I must mention that : All that stuff Worked ok until I
installed the Visual Studio 2003.

Thanks For Eny Help
hergass

 >> Stay informed about: Error:max pool size was reached 
Back to top
Login to vote
user675

External


Since: Aug 28, 2003
Posts: 617



(Msg. 2) Posted: Sun Dec 07, 2003 7:25 pm
Post subject: Re: Error:max pool size was reached [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Sun, 7 Dec 2003 01:49:18 -0800, "Hergass" <hergass DeleteThis @yahoo.com>
wrote:

 >Hi!
 >Since I installed the Visual Studio 2003 I got a problem:
 >every few hours I got an error that I can't open the
 >connection to the SQL Server database:
 >
 >"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. "
 >
 >then I must run IISRESET before I can continue.
 >
 >* I must mention that : All that stuff Worked ok until I
 >installed the Visual Studio 2003.
 >
 >Thanks For Eny Help
 >hergass

Hello,

Try these articles :

<a style='text-decoration: underline;' href="http://www.maximumasp.com/maxtrack.asp?kb=432" target="_blank">http://www.maximumasp.com/maxtrack.asp?kb=432</a>

<a style='text-decoration: underline;' href="http://www.schmiddy.net/blog/2003/10/connection_pool.html" target="_blank">http://www.schmiddy.net/blog/2003/10/connection_pool.html</a>


Regards,

Paul Lynch
MCSE<!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Error:max pool size was reached 
Back to top
Login to vote
user649

External


Since: Aug 25, 2003
Posts: 244



(Msg. 3) Posted: Tue Dec 09, 2003 12:10 pm
Post subject: RE: Error:max pool size was reached [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi Hergass,

Thank you for posting in MSDN managed newsgroup!

So far as I know, this issue may be related to the internal implementation of SQL connection objects. I'd suggest the kb article 830118 may provide
some assistance for you on this issue which introduces two workarounds for us with sample codes regarding this error message. Please go to:
830118 PRB: "Timeout expired" Error Message When You Run a Visual Studio .NET
http://support.microsoft.com/?id=830118

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 >> Stay informed about: Error:max pool size was reached 
Back to top
Login to vote
qbernard

External


Since: Sep 05, 2003
Posts: 407



(Msg. 4) Posted: Tue Dec 09, 2003 9:02 pm
Post subject: Re: Error:max pool size was reached [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
KB not available, Wei-Dong.

--
Regards,
Bernard Cheah
<a style='text-decoration: underline;' href="http://support.microsoft.com/" target="_blank">http://support.microsoft.com/</a>
Please respond to newsgroups only ...



"Wei-Dong Xu [MSFT]" <v-wdxu.DeleteThis@online.microsoft.com> wrote in message
news:jRC5jRjvDHA.3972@cpmsftngxa07.phx.gbl...
 > Hi Hergass,
 >
 > Thank you for posting in MSDN managed newsgroup!
 >
 > So far as I know, this issue may be related to the internal implementation
of SQL connection objects. I'd suggest the kb article 830118 may provide
 > some assistance for you on this issue which introduces two workarounds for
us with sample codes regarding this error message. Please go to:
 > 830118 PRB: "Timeout expired" Error Message When You Run a Visual Studio
..NET
<font color=purple> > <a style='text-decoration: underline;' href="http://support.microsoft.com/?id=830118</font" target="_blank">http://support.microsoft.com/?id=830118</font</a>>
 >
 > Please feel free to let me know if you have any further questions.
 >
 > Does this answer your question? Thank you for using Microsoft NewsGroup!
 >
 > Wei-Dong Xu
 > Microsoft Product Support Services
<font color=purple> > Get Secure! - <a style='text-decoration: underline;' href="http://www.microsoft.com/security</font" target="_blank">www.microsoft.com/security</font</a>>
 > This posting is provided "AS IS" with no warranties, and confers no
rights.
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Error:max pool size was reached 
Back to top
Login to vote
user649

External


Since: Aug 25, 2003
Posts: 244



(Msg. 5) Posted: Wed Dec 10, 2003 6:32 am
Post subject: Re: Error:max pool size was reached [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi Bernard,

Thank you for your reminding!

Since this article is not available now, I have mailed one mail to Hergass concerning this.

Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 >> Stay informed about: Error:max pool size was reached 
Back to top
Login to vote
user649

External


Since: Aug 25, 2003
Posts: 244



(Msg. 6) Posted: Wed Dec 10, 2003 7:09 am
Post subject: RE: Error:max pool size was reached [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi Hergass,

Thank you for posting in MSDN managed newsgroup!

Since my mail for you has been sent back by the yahoo mail system, I will try to provide some assistance for you on this issue.

One workaround:
Change the Debug mode configuration properties of the project. Please follow these steps:
1. In Visual Studio .NET, right click your application in Solution
Explorer, and then click "Properties".
2. In a Microsoft Visual Basic.Net project, Click "Debug" under "Configuration Properties",
and then clear "SQL Server debugging" under "Enable Debuggers".
In a Microsoft Visual C# .NET project, click "Debugging" under "Configuration Properties",
and then set the value of "Enable SQL Debugging" under "Debuggers" to "False".

The second workaround:
Change the project configuration to Release mode. Plesae follow these steps:
1. In Visual Studio .NET, click "Configuration Manager" on the "Build"
menu, and then click "Release" in the "Active Solution Configuration"
list.
2. On the "Debug" menu, click "Start" to run your application. Notice
that you do not receive the error message that is mentioned in the
"Symptoms" section of this article.

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 >> Stay informed about: Error:max pool size was reached 
Back to top
Login to vote
google10

External


Since: Dec 18, 2003
Posts: 1



(Msg. 7) Posted: Thu Dec 18, 2003 5:51 am
Post subject: Re: Error:max pool size was reached [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi Wei-Dong,

I'm having a similar problem. I've developed an intranet that has
given this error message twice in a couple of months of running, once
on the live system, and once on a test system.

I've checked through the code, and am pretty sure I close all DB
connections either explicitly, or automatically after a DataBind call
(I always use CommandBehaviour.CloseConnection.) I've also used
performance monitoring to monitor the .NET CLR data counters, and this
shows the total number of pooled connections to be static at 4. I was
half-expecting to see this slowly rise - if I had a resource leak -
but it doesn't.

The second time this happened, I tried to open a SQL query window to
run sp_who, but it wouldn't open completely. In the end, I stopped the
aspnet_wp process, and everything was then OK.

I may have to automatically recycle the aspnet_wp processes
occasionally. I'm loathe to do this though, as the data stored in the
session state will be lost, and that will inconvenience the users.

The project is built in release mode, and SQL debugging is disabled.


Is this a known bug in .NET? I've seen a lot of posts about this, but
none seem to find the root cause.
 >> Stay informed about: Error:max pool size was reached 
Back to top
Login to vote
Display posts from previous:   
   Web Hosting Problem Solving Community! (Home) -> IIS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]