Rerun the transaction.', retried 5 times before giving up -> : Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. : A transient error occured in the database: 'Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. 08:42:16,774 ERROR EPiServer.Global: 1.2.5 Unhandled exception in ASP.NET Rerun the transaction.Īt .OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)Īt .ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)Īt .TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)Īt .FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)Īt .RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)Īt .RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)Īt .InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)Īt .ExecuteNonQuery()Īt .c_Displa圜lass29_0.b_0()Īt .c_Displa圜lass30_0`1.b_0()Īt .Execute(Func`1 method)ĬlientConnectionId:b4374fbe-f419-4b50-b792-75f055576822 (0x80131904): Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. I do not know if it is connected, but we do quite a lot of checks and updates against the user´s EPiServer Profile, which contains a number of additional properties.Īny thoughts on what might be causing this behavior are greatly appreciated!ĮRROR : Failing because of transient error: Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Our default role/membership providers are WindowsMembershipProvider and WindowsRoleProvider.
We have roughly 8000 active directory groups/EPiServer roles. The stored procedure is netSynchedUserRoleUpdate. This led me to believe that there is a blocking on the calls to the table tblSynchedUserRole which contains all our active directory groups. These are not as regularly occurring as the performance issues, but I figured they might be signs of database blocks not resolving in due time. In the error log we started seeing database deadlocks. NET handles session state, however, disabling session state did not improve performance. My initial thought was that this somehow related to the way. The requests that pile up on the IIS seem to be in whichever state but mostly AuthorizeRequest and ResolveRequestCache. Most of the time the website renders just fine, but every so often, delays anywhere between two and thirty seconds are seen. The long reponse times relate to both slow initial page loads and random media on a page loading slowly. Where I work, we have an internal website running EPiServer 9.7.3.0 (originally developed for EPiServer 7) that has been experiencing performance issues even with a low number of simultaneous users.
First of all, I would like to apologize for the amount of text below :)
0 kommentar(er)
