Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Gleb Kaplan 49 posts 125 karma points
    Apr 22, 2013 @ 12:55
    Gleb Kaplan
    0

    Automatic re-connection to database after DB is back again?

    Hi

    We experience the following issues with our Umbraco installation (4.11.6, MySQL)

    If for any reason the DB goes down, Umbraco does not restore the connection automatically fter the DB is up again.

    The repeated message in the log is:

    MySql.Data.MySqlClient.MySqlException (0x80004005): error connecting: 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.

    (the increasing of pool size in the connection string does not help)

    Please advise.

    Copy Link
  • Rich Green 2246 posts 4008 karma points
    Apr 22, 2013 @ 13:19
    Rich Green
    0

    Hey Gleb,

    Wouldn't this be a .NET issue (connection pooling), rather than an Umbraco one?

    Rich

    Copy Link
  • Gleb Kaplan 49 posts 125 karma points
    Apr 22, 2013 @ 13:25
    Gleb Kaplan
    0

    You can have a look at the article

    http://blogs.msdn.com/b/angelsb/archive/2004/08/25/220333.aspx 

    It describes typical scenario of leaked connections, causing such error.

    The scenario is: the application opens a new connection, tries to execute some query and then closes the connection, but if the query fails, then the connection is not closed.

    so this is a specific application problem not the .NET one.

     

     

     

     

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft