Database Connection Pooling Error

5 posts, 0 answers
  1. Shurland
    Shurland avatar
    9 posts
    Member since:
    Aug 2012

    Posted 09 Aug 2012 Link to this post

    I get the following error when browsing the application:

    The connection pool has reached it's maxActive setting and a new database connection could not be opened...

    Here's how my configuration is set:

        backend.Backend = "mssql"
                backend.ProviderName = "System.Data.SqlClient"
                backend.Logging.MetricStoreSnapshotInterval = 0
                backend.ConnectionPool.BlockWhenFull = False
                backend.Runtime.MediumTrust = True
                backend.Runtime.SupportConcurrentThreadsInScope = True
                backend.Runtime.UseUTCForAutoSetValues = True

    Am i doing this correctly, and how can I resolve this issue? The application in question is live as we speak and the client is a very high valued client (T-mobile). I don't think they pick up on this issue yet but I don't want this issue to get me in a big mess. Can someone please help me figure this out? 

    Thanks in advanced
  2. Ady
    Admin
    Ady avatar
    589 posts

    Posted 10 Aug 2012 Link to this post

    Hello Shurland,

     I noticed that you have set the 'BackendConfiguration.ConnectionPool.BlockWhenFull' property to 'false'. This setting controls the behavior of the connection pool when threads attempt to obtain a connection and there is none available. If set to 'true' (default value) the thread will wait, until one is available. If it is set to False, an exception will be thrown. Do you really want this behavior?
    In yes, you should consider increasing the 'ConnectionPool.MaxAxtive' value to an appropriate value but keep in mind that if this new max limit is reached then an exception will be thrown again.

    Regards,
    Ady
    the Telerik team
    OpenAccess ORM Q2'12 Now Available! Get your hands on all the new stuff.
  3. DevCraft banner
  4. Shurland
    Shurland avatar
    9 posts
    Member since:
    Aug 2012

    Posted 11 Aug 2012 Link to this post

    Thanks. I'll try doing that. I have another issue that keeps coming up in my application log, if you can shed some light on this, i'll greatly appreciate it. I don't know how critical it is, but here it goes...

    System.Exception: Telerik.OpenAccess.OpenAccessException: This InitState method should not be called. at OpenAccessRuntime.ExceptionWrapper.Throw() at OpenAccessRuntime.DataObjects.PCStateMan.handleException(Exception x) at OpenAccessRuntime.DataObjects.PCStateMan.GetField[T](PersistenceCapable pc, Int32 field, T currentValue) at OpenAccessRuntime.DataObjects.SynchronizedStateManagerProxy.GetField[T](PersistenceCapable pc, Int32 field, T currentValue) at Tmobile.DAL.Core.Invitee.OpenAccessEnhancedGet_UserId(Invitee ) at Tmobile.DAL.Core.Invitee.get_UserId() at Tmobile.BLL.Core.Services.InviteeContext.GetInvitee(String userId) at Tmobile.BLL.Core.Extensions.UserExtensions.Invitee(User entity) at Tmobile.Web.Page.RegistrationPage.get_InviteeId() in E:\HostingSpaces\didwebs\challenger2012.com\wwwroot\challenger\register.aspx.vb:line 203 at Tmobile.Web.Page.RegistrationPage.get_ThisInvitee() in E:\HostingSpaces\didwebs\challenger2012.com\wwwroot\challenger\register.aspx.vb:line 52 at Tmobile.Web.Page.RegistrationPage.SaveInviteeDetails() in E:\HostingSpaces\didwebs\challenger2012.com\wwwroot\challenger\register.aspx.vb:line 214

    What is causing this exception, and is it related to the other issue? Please do share.

    Thanks,
  5. Ady
    Admin
    Ady avatar
    589 posts

    Posted 16 Aug 2012 Link to this post

    Hello Shurland,

     This seems to be a completely unrelated problem. Can you open another ticket for this issue and provide some more details as to when you get this exception, the calling code, the persistent model etc.?
    A sample project that can reproduce this exception would help in resolving the problem sooner.

    All the best,
    Ady
    the Telerik team
    Follow @OpenAccessORM Twitter channel to be the first one to get the latest updates on new releases, tips and tricks and sneak peeks at our product labs!
  6. Shurland
    Shurland avatar
    9 posts
    Member since:
    Aug 2012

    Posted 19 Aug 2012 Link to this post

    Thanks!
Back to Top
DevCraft banner