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 610 posts 906 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 610 posts 906 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 610 posts 906 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 3046 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 610 posts 906 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!

Please Sign in or register to post replies

Write your reply to:

Draft