Copied to clipboard

Flag this post as spam?

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


  • bh 252 posts 889 karma points
    Mar 13, 2019 @ 17:27
    bh
    0

    SQL Timeout Back Office v8

    I just picked up v8 this week and I've started a new project. At the same time I'm starting a new development environment going from an on-site SQL Server to SQL running on an Azure Server. A couple of times per day I'm getting SQL timeouts. I might get the error when I save a Template or a DocType. After I get the error I'll repeat the task and it'll typically succeed on the subsequent attempt. I can't tell if it's Umbraco v8 causing the timeout or if it's my connectivity between my dev environment and the Azure Server.

    Anyone else seeing SQL timeouts in v8?

  • Alex Skrypnyk 5733 posts 21696 karma points MVP 4x admin c-trib
    Mar 13, 2019 @ 19:58
    Alex Skrypnyk
    1

    Hi

    I used v8 for 1 day and had no timeouts at all.

    Thanks,

    Alex

  • Alex Skrypnyk 5733 posts 21696 karma points MVP 4x admin c-trib
    Apr 01, 2019 @ 22:30
    Alex Skrypnyk
    0

    Hi

    Do you still have this problem? Can you share with our community?

  • bh 252 posts 889 karma points
    Apr 02, 2019 @ 11:59
    bh
    100

    Ended up being a networking issue, that still isn't resolved. We've got Cisco and Azure support both working on it. Thanks for following up Alex!

  • Alex Skrypnyk 5733 posts 21696 karma points MVP 4x admin c-trib
    Apr 02, 2019 @ 13:42
    Alex Skrypnyk
    0

    You are welcome, nice that it's not an Umbraco issue.

  • Tito 268 posts 459 karma points
    Feb 27, 2020 @ 16:32
    Tito
    0

    Its happening to me using Umbraco 8.5.3 and local database SQL Server Express, i have disabled models builder and in the connection string set a connect timeout=120. This is the error: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

    Stacktrace:

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

    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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.TrySetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo) 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, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 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 System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in C:\projects\dotnet\src\MiniProfiler.Shared\Data\ProfiledDbCommand.cs:line 208 at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.<>cDisplayClass300.0() at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.<>cDisplayClass3301.<Execute>b__0() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.Execute[T](Func1 f) at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() at NPoco.Database.ExecuteReaderHelper(DbCommand cmd) at NPoco.Database.ExecuteDataReader(DbCommand cmd) at NPoco.Database.<QueryImp>d__1641.MoveNext() at System.Linq.Enumerable.WhereSelectEnumerableIterator2.MoveNext() at Umbraco.Web.PublishedCache.NuCache.ContentStore.SetAll(IEnumerable1 kits) at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.LoadContentFromDatabaseLocked(IScope scope, Boolean onStartup) at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.NotifyLocked(IEnumerable1 payloads, Boolean& draftChanged, Boolean& publishedChanged) at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.Notify(JsonPayload[] payloads) at Umbraco.Web.Cache.ContentTypeCacheRefresher.<>c__DisplayClass12_0.<Refresh>b__6() at Umbraco.Core.PublishedModelFactoryExtensions.WithSafeLiveFactoryReset(IPublishedModelFactory factory, Action action) at Umbraco.Web.Cache.ContentTypeCacheRefresher.Refresh(JsonPayload[] payloads) at Umbraco.Core.Sync.ServerMessengerBase.DeliverLocal[TPayload](ICacheRefresher refresher, TPayload[] payload) at Umbraco.Core.Sync.ServerMessengerBase.Deliver[TPayload](ICacheRefresher refresher, TPayload[] payload) at Umbraco.Core.Sync.ServerMessengerBase.PerformRefresh[TPayload](ICacheRefresher refresher, TPayload[] payload) at Umbraco.Web.Cache.DistributedCache.RefreshByPayload[TPayload](Guid refresherGuid, IEnumerable1 payloads) at Umbraco.Web.Cache.DistributedCacheExtensions.RefreshContentTypeCache(DistributedCache dc, ContentTypeChange1[] changes) at Umbraco.Web.Cache.DistributedCacheBinder.ContentTypeService_Changed(IContentTypeService sender, EventArgs args) at Umbraco.Core.Events.EventDefinition2.RaiseEvent() at Umbraco.Core.Events.QueuingEventDispatcher.ScopeExitCompleted() at Umbraco.Core.Events.QueuingEventDispatcherBase.ScopeExit(Boolean completed) at Umbraco.Core.Scoping.Scope.<>cDisplayClass710._15.MoveNext()

Please Sign in or register to post replies

Write your reply to:

Draft