Copied to clipboard

Flag this post as spam?

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


  • Sean Dooley 273 posts 490 karma points
    Dec 09, 2019 @ 11:18
    Sean Dooley
    0

    System.Data.SqlClient.SqlException - Cannot continue the execution because the session is in the kill state.

    We have deployed an Umbraco website onto a clients server and we are getting intermittent errors. We are confident it is the clients server as we are hosting the same website on our server without any issues.

    Below is one of the errors that we are getting.

    System.Data.SqlClient.SqlException (0x80131904): Logon failed for login '...' due to trigger execution.    
    Cannot continue the execution because the session is in the kill state.
    A severe error occurred on the current command.  The results, if any, should be discarded.
        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.SqlInternalConnection.BeginSqlTransaction(IsolationLevel iso, String transactionName, Boolean shouldReconnect)
        at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso, String transactionName)
        at System.Data.SqlClient.SqlConnection.BeginDbTransaction(IsolationLevel isolationLevel)
        at System.Data.Common.DbConnection.BeginTransaction(IsolationLevel isolationLevel)
        at StackExchange.Profiling.Data.ProfiledDbConnection.BeginDbTransaction(IsolationLevel isolationLevel) in C:\projects\dotnet\src\MiniProfiler.Shared\Data\ProfiledDbConnection.cs:line 138
        at System.Data.Common.DbConnection.BeginTransaction(IsolationLevel isolationLevel)
        at Umbraco.Core.Persistence.FaultHandling.RetryDbConnection.BeginDbTransaction(IsolationLevel isolationLevel) in d:\a\1\s\src\Umbraco.Core\Persistence\FaultHandling\RetryDbConnection.cs:line 30
        at System.Data.Common.DbConnection.BeginTransaction(IsolationLevel isolationLevel)
        at NPoco.Database.BeginTransaction(IsolationLevel isolationLevel)
        at Umbraco.Core.Scoping.Scope.get_Database() in d:\a\1\s\src\Umbraco.Core\Scoping\Scope.cs:line 244
        at Umbraco.Core.Scoping.Scope.WriteLock(Int32[] lockIds) in d:\a\1\s\src\Umbraco.Core\Scoping\Scope.cs:line 512
        at Umbraco.Core.Services.Implement.ContentService.<PerformScheduledPublishInternal>d__59.MoveNext() in d:\a\1\s\src\Umbraco.Core\Services\Implement\ContentService.cs:line 1298
        at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
        at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
        at Umbraco.Core.Services.Implement.ContentService.PerformScheduledPublish(DateTime date) in d:\a\1\s\src\Umbraco.Core\Services\Implement\ContentService.cs:line 1287
        at Umbraco.Web.Scheduling.ScheduledPublishing.PerformRun() in d:\a\1\s\src\Umbraco.Web\Scheduling\ScheduledPublishing.cs:line 72
    ClientConnectionId:f3038aae-e5e1-4c6a-b932-2165f082b05f
    Error Number:17892,State:1,Class:14
    

    Any help would be greatly appreciated.

  • Dan Evans 621 posts 993 karma points
    6 days ago
    Dan Evans
    0

    Did you ever resolve this? Getting this intermittently also -it brings the site down until app pool is recycled.

Please Sign in or register to post replies

Write your reply to:

Draft