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?
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:
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?
Correction: The other trees appears after a short while but the content tree almost never shows up any more.
Update: The tree times out after maybe 30-40 seconds.
But if I click sort the tree appears in modal boxand I can sort...?
If the SQL server is timing out then it's a problem with the SQL server.
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!
is working on a reply...