Copied to clipboard

Flag this post as spam?

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


  • George Phillipson 108 posts 287 karma points
    Aug 03, 2019 @ 10:48
    George Phillipson
    0

    SQL timeouts since upgrading to Umbraco 8.1.1

    Anyone else experiencing SQL timeouts since upgrading to Umbraco 8.1.1.

    Error is below:

    System.Data.SqlClient.SqlException (0x80131904): Execution 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.SqlInternalConnection.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.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj, Boolean isDelegateControlRequest)
       at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest)
       at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest)
       at System.Data.SqlClient.SqlInternalTransaction.Commit()
       at System.Data.SqlClient.SqlTransaction.Commit()
       at StackExchange.Profiling.Data.ProfiledDbTransaction.Commit() in C:\projects\dotnet\src\MiniProfiler.Shared\Data\ProfiledDbTransaction.cs:line 45
       at NPoco.Database.CompleteTransaction()
       at Umbraco.Core.Scoping.Scope.DisposeLastScope() in d:\a\1\s\src\Umbraco.Core\Scoping\Scope.cs:line 390
       at Umbraco.Core.Scoping.Scope.Dispose() in d:\a\1\s\src\Umbraco.Core\Scoping\Scope.cs:line 365
       at Umbraco.Core.Services.Implement.ServerRegistrationService.TouchServer(String serverAddress, String serverIdentity, TimeSpan staleTimeout) in d:\a\1\s\src\Umbraco.Core\Services\Implement\ServerRegistrationService.cs:line 89
       at Umbraco.Web.Compose.DatabaseServerRegistrarAndMessengerComponent.TouchServerTask.PerformRun() in d:\a\1\s\src\Umbraco.Web\Compose\DatabaseServerRegistrarAndMessengerComponent.cs:line 263
    ClientConnectionId:54d0ab3e-7a67-4387-b590-51e711306288
    Error Number:-2,State:0,Class:11
    
  • William 1 post 71 karma points
    Aug 15, 2019 @ 06:50
    William
    0

    Yes, have you had any luck resolving?

  • George Phillipson 108 posts 287 karma points
    Aug 15, 2019 @ 09:23
    George Phillipson
    0

    Hi William

    Sorry no, it only happens on the upgrade, if I do a clean install it works OK.

    I also tried creating a project with Umbraco 8, then did updates 8.0.1, 8.1 etc, and I get the error, so it's not some package that I have added.

    George

  • George Phillipson 108 posts 287 karma points
    Aug 17, 2019 @ 12:40
    George Phillipson
    0

    Hi William

    I have upgraded to 8.1.2 and the problem no longer occurs

    Regards George

Please Sign in or register to post replies

Write your reply to:

Draft