Copied to clipboard

Flag this post as spam?

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


  • Fredrik Esseen 594 posts 830 karma points
    Apr 07, 2010 @ 20:09
    Fredrik Esseen
    0

    Tree timing out

    Hi!

    Suddenly the tree in the backend (mostly the content tree) remains empty and after looking in the log I saw that it is timing out:

    At /umbraco/tree.aspx?rnd=b2d06b97-5204-4c56-9a46-7b65b5268fb4&id=-1&treeType=content&contextMenu=true&isDialog=false (Referred by: http://www.bktravelsolutions.se/umbraco/TreeInit.aspx?app=content): umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader ---> MySql.Data.MySqlClient.MySqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
       at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
       at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(MySqlConnection connection, MySqlTransaction transaction, String commandText, MySqlParameter[] commandParameters, Boolean ExternalConn)
       at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(String connectionString, String commandText, MySqlParameter[] commandParameters)
       at umbraco.DataLayer.SqlHelpers.MySql.MySqlHelper.ExecuteReader(String commandText, MySqlParameter[] parameters)
       at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
       --- End of inner exception stack trace ---
       at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
       at umbraco.cms.businesslogic.web.Document.GetChildrenForTree(Int32 NodeId)
       at umbraco.cms.presentation.Trees.BaseContentTree.Render(XmlTree& Tree)
       at umbraco.loadContent.Render(XmlTree& Tree)
       at umbraco.cms.presentation.tree.LoadTree(String treeAlias)
       at umbraco.cms.presentation.tree.Page_Load(Object sender, EventArgs e)
       at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
       at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
       at System.Web.UI.Control.OnLoad(EventArgs e)
       at umbraco.BasePages.BasePage.OnLoad(EventArgs e)
       at System.Web.UI.Control.LoadRecursive()
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

     Im using a shared host and My SQL. Is it absolutely clear that it is a problem of the DB or could it be something else?

  • Fredrik Esseen 594 posts 830 karma points
    Apr 07, 2010 @ 20:13
    Fredrik Esseen
    0

    Correction: The other trees appears after a short while but the content tree almost never shows up any more.

  • Fredrik Esseen 594 posts 830 karma points
    Apr 07, 2010 @ 20:32
    Fredrik Esseen
    0

    Update: The tree times out after maybe 30-40 seconds.

    But if I click sort the tree appears in modal boxand I can sort...?

  • Aaron Powell 1708 posts 3044 karma points c-trib
    Apr 08, 2010 @ 00:32
    Aaron Powell
    0

    If the SQL server is timing out then it's a problem with the SQL server.

  • Fredrik Esseen 594 posts 830 karma points
    Apr 08, 2010 @ 08:18
    Fredrik Esseen
    0

    Is understand that it sounds like a stupid question with an obvious answer :)

    I just wanted to make sure that I understood the message right.

    Thx!

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies