Copied to clipboard

Flag this post as spam?

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


  • mwilkowski 4 posts 24 karma points
    Oct 13, 2014 @ 13:36
    mwilkowski
    0

    Content Tree Timeout

    Hello,

    I am using Umbraco 6.1.6, MS SQL 2008 and receive command timeout while expanding the content tree. Could you please re-compile and make available the dll with command timeout set to, let's say', 3600 seconds :-)?

    Anticipating the question: yes, I have LOTS of nodes in my installation (around 10,000 - 15,000).

    Here is the stack trace:

    2014-10-13 18:42:25,843 [7] INFO  Umbraco.Core.Persistence.UmbracoDatabase - [Thread 26]    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

       at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

       at System.Data.SqlClient.SqlDataReader.get_MetaData()

       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

       at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior)

       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()

       at Umbraco.Core.Persistence.Database.<Query>d__7`1.MoveNext()

    2014-10-13 18:42:25,843 [7] ERROR Umbraco.Core.UmbracoApplicationBase - [Thread 26] An unhandled exception occurred

    System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

       at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

       at System.Data.SqlClient.SqlDataReader.get_MetaData()

       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

       at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior)

       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()

       at Umbraco.Core.Persistence.Database.<Query>d__7`1.MoveNext()

       at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)

       at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

       at Umbraco.Core.Persistence.Repositories.EntityRepository.GetByQuery(IQuery`1 query, Guid objectTypeId)

       at Umbraco.Core.Services.EntityService.GetChildren(Int32 parentId, UmbracoObjectTypes umbracoObjectType)

       at umbraco.cms.presentation.Trees.BaseContentTree.Render(XmlTree& Tree)

       at umbraco.loadContent.Render(XmlTree& tree)

       at umbraco.presentation.webservices.TreeDataService.ProcessRequest(HttpContext context)

       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

    ClientConnectionId:4e6e9e6e-7484-4b21-9555-70ad20a6ef8d

    2014-10-13 18:42:30,336 [7] DEBUG Umbraco.Web.UmbracoModule - [Thread 26] Begin request: http://54.254.190.136/umbraco/webservices/legacyAjaxCalls.asmx/GetSecondsBeforeUserLogout.

  • Giovanni Sidoel 94 posts 233 karma points
    Feb 17, 2016 @ 13:34
    Giovanni Sidoel
    0

    mwilkowski Have you ever gotten around to solving this? I'm having this issue with the media tree.

  • Max Konyukh 6 posts 76 karma points
    Aug 16, 2017 @ 12:54
    Max Konyukh
    0

    Have your overcome this? Have the problem with media tree also.

    Thanks!

  • Nisreen Al-Masri 12 posts 91 karma points
    Aug 17, 2017 @ 12:06
    Nisreen Al-Masri
    0

    did you solve it, I have the same error:(

  • Nisreen Al-Masri 12 posts 91 karma points
    Aug 17, 2017 @ 12:07
    Nisreen Al-Masri
    0

    did you solve it, I have the same error:(

  • mwilkowski 4 posts 24 karma points
    Aug 16, 2017 @ 20:57
    mwilkowski
    0

    I do not remember - I think I recompiled the Umbraco with a longer timeout :). But please do not ask how I did - it was long time ago :).

  • Juan Neisa 1 post 72 karma points
    Aug 24, 2018 @ 16:49
    Juan Neisa
    1

    Hi guys, I have the same error in Umbraco 7.2, my solution was set a longer tiomeout OnApplicationStarting

      public class UmbracoEvents : IApplicationEventHandler
    {
        public void OnApplicationInitialized(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext)
        {
    
        }
    
        public void OnApplicationStarting(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext)
        {
            ApplicationContext.Current.DatabaseContext.Database.CommandTimeout = 6000;
        }} 
    

    May it help you.

Please Sign in or register to post replies

Write your reply to:

Draft