Connection Pool issues

Hi Mindscape,

 do you have any troubleshooting tips for tracing the cause of this error?

"Pooling=True" is set in the connection string, which seems to be useful for improving the responsiveness of multiple concurrent queries.

Cheers,

Donovan. 

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date:  18/05/2009
Time:  15:20:33
User:  N/A
Computer: AMWEB2
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 18/05/2009 15:20:33
Event time (UTC): 18/05/2009 14:20:33
Event ID: 3fa81df96fff49f9aca614d0bd9cd79d
Event sequence: 685
Event occurrence: 28
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/2106148760/Root-1-128871273359375000
    Trust level: Full
    Application Virtual Path: /
    Application Path: d:\wwwroot\heacs\live\
    Machine name: AMWEB2
 
Process information:
    Process ID: 7540
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: InvalidOperationException
    Exception message: 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.
 
Request information:
    Request URL: https://www.heacs.co.uk:443/Login?ReturnUrl=An unhandled exception has occurred.f
    Request path: /Login
    User host address: 194.75.129.200
    User: sean.martin
    Is authenticated: True
    Authentication Type: Forms
    Thread account name: NT AUTHORITY\NETWORK SERVICE
 
Thread information:
    Thread ID: 7
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at Mindscape.LightSpeed.UnitOfWork.()
   at Mindscape.LightSpeed.UnitOfWork.PrepareCommand(IDbCommand command)
   at ...ctor(IUnitOfWork , IEnumerable`1 )
   at .
.
(IUnitOfWork , IEnumerable`1 )
   at ..(TypeModel , Query , IList )
   at .
.(Query , TypeModel , IList )
   at .
.(Query , IList )
   at Mindscape.LightSpeed.UnitOfWork.Find(Query query, IList results)
   at Mindscape.LightSpeed.UnitOfWorkBase.Find[TEntity](Query query)
 
 
Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Hi :)

This is coming from the underlying provider - which provider are you using for this? (assumption would be SQL Server). It also looks like you have impersonation on, so the connections will be held on a per user basis - so if you have as many active connections as you have users authenticated you would be running out of pool connections fairly quickly.

Have you looked at playing with the number of connections in the pool?

Lastly - are you using the PerRequestScope for your UnitOfWork?

Cheers,

Jeremy