In 6.0 we used to have an issue were our Connection Pool fills up occasionally. Looks like its happening again in 6.1.
ErrorType: Primary| ErrorCount: 3| App: NPD| SessionId: 7163a4b4-35bb-8916-63d7-db9b54d5b827| UserId: stewartmo| IsNewSession: False| ServerID: 10.31.11.21| Misc: |
Exception: System.Web.HttpException: Error executing child request for /npd/Activity/ActivityEditorPopup.aspx. ---> System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> Xeno.Data.ConnectionPoolEmptyException: No more connections can be created. They are all being used.
We can check it using : http://pdm2.tyson.com/npd/WebCommon/AdminForms/ConnectionPoolInfo.aspx
The fix is to reset IIS.
Our config is:
<config key="MAX" value="100" configOverrideModifier="IsLocked"/>
<config key="CONNECT_STRING" value="@@VAR:Prodika.DB.URL@@" configAttributeOverrideBehavior="Replace" configOverrideModifier="IsLocked"/>
<config key="CONNECT_STRING" value="@@VAR:Prodika.ReportingDB.URL@@" />
Do we need to set MAX" value="100" higher?
Edited by: Trey on Oct 9, 2012 11:27 AM
I suggest you file an SR with support, as we have not experienced this issue. In fact, I just double checked a few of our environments, and the connections are set to 8.
Please include as much information as you can, including:
- typical user click streams
- info on validations, guard conditions, custom code *
- if above exists, is it reproducible on a vanilla install with no customization?
- is this limited to the ActiviyEditorPopup.aspx page?
* Trey, if i recall, I thought this is where the problem lied in 6.0. a custom validation or guard condition was improperly firing off new connections.
I looked thru all the error event logs that got thrown yesterday when this started, and its mostly off Error executing child request for /npd/MainPage/NPD.aspx. & Error executing child request for /npd/Activity/ActivityEditorPopup.aspx
Does this have something to do with the fact that we have to deploy our custom DLLs to the npd/bin even though we have no validations or guards for NPD?
We have no NPD validators. We have other customizations that do not explicitly create any database connections. They access the data objects so any database connections are opened by framework. We also are placing GSM validation and guard condition assemblies in the npd/bin folder because the app expects them there even though they are not directly used.
The Validation framework loads up all validation factories, regardless of where they are used.
If none of your validation factories (not the validator classes, but the factories that create them) are loading up data, even if they aren't being used in NPD, then that should be fine. Log an SR with support like Matt suggested.
Ive asked support to add us to this SR as well.
While the IIS reset fixes the issue, ours happens in Production. Not good.
Since this started happening to us in Production 3 times in 4 days, we have had to set the NPD App Pool to recycle at 5AM everyday.
Edited by: Trey on Oct 18, 2012 7:38 AM