cmscontentversion deadlock

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

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

Tajamal 87 posts 175 karma points

Sep 17, 2020 @ 09:11

Umbraco version 7.5.11 assembly: 1.0.6274.27352

Im getting deadlocks with above umbraco version.

Can anyone shed light on why i am getting these deadlocks ?

I am using umbraco members as webuser profiles!!!

These are the errors from umbraco and graph trace.

   2020-09-17 09:25:02,431 [P6728/D2/T18] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Database exception occurred
System.Data.SqlClient.SqlException (0x80131904): Transaction (Process ID 140) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
   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.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at Umbraco.Core.Persistence.Database.<Query>d__1c`1.MoveNext()
ClientConnectionId:86ec5b1a-938c-40bc-892b-1a39fe27a032
Error Number:1205,State:51,Class:13

Grapgh trace log

<?xml version="1.0" encoding="utf-16"?>
<TraceData xmlns="http://tempuri.org/TracePersistence.xsd">
  <Header>
    <TraceProvider name="Microsoft SQL Server" MajorVersion="13" MinorVersion="0" BuildNumber="4422" />
    <ServerInformation name="SQLSRV" />
    <ProfilerUI>
      <OrderedColumns>
        <ID>27</ID>
        <ID>51</ID>
        <ID>60</ID>
        <ID>11</ID>
        <ID>41</ID>
        <ID>12</ID>
        <ID>26</ID>
        <ID>64</ID>
        <ID>14</ID>
        <ID>1</ID>
        <ID>4</ID>
      </OrderedColumns>
      <TracedEvents>
        <Event id="148">
          <EventColumn id="1" />
          <EventColumn id="41" />
          <EventColumn id="4" />
          <EventColumn id="12" />
          <EventColumn id="11" />
          <EventColumn id="51" />
          <EventColumn id="14" />
          <EventColumn id="26" />
          <EventColumn id="60" />
          <EventColumn id="64" />
        </Event>
      </TracedEvents>
    </ProfilerUI>
  </Header>
  <Events>
    <Event id="65534" name="Trace Start">
      <Column id="14" name="StartTime">2020-09-17T10:16:36.723+02:00</Column>
    </Event>
    <Event id="148" name="Deadlock graph">
      <Column id="1" name="TextData">&lt;deadlock-list&gt;
 &lt;deadlock victim="process1eef9f548c8"&gt;
  &lt;process-list&gt;
   &lt;process id="process1eef9f548c8" taskpriority="0" logused="0" waitresource="KEY: 5:72057594262650880 (d4552b838821)" waittime="4167" ownerId="493609787" transactionname="SELECT" lasttranstarted="2020-09-17T10:16:48.267" XDES="0x1e541f3ba40" lockMode="S" schedulerid="3" kpid="1676" status="suspended" spid="67" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2020-09-17T10:16:48.267" lastbatchcompleted="2020-09-17T10:16:48.263" lastattention="1900-01-01T00:00:00.263" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="493609787" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="174" stmtend="3584" sqlhandle="0x020000007d7b2a2ea5f891f667a4693b50cd0cface76b0390000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 nvarchar(40),@1 nvarchar(40),@2 nvarchar(4000),@3 nvarchar(4000),@4 nvarchar(4000))SELECT a.id, a.value, a.sortorder, a.alias, a.datatypeNodeId
FROM cmsDataTypePreValues a
WHERE EXISTS(
    SELECT DISTINCT b.id as preValIdInner
    FROM cmsDataTypePreValues b
    INNER JOIN cmsPropertyType
    ON b.datatypeNodeId = cmsPropertyType.dataTypeId
    INNER JOIN 
        (SELECT cmsContent.contentType FROM [cmsMember]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [cmsMember].[nodeId]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE (([umbracoNode].[nodeObjectType] = @0))
AND umbracoNode.id IN (SELECT DISTINCT(umbracoNode.id)
FROM [umbracoNode]
INNER JOIN [cmsContent]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]    &lt;/inputbuf&gt;
   &lt;/process&gt;
   &lt;process id="process1dfa92df088" taskpriority="0" logused="252" waitresource="OBJECT: 5:1621580815:0 " waittime="4791" ownerId="493609942" transactionname="user_transaction" lasttranstarted="2020-09-17T10:16:48.517" XDES="0x1e9107458a8" lockMode="IX" schedulerid="8" kpid="8668" status="suspended" spid="61" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2020-09-17T10:16:48.523" lastbatchcompleted="2020-09-17T10:16:48.523" lastattention="1900-01-01T00:00:00.523" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="493609942" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="256" stmtend="650" sqlhandle="0x02000000705b8924d8731bb71e7579e2fedd3f71962d61be0000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 int,@1 nvarchar(40),@2 int,@3 nvarchar(4000),@4 nvarchar(4000),@5 nvarchar(4000),@6 nvarchar(4000),@7 nvarchar(4000),@8 int)UPDATE [cmsPropertyData] SET [contentNodeId] = @0, [versionId] = @1, [propertytypeid] = @2, [dataInt] = @3, [dataDecimal] = @4, [dataDate] = @5, [dataNvarchar] = @6, [dataNtext] = @7 WHERE [id] = @8    &lt;/inputbuf&gt;
   &lt;/process&gt;
  &lt;/process-list&gt;
  &lt;resource-list&gt;
   &lt;keylock hobtid="72057594262650880" dbid="5" objectname="Umbraco_Prod.dbo.cmsContentVersion" indexname="PK_cmsContentVersion" id="lock1ecd49c8080" mode="X" associatedObjectId="72057594262650880"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1dfa92df088" mode="X"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1eef9f548c8" mode="S" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/keylock&gt;
   &lt;objectlock lockPartition="0" objid="1621580815" subresource="FULL" dbid="5" objectname="Umbraco_Prod.dbo.cmsPropertyData" id="lock1f0e97ddc80" mode="S" associatedObjectId="1621580815"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1eef9f548c8" mode="S"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1dfa92df088" mode="IX" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/objectlock&gt;
  &lt;/resource-list&gt;
 &lt;/deadlock&gt;
&lt;/deadlock-list&gt;
</Column>
      <Column id="41" name="LoginSid">01</Column>
      <Column id="11" name="LoginName">sa</Column>
      <Column id="51" name="EventSequence">108026</Column>
      <Column id="12" name="SPID">23</Column>
      <Column id="60" name="IsSystem">1</Column>
      <Column id="14" name="StartTime">2020-09-17T10:16:53.313+02:00</Column>
      <Column id="26" name="ServerName">SQLSRV</Column>
    </Event>
    <Event id="148" name="Deadlock graph">
      <Column id="1" name="TextData">&lt;deadlock-list&gt;
 &lt;deadlock victim="process1e9b0bbc108"&gt;
  &lt;process-list&gt;
   &lt;process id="process1e9b0bbc108" taskpriority="0" logused="0" waitresource="KEY: 5:72057594262650880 (0f9a68e1ef5f)" waittime="2668" ownerId="493612076" transactionname="SELECT" lasttranstarted="2020-09-17T10:16:54.493" XDES="0x1e9e041ba40" lockMode="S" schedulerid="8" kpid="11996" status="suspended" spid="91" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2020-09-17T10:16:54.493" lastbatchcompleted="2020-09-17T10:16:54.493" lastattention="1900-01-01T00:00:00.493" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="493612076" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="174" stmtend="2852" sqlhandle="0x020000001094961a7d623cd7add5b1ade32ccc6a9a48d1790000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 nvarchar(40),@1 nvarchar(40),@2 nvarchar(4000),@3 nvarchar(4000),@4 nvarchar(4000))SELECT *
FROM [cmsMember]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [cmsMember].[nodeId]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE (([umbracoNode].[nodeObjectType] = @0))
AND umbracoNode.id IN (SELECT DISTINCT(umbracoNode.id)
FROM [umbracoNode]
INNER JOIN [cmsContent]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [umbracoNode].[id]
INNER JOIN [cmsMember]
ON [cmsMember].[nodeId] = [cmsContent].[nodeId]
LEFT JOIN [cmsPropertyType]
ON [cmsPropertyType].[contentTypeId] = [cmsContent].[contentType]
LEFT JOIN [cmsDataType]
ON [cmsDataType].[nodeId] = [    &lt;/inputbuf&gt;
   &lt;/process&gt;
   &lt;process id="process1f41a891848" taskpriority="0" logused="0" waitresource="KEY: 5:72057594262650880 (0f9a68e1ef5f)" waittime="3914" ownerId="493611806" transactionname="SELECT" lasttranstarted="2020-09-17T10:16:53.167" XDES="0x1e7758c3a40" lockMode="S" schedulerid="2" kpid="11540" status="suspended" spid="71" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2020-09-17T10:16:53.167" lastbatchcompleted="2020-09-17T10:16:53.163" lastattention="1900-01-01T00:00:00.163" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="493611806" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="174" stmtend="2852" sqlhandle="0x020000001094961a7d623cd7add5b1ade32ccc6a9a48d1790000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 nvarchar(40),@1 nvarchar(40),@2 nvarchar(4000),@3 nvarchar(4000),@4 nvarchar(4000))SELECT *
FROM [cmsMember]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [cmsMember].[nodeId]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE (([umbracoNode].[nodeObjectType] = @0))
AND umbracoNode.id IN (SELECT DISTINCT(umbracoNode.id)
FROM [umbracoNode]
INNER JOIN [cmsContent]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [umbracoNode].[id]
INNER JOIN [cmsMember]
ON [cmsMember].[nodeId] = [cmsContent].[nodeId]
LEFT JOIN [cmsPropertyType]
ON [cmsPropertyType].[contentTypeId] = [cmsContent].[contentType]
LEFT JOIN [cmsDataType]
ON [cmsDataType].[nodeId] = [    &lt;/inputbuf&gt;
   &lt;/process&gt;
   &lt;process id="process1dfa92df088" taskpriority="0" logused="252" waitresource="OBJECT: 5:1621580815:0 " waittime="4889" ownerId="493611922" transactionname="user_transaction" lasttranstarted="2020-09-17T10:16:53.420" XDES="0x1e9194037b8" lockMode="IX" schedulerid="8" kpid="8668" status="suspended" spid="61" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2020-09-17T10:16:53.427" lastbatchcompleted="2020-09-17T10:16:53.423" lastattention="1900-01-01T00:00:00.423" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="493611922" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="256" stmtend="650" sqlhandle="0x02000000705b8924d8731bb71e7579e2fedd3f71962d61be0000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 int,@1 nvarchar(40),@2 int,@3 nvarchar(4000),@4 nvarchar(4000),@5 nvarchar(4000),@6 nvarchar(4000),@7 nvarchar(4000),@8 int)UPDATE [cmsPropertyData] SET [contentNodeId] = @0, [versionId] = @1, [propertytypeid] = @2, [dataInt] = @3, [dataDecimal] = @4, [dataDate] = @5, [dataNvarchar] = @6, [dataNtext] = @7 WHERE [id] = @8    &lt;/inputbuf&gt;
   &lt;/process&gt;
  &lt;/process-list&gt;
  &lt;resource-list&gt;
   &lt;keylock hobtid="72057594262650880" dbid="5" objectname="Umbraco_Prod.dbo.cmsContentVersion" indexname="PK_cmsContentVersion" id="lock1ec989fce00" mode="X" associatedObjectId="72057594262650880"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1f41a891848" mode="S" requestType="wait"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1e9b0bbc108" mode="S" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/keylock&gt;
   &lt;keylock hobtid="72057594262650880" dbid="5" objectname="Umbraco_Prod.dbo.cmsContentVersion" indexname="PK_cmsContentVersion" id="lock1ec989fce00" mode="X" associatedObjectId="72057594262650880"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1dfa92df088" mode="X"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1f41a891848" mode="S" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/keylock&gt;
   &lt;objectlock lockPartition="0" objid="1621580815" subresource="FULL" dbid="5" objectname="Umbraco_Prod.dbo.cmsPropertyData" id="lock1f0e97ddc80" mode="S" associatedObjectId="1621580815"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1f41a891848" mode="S"/&gt;
     &lt;owner id="process1e9b0bbc108" mode="S"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1dfa92df088" mode="IX" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/objectlock&gt;
  &lt;/resource-list&gt;
 &lt;/deadlock&gt;
&lt;/deadlock-list&gt;
</Column>
      <Column id="41" name="LoginSid">01</Column>
      <Column id="11" name="LoginName">sa</Column>
      <Column id="51" name="EventSequence">108029</Column>
      <Column id="12" name="SPID">28</Column>
      <Column id="60" name="IsSystem">1</Column>
      <Column id="14" name="StartTime">2020-09-17T10:16:58.317+02:00</Column>
      <Column id="26" name="ServerName">SQLSRV</Column>
    </Event>
    <Event id="148" name="Deadlock graph">
      <Column id="1" name="TextData">&lt;deadlock-list&gt;
 &lt;deadlock victim="process1f41a891848"&gt;
  &lt;process-list&gt;
   &lt;process id="process1e9b0bbc108" taskpriority="0" logused="0" waitresource="KEY: 5:72057594262650880 (0f9a68e1ef5f)" waittime="2669" ownerId="493612076" transactionname="SELECT" lasttranstarted="2020-09-17T10:16:54.493" XDES="0x1e9e041ba40" lockMode="S" schedulerid="8" kpid="11996" status="suspended" spid="91" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2020-09-17T10:16:54.493" lastbatchcompleted="2020-09-17T10:16:54.493" lastattention="1900-01-01T00:00:00.493" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="493612076" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="174" stmtend="2852" sqlhandle="0x020000001094961a7d623cd7add5b1ade32ccc6a9a48d1790000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 nvarchar(40),@1 nvarchar(40),@2 nvarchar(4000),@3 nvarchar(4000),@4 nvarchar(4000))SELECT *
FROM [cmsMember]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [cmsMember].[nodeId]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE (([umbracoNode].[nodeObjectType] = @0))
AND umbracoNode.id IN (SELECT DISTINCT(umbracoNode.id)
FROM [umbracoNode]
INNER JOIN [cmsContent]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [umbracoNode].[id]
INNER JOIN [cmsMember]
ON [cmsMember].[nodeId] = [cmsContent].[nodeId]
LEFT JOIN [cmsPropertyType]
ON [cmsPropertyType].[contentTypeId] = [cmsContent].[contentType]
LEFT JOIN [cmsDataType]
ON [cmsDataType].[nodeId] = [    &lt;/inputbuf&gt;
   &lt;/process&gt;
   &lt;process id="process1f41a891848" taskpriority="0" logused="0" waitresource="KEY: 5:72057594262650880 (0f9a68e1ef5f)" waittime="3914" ownerId="493611806" transactionname="SELECT" lasttranstarted="2020-09-17T10:16:53.167" XDES="0x1e7758c3a40" lockMode="S" schedulerid="2" kpid="11540" status="suspended" spid="71" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2020-09-17T10:16:53.167" lastbatchcompleted="2020-09-17T10:16:53.163" lastattention="1900-01-01T00:00:00.163" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="493611806" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="174" stmtend="2852" sqlhandle="0x020000001094961a7d623cd7add5b1ade32ccc6a9a48d1790000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 nvarchar(40),@1 nvarchar(40),@2 nvarchar(4000),@3 nvarchar(4000),@4 nvarchar(4000))SELECT *
FROM [cmsMember]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [cmsMember].[nodeId]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE (([umbracoNode].[nodeObjectType] = @0))
AND umbracoNode.id IN (SELECT DISTINCT(umbracoNode.id)
FROM [umbracoNode]
INNER JOIN [cmsContent]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [umbracoNode].[id]
INNER JOIN [cmsMember]
ON [cmsMember].[nodeId] = [cmsContent].[nodeId]
LEFT JOIN [cmsPropertyType]
ON [cmsPropertyType].[contentTypeId] = [cmsContent].[contentType]
LEFT JOIN [cmsDataType]
ON [cmsDataType].[nodeId] = [    &lt;/inputbuf&gt;
   &lt;/process&gt;
   &lt;process id="process1dfa92df088" taskpriority="0" logused="252" waitresource="OBJECT: 5:1621580815:0 " waittime="4889" ownerId="493611922" transactionname="user_transaction" lasttranstarted="2020-09-17T10:16:53.420" XDES="0x1e9194037b8" lockMode="IX" schedulerid="8" kpid="8668" status="suspended" spid="61" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2020-09-17T10:16:53.427" lastbatchcompleted="2020-09-17T10:16:53.423" lastattention="1900-01-01T00:00:00.423" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="493611922" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="256" stmtend="650" sqlhandle="0x02000000705b8924d8731bb71e7579e2fedd3f71962d61be0000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 int,@1 nvarchar(40),@2 int,@3 nvarchar(4000),@4 nvarchar(4000),@5 nvarchar(4000),@6 nvarchar(4000),@7 nvarchar(4000),@8 int)UPDATE [cmsPropertyData] SET [contentNodeId] = @0, [versionId] = @1, [propertytypeid] = @2, [dataInt] = @3, [dataDecimal] = @4, [dataDate] = @5, [dataNvarchar] = @6, [dataNtext] = @7 WHERE [id] = @8    &lt;/inputbuf&gt;
   &lt;/process&gt;
  &lt;/process-list&gt;
  &lt;resource-list&gt;
   &lt;keylock hobtid="72057594262650880" dbid="5" objectname="Umbraco_Prod.dbo.cmsContentVersion" indexname="PK_cmsContentVersion" id="lock1ec989fce00" mode="X" associatedObjectId="72057594262650880"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1f41a891848" mode="S" requestType="wait"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1e9b0bbc108" mode="S" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/keylock&gt;
   &lt;keylock hobtid="72057594262650880" dbid="5" objectname="Umbraco_Prod.dbo.cmsContentVersion" indexname="PK_cmsContentVersion" id="lock1ec989fce00" mode="X" associatedObjectId="72057594262650880"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1dfa92df088" mode="X"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1f41a891848" mode="S" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/keylock&gt;
   &lt;objectlock lockPartition="0" objid="1621580815" subresource="FULL" dbid="5" objectname="Umbraco_Prod.dbo.cmsPropertyData" id="lock1f0e97ddc80" mode="S" associatedObjectId="1621580815"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1f41a891848" mode="S"/&gt;
     &lt;owner id="process1e9b0bbc108" mode="S"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1dfa92df088" mode="IX" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/objectlock&gt;
  &lt;/resource-list&gt;
 &lt;/deadlock&gt;
&lt;/deadlock-list&gt;
</Column>
      <Column id="41" name="LoginSid">01</Column>
      <Column id="11" name="LoginName">sa</Column>
      <Column id="51" name="EventSequence">108030</Column>
      <Column id="12" name="SPID">28</Column>
      <Column id="60" name="IsSystem">1</Column>
      <Column id="14" name="StartTime">2020-09-17T10:16:58.317+02:00</Column>
      <Column id="26" name="ServerName">SQLSRV</Column>
    </Event>
    <Event id="148" name="Deadlock graph">
      <Column id="1" name="TextData">&lt;deadlock-list&gt;
 &lt;deadlock victim="process1dfa92de8c8"&gt;
  &lt;process-list&gt;
   &lt;process id="process1dfa92de8c8" taskpriority="0" logused="0" waitresource="KEY: 5:72057594262650880 (c6b0a83d6153)" waittime="1112" ownerId="493828961" transactionname="SELECT" lasttranstarted="2020-09-17T10:26:47.430" XDES="0x1f20cff8180" lockMode="S" schedulerid="8" kpid="9112" status="suspended" spid="61" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2020-09-17T10:26:47.430" lastbatchcompleted="2020-09-17T10:26:47.430" lastattention="1900-01-01T00:00:00.430" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="493828961" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="174" stmtend="3492" sqlhandle="0x020000008bdbb31d358a811a4580cf0638ba7a24307b9bec0000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 nvarchar(40),@1 nvarchar(40),@2 nvarchar(4000),@3 nvarchar(4000),@4 nvarchar(4000))SELECT cmsPropertyData.*
FROM cmsPropertyData
INNER JOIN cmsPropertyType
ON cmsPropertyData.propertytypeid = cmsPropertyType.id
INNER JOIN 
    (SELECT cmsContent.nodeId, cmsContentVersion.VersionId FROM [cmsMember]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [cmsMember].[nodeId]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE (([umbracoNode].[nodeObjectType] = @0))
AND umbracoNode.id IN (SELECT DISTINCT(umbracoNode.id)
FROM [umbracoNode]
INNER JOIN [cmsContent]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [umbracoNode].[id]
INNER JOIN [cmsMember]
ON     &lt;/inputbuf&gt;
   &lt;/process&gt;
   &lt;process id="process1f427037088" taskpriority="0" logused="252" waitresource="OBJECT: 5:1621580815:0 " waittime="2024" ownerId="493829131" transactionname="user_transaction" lasttranstarted="2020-09-17T10:26:47.633" XDES="0x1ee1175ae58" lockMode="IX" schedulerid="4" kpid="2968" status="suspended" spid="67" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2020-09-17T10:26:47.640" lastbatchcompleted="2020-09-17T10:26:47.640" lastattention="1900-01-01T00:00:00.640" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="493829131" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="256" stmtend="650" sqlhandle="0x02000000705b8924d8731bb71e7579e2fedd3f71962d61be0000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 int,@1 nvarchar(40),@2 int,@3 nvarchar(4000),@4 nvarchar(4000),@5 nvarchar(4000),@6 nvarchar(4000),@7 nvarchar(4000),@8 int)UPDATE [cmsPropertyData] SET [contentNodeId] = @0, [versionId] = @1, [propertytypeid] = @2, [dataInt] = @3, [dataDecimal] = @4, [dataDate] = @5, [dataNvarchar] = @6, [dataNtext] = @7 WHERE [id] = @8    &lt;/inputbuf&gt;
   &lt;/process&gt;
  &lt;/process-list&gt;
  &lt;resource-list&gt;
   &lt;keylock hobtid="72057594262650880" dbid="5" objectname="Umbraco_Prod.dbo.cmsContentVersion" indexname="PK_cmsContentVersion" id="lock1dfe9402280" mode="X" associatedObjectId="72057594262650880"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1f427037088" mode="X"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1dfa92de8c8" mode="S" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/keylock&gt;
   &lt;objectlock lockPartition="0" objid="1621580815" subresource="FULL" dbid="5" objectname="Umbraco_Prod.dbo.cmsPropertyData" id="lock1e3856d2700" mode="S" associatedObjectId="1621580815"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1dfa92de8c8" mode="S"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1f427037088" mode="IX" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/objectlock&gt;
  &lt;/resource-list&gt;
 &lt;/deadlock&gt;
&lt;/deadlock-list&gt;
</Column>
      <Column id="41" name="LoginSid">01</Column>
      <Column id="11" name="LoginName">sa</Column>
      <Column id="51" name="EventSequence">108160</Column>
      <Column id="12" name="SPID">21</Column>
      <Column id="60" name="IsSystem">1</Column>
      <Column id="14" name="StartTime">2020-09-17T10:26:49.663+02:00</Column>
      <Column id="26" name="ServerName">SQLSRV</Column>
    </Event>
    <Event id="148" name="Deadlock graph">
      <Column id="1" name="TextData">&lt;deadlock-list&gt;
 &lt;deadlock victim="process1f42703f848"&gt;
  &lt;process-list&gt;
   &lt;process id="process1f42703f848" taskpriority="0" logused="0" waitresource="KEY: 5:72057594262650880 (c6b0a83d6153)" waittime="4548" ownerId="493831132" transactionname="SELECT" lasttranstarted="2020-09-17T10:26:49.023" XDES="0x1e7758c3a40" lockMode="S" schedulerid="5" kpid="8336" status="suspended" spid="71" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2020-09-17T10:26:49.023" lastbatchcompleted="2020-09-17T10:26:49.023" lastattention="1900-01-01T00:00:00.023" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="493831132" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="174" stmtend="2852" sqlhandle="0x020000001094961a7d623cd7add5b1ade32ccc6a9a48d1790000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 nvarchar(40),@1 nvarchar(40),@2 nvarchar(4000),@3 nvarchar(4000),@4 nvarchar(4000))SELECT *
FROM [cmsMember]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [cmsMember].[nodeId]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE (([umbracoNode].[nodeObjectType] = @0))
AND umbracoNode.id IN (SELECT DISTINCT(umbracoNode.id)
FROM [umbracoNode]
INNER JOIN [cmsContent]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [umbracoNode].[id]
INNER JOIN [cmsMember]
ON [cmsMember].[nodeId] = [cmsContent].[nodeId]
LEFT JOIN [cmsPropertyType]
ON [cmsPropertyType].[contentTypeId] = [cmsContent].[contentType]
LEFT JOIN [cmsDataType]
ON [cmsDataType].[nodeId] = [    &lt;/inputbuf&gt;
   &lt;/process&gt;
   &lt;process id="process1f427037088" taskpriority="0" logused="252" waitresource="OBJECT: 5:1621580815:0 " waittime="7024" ownerId="493829131" transactionname="user_transaction" lasttranstarted="2020-09-17T10:26:47.633" XDES="0x1ee1175ae58" lockMode="IX" schedulerid="4" kpid="2968" status="suspended" spid="67" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2020-09-17T10:26:47.640" lastbatchcompleted="2020-09-17T10:26:47.640" lastattention="1900-01-01T00:00:00.640" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="493829131" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="256" stmtend="650" sqlhandle="0x02000000705b8924d8731bb71e7579e2fedd3f71962d61be0000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 int,@1 nvarchar(40),@2 int,@3 nvarchar(4000),@4 nvarchar(4000),@5 nvarchar(4000),@6 nvarchar(4000),@7 nvarchar(4000),@8 int)UPDATE [cmsPropertyData] SET [contentNodeId] = @0, [versionId] = @1, [propertytypeid] = @2, [dataInt] = @3, [dataDecimal] = @4, [dataDate] = @5, [dataNvarchar] = @6, [dataNtext] = @7 WHERE [id] = @8    &lt;/inputbuf&gt;
   &lt;/process&gt;
  &lt;/process-list&gt;
  &lt;resource-list&gt;
   &lt;keylock hobtid="72057594262650880" dbid="5" objectname="Umbraco_Prod.dbo.cmsContentVersion" indexname="PK_cmsContentVersion" id="lock1dfe9402280" mode="X" associatedObjectId="72057594262650880"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1f427037088" mode="X"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1f42703f848" mode="S" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/keylock&gt;
   &lt;objectlock lockPartition="0" objid="1621580815" subresource="FULL" dbid="5" objectname="Umbraco_Prod.dbo.cmsPropertyData" id="lock1e3856d2700" mode="S" associatedObjectId="1621580815"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1f42703f848" mode="S"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1f427037088" mode="IX" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/objectlock&gt;
  &lt;/resource-list&gt;
 &lt;/deadlock&gt;
&lt;/deadlock-list&gt;
</Column>
      <Column id="41" name="LoginSid">01</Column>
      <Column id="11" name="LoginName">sa</Column>
      <Column id="51" name="EventSequence">108161</Column>
      <Column id="12" name="SPID">27</Column>
      <Column id="60" name="IsSystem">1</Column>
      <Column id="14" name="StartTime">2020-09-17T10:26:54.663+02:00</Column>
      <Column id="26" name="ServerName">SQLSRV</Column>
    </Event>
    <Event id="148" name="Deadlock graph">
      <Column id="1" name="TextData">&lt;deadlock-list&gt;
 &lt;deadlock victim="process1f427037088"&gt;
  &lt;process-list&gt;
   &lt;process id="process1f427037088" taskpriority="0" logused="0" waitresource="KEY: 5:72057594262650880 (42681e80e11e)" waittime="4670" ownerId="493864167" transactionname="SELECT" lasttranstarted="2020-09-17T10:27:45.563" XDES="0x1f2329d7a40" lockMode="S" schedulerid="4" kpid="2968" status="suspended" spid="67" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2020-09-17T10:27:45.563" lastbatchcompleted="2020-09-17T10:27:45.563" lastattention="1900-01-01T00:00:00.563" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="493864167" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="174" stmtend="3492" sqlhandle="0x020000008bdbb31d358a811a4580cf0638ba7a24307b9bec0000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 nvarchar(40),@1 nvarchar(40),@2 nvarchar(4000),@3 nvarchar(4000),@4 nvarchar(4000))SELECT cmsPropertyData.*
FROM cmsPropertyData
INNER JOIN cmsPropertyType
ON cmsPropertyData.propertytypeid = cmsPropertyType.id
INNER JOIN 
    (SELECT cmsContent.nodeId, cmsContentVersion.VersionId FROM [cmsMember]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [cmsMember].[nodeId]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE (([umbracoNode].[nodeObjectType] = @0))
AND umbracoNode.id IN (SELECT DISTINCT(umbracoNode.id)
FROM [umbracoNode]
INNER JOIN [cmsContent]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [umbracoNode].[id]
INNER JOIN [cmsMember]
ON     &lt;/inputbuf&gt;
   &lt;/process&gt;
   &lt;process id="process1e9b0bbcca8" taskpriority="0" logused="252" waitresource="OBJECT: 5:1621580815:0 " waittime="5073" ownerId="493864311" transactionname="user_transaction" lasttranstarted="2020-09-17T10:27:45.833" XDES="0x1ec5b9698a8" lockMode="IX" schedulerid="8" kpid="11004" status="suspended" spid="61" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2020-09-17T10:27:45.843" lastbatchcompleted="2020-09-17T10:27:45.840" lastattention="1900-01-01T00:00:00.840" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="493864311" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="256" stmtend="650" sqlhandle="0x02000000705b8924d8731bb71e7579e2fedd3f71962d61be0000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 int,@1 nvarchar(40),@2 int,@3 nvarchar(4000),@4 nvarchar(4000),@5 nvarchar(4000),@6 nvarchar(4000),@7 nvarchar(4000),@8 int)UPDATE [cmsPropertyData] SET [contentNodeId] = @0, [versionId] = @1, [propertytypeid] = @2, [dataInt] = @3, [dataDecimal] = @4, [dataDate] = @5, [dataNvarchar] = @6, [dataNtext] = @7 WHERE [id] = @8    &lt;/inputbuf&gt;
   &lt;/process&gt;
  &lt;/process-list&gt;
  &lt;resource-list&gt;
   &lt;keylock hobtid="72057594262650880" dbid="5" objectname="Umbraco_Prod.dbo.cmsContentVersion" indexname="PK_cmsContentVersion" id="lock1ee55324100" mode="X" associatedObjectId="72057594262650880"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1e9b0bbcca8" mode="X"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1f427037088" mode="S" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/keylock&gt;
   &lt;objectlock lockPartition="0" objid="1621580815" subresource="FULL" dbid="5" objectname="Umbraco_Prod.dbo.cmsPropertyData" id="lock1ece4318600" mode="S" associatedObjectId="1621580815"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1f427037088" mode="S"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1e9b0bbcca8" mode="IX" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/objectlock&gt;
  &lt;/resource-list&gt;
 &lt;/deadlock&gt;
&lt;/deadlock-list&gt;
</Column>
      <Column id="41" name="LoginSid">01</Column>
      <Column id="11" name="LoginName">sa</Column>
      <Column id="51" name="EventSequence">108168</Column>
      <Column id="12" name="SPID">28</Column>
      <Column id="60" name="IsSystem">1</Column>
      <Column id="14" name="StartTime">2020-09-17T10:27:50.917+02:00</Column>
      <Column id="26" name="ServerName">SQLSRV</Column>
    </Event>
    <Event id="148" name="Deadlock graph">
      <Column id="1" name="TextData">&lt;deadlock-list&gt;
 &lt;deadlock victim="process1e9b0bbd088"&gt;
  &lt;process-list&gt;
   &lt;process id="process1e9b0bbd088" taskpriority="0" logused="0" waitresource="KEY: 5:72057594262650880 (4d65e57a1417)" waittime="1299" ownerId="493894496" transactionname="SELECT" lasttranstarted="2020-09-17T10:29:01.547" XDES="0x1f416e3ba40" lockMode="S" schedulerid="8" kpid="2272" status="suspended" spid="61" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2020-09-17T10:29:01.547" lastbatchcompleted="2020-09-17T10:29:01.547" lastattention="1900-01-01T00:00:00.547" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="493894496" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="174" stmtend="3492" sqlhandle="0x020000008bdbb31d358a811a4580cf0638ba7a24307b9bec0000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 nvarchar(40),@1 nvarchar(40),@2 nvarchar(4000),@3 nvarchar(4000),@4 nvarchar(4000))SELECT cmsPropertyData.*
FROM cmsPropertyData
INNER JOIN cmsPropertyType
ON cmsPropertyData.propertytypeid = cmsPropertyType.id
INNER JOIN 
    (SELECT cmsContent.nodeId, cmsContentVersion.VersionId FROM [cmsMember]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [cmsMember].[nodeId]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE (([umbracoNode].[nodeObjectType] = @0))
AND umbracoNode.id IN (SELECT DISTINCT(umbracoNode.id)
FROM [umbracoNode]
INNER JOIN [cmsContent]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [umbracoNode].[id]
INNER JOIN [cmsMember]
ON     &lt;/inputbuf&gt;
   &lt;/process&gt;
   &lt;process id="process1ed033964e8" taskpriority="0" logused="260" waitresource="OBJECT: 5:1621580815:0 " waittime="1607" ownerId="493894597" transactionname="user_transaction" lasttranstarted="2020-09-17T10:29:01.803" XDES="0x1e22544f8a8" lockMode="IX" schedulerid="5" kpid="1460" status="suspended" spid="71" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2020-09-17T10:29:01.813" lastbatchcompleted="2020-09-17T10:29:01.813" lastattention="1900-01-01T00:00:00.813" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="493894597" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="256" stmtend="650" sqlhandle="0x02000000705b8924d8731bb71e7579e2fedd3f71962d61be0000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 int,@1 nvarchar(40),@2 int,@3 nvarchar(4000),@4 nvarchar(4000),@5 nvarchar(4000),@6 nvarchar(4000),@7 nvarchar(4000),@8 int)UPDATE [cmsPropertyData] SET [contentNodeId] = @0, [versionId] = @1, [propertytypeid] = @2, [dataInt] = @3, [dataDecimal] = @4, [dataDate] = @5, [dataNvarchar] = @6, [dataNtext] = @7 WHERE [id] = @8    &lt;/inputbuf&gt;
   &lt;/process&gt;
  &lt;/process-list&gt;
  &lt;resource-list&gt;
   &lt;keylock hobtid="72057594262650880" dbid="5" objectname="Umbraco_Prod.dbo.cmsContentVersion" indexname="PK_cmsContentVersion" id="lock1ebdd6ae600" mode="X" associatedObjectId="72057594262650880"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1ed033964e8" mode="X"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1e9b0bbd088" mode="S" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/keylock&gt;
   &lt;objectlock lockPartition="0" objid="1621580815" subresource="FULL" dbid="5" objectname="Umbraco_Prod.dbo.cmsPropertyData" id="lock1e0059e7480" mode="S" associatedObjectId="1621580815"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1e9b0bbd088" mode="S"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1ed033964e8" mode="IX" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/objectlock&gt;
  &lt;/resource-list&gt;
 &lt;/deadlock&gt;
&lt;/deadlock-list&gt;
</Column>
      <Column id="41" name="LoginSid">01</Column>
      <Column id="11" name="LoginName">sa</Column>
      <Column id="51" name="EventSequence">108191</Column>
      <Column id="12" name="SPID">13</Column>
      <Column id="60" name="IsSystem">1</Column>
      <Column id="14" name="StartTime">2020-09-17T10:29:03.42+02:00</Column>
      <Column id="26" name="ServerName">SQLSRV</Column>
    </Event>
    <Event id="148" name="Deadlock graph">
      <Column id="1" name="TextData">&lt;deadlock-list&gt;
 &lt;deadlock victim="process1f4172cc8c8"&gt;
  &lt;process-list&gt;
   &lt;process id="process1f4172cc8c8" taskpriority="0" logused="0" waitresource="KEY: 5:72057594262650880 (47ed496098bd)" waittime="116" ownerId="494373572" transactionname="SELECT" lasttranstarted="2020-09-17T10:52:09.897" XDES="0x1ed3b4d3a40" lockMode="S" schedulerid="8" kpid="11996" status="suspended" spid="61" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2020-09-17T10:52:09.893" lastbatchcompleted="2020-09-17T10:52:09.893" lastattention="1900-01-01T00:00:00.893" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="494373572" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="174" stmtend="3492" sqlhandle="0x020000008bdbb31d358a811a4580cf0638ba7a24307b9bec0000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 nvarchar(40),@1 nvarchar(40),@2 nvarchar(4000),@3 nvarchar(4000),@4 nvarchar(4000))SELECT cmsPropertyData.*
FROM cmsPropertyData
INNER JOIN cmsPropertyType
ON cmsPropertyData.propertytypeid = cmsPropertyType.id
INNER JOIN 
    (SELECT cmsContent.nodeId, cmsContentVersion.VersionId FROM [cmsMember]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [cmsMember].[nodeId]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE (([umbracoNode].[nodeObjectType] = @0))
AND umbracoNode.id IN (SELECT DISTINCT(umbracoNode.id)
FROM [umbracoNode]
INNER JOIN [cmsContent]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [umbracoNode].[id]
INNER JOIN [cmsMember]
ON     &lt;/inputbuf&gt;
   &lt;/process&gt;
   &lt;process id="process1f427047848" taskpriority="0" logused="252" waitresource="OBJECT: 5:1621580815:0 " waittime="926" ownerId="494373712" transactionname="user_transaction" lasttranstarted="2020-09-17T10:52:10.103" XDES="0x1ebaa7378a8" lockMode="IX" schedulerid="6" kpid="10948" status="suspended" spid="71" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2020-09-17T10:52:10.113" lastbatchcompleted="2020-09-17T10:52:10.110" lastattention="1900-01-01T00:00:00.110" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="494373712" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="256" stmtend="650" sqlhandle="0x02000000705b8924d8731bb71e7579e2fedd3f71962d61be0000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 int,@1 nvarchar(40),@2 int,@3 nvarchar(4000),@4 nvarchar(4000),@5 nvarchar(4000),@6 nvarchar(4000),@7 nvarchar(4000),@8 int)UPDATE [cmsPropertyData] SET [contentNodeId] = @0, [versionId] = @1, [propertytypeid] = @2, [dataInt] = @3, [dataDecimal] = @4, [dataDate] = @5, [dataNvarchar] = @6, [dataNtext] = @7 WHERE [id] = @8    &lt;/inputbuf&gt;
   &lt;/process&gt;
  &lt;/process-list&gt;
  &lt;resource-list&gt;
   &lt;keylock hobtid="72057594262650880" dbid="5" objectname="Umbraco_Prod.dbo.cmsContentVersion" indexname="PK_cmsContentVersion" id="lock1e3d85a2200" mode="X" associatedObjectId="72057594262650880"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1f427047848" mode="X"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1f4172cc8c8" mode="S" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/keylock&gt;
   &lt;objectlock lockPartition="0" objid="1621580815" subresource="FULL" dbid="5" objectname="Umbraco_Prod.dbo.cmsPropertyData" id="lock1f36cfbb380" mode="S" associatedObjectId="1621580815"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1f4172cc8c8" mode="S"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1f427047848" mode="IX" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/objectlock&gt;
  &lt;/resource-list&gt;
 &lt;/deadlock&gt;
&lt;/deadlock-list&gt;
</Column>
      <Column id="41" name="LoginSid">01</Column>
      <Column id="11" name="LoginName">sa</Column>
      <Column id="51" name="EventSequence">108353</Column>
      <Column id="12" name="SPID">25</Column>
      <Column id="60" name="IsSystem">1</Column>
      <Column id="14" name="StartTime">2020-09-17T10:52:11.04+02:00</Column>
      <Column id="26" name="ServerName">SQLSRV</Column>
    </Event>
    <Event id="148" name="Deadlock graph">
      <Column id="1" name="TextData">&lt;deadlock-list&gt;
 &lt;deadlock victim="process1f427027468"&gt;
  &lt;process-list&gt;
   &lt;process id="process1f427027468" taskpriority="0" logused="0" waitresource="KEY: 5:72057594262650880 (3c1f41aba7b2)" waittime="2201" ownerId="494385924" transactionname="SELECT" lasttranstarted="2020-09-17T10:52:40.660" XDES="0x1e5ab437a40" lockMode="S" schedulerid="2" kpid="3976" status="suspended" spid="67" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2020-09-17T10:52:40.660" lastbatchcompleted="2020-09-17T10:52:40.660" lastattention="1900-01-01T00:00:00.660" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="494385924" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="174" stmtend="3492" sqlhandle="0x020000008bdbb31d358a811a4580cf0638ba7a24307b9bec0000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 nvarchar(40),@1 nvarchar(40),@2 nvarchar(4000),@3 nvarchar(4000),@4 nvarchar(4000))SELECT cmsPropertyData.*
FROM cmsPropertyData
INNER JOIN cmsPropertyType
ON cmsPropertyData.propertytypeid = cmsPropertyType.id
INNER JOIN 
    (SELECT cmsContent.nodeId, cmsContentVersion.VersionId FROM [cmsMember]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [cmsMember].[nodeId]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE (([umbracoNode].[nodeObjectType] = @0))
AND umbracoNode.id IN (SELECT DISTINCT(umbracoNode.id)
FROM [umbracoNode]
INNER JOIN [cmsContent]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [umbracoNode].[id]
INNER JOIN [cmsMember]
ON     &lt;/inputbuf&gt;
   &lt;/process&gt;
   &lt;process id="process1f427047848" taskpriority="0" logused="252" waitresource="OBJECT: 5:1621580815:0 " waittime="2675" ownerId="494386115" transactionname="user_transaction" lasttranstarted="2020-09-17T10:52:40.860" XDES="0x1f104248598" lockMode="IX" schedulerid="6" kpid="10948" status="suspended" spid="71" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2020-09-17T10:52:40.867" lastbatchcompleted="2020-09-17T10:52:40.863" lastattention="1900-01-01T00:00:00.863" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="494386115" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="256" stmtend="650" sqlhandle="0x02000000705b8924d8731bb71e7579e2fedd3f71962d61be0000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 int,@1 nvarchar(40),@2 int,@3 nvarchar(4000),@4 nvarchar(4000),@5 nvarchar(4000),@6 nvarchar(4000),@7 nvarchar(4000),@8 int)UPDATE [cmsPropertyData] SET [contentNodeId] = @0, [versionId] = @1, [propertytypeid] = @2, [dataInt] = @3, [dataDecimal] = @4, [dataDate] = @5, [dataNvarchar] = @6, [dataNtext] = @7 WHERE [id] = @8    &lt;/inputbuf&gt;
   &lt;/process&gt;
  &lt;/process-list&gt;
  &lt;resource-list&gt;
   &lt;keylock hobtid="72057594262650880" dbid="5" objectname="Umbraco_Prod.dbo.cmsContentVersion" indexname="PK_cmsContentVersion" id="lock1e61648ad00" mode="X" associatedObjectId="72057594262650880"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1f427047848" mode="X"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1f427027468" mode="S" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/keylock&gt;
   &lt;objectlock lockPartition="0" objid="1621580815" subresource="FULL" dbid="5" objectname="Umbraco_Prod.dbo.cmsPropertyData" id="lock1eb39135200" mode="S" associatedObjectId="1621580815"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1f427027468" mode="S"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1f427047848" mode="IX" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/objectlock&gt;
  &lt;/resource-list&gt;
 &lt;/deadlock&gt;
&lt;/deadlock-list&gt;
</Column>
      <Column id="41" name="LoginSid">01</Column>
      <Column id="11" name="LoginName">sa</Column>
      <Column id="51" name="EventSequence">108363</Column>
      <Column id="12" name="SPID">25</Column>
      <Column id="60" name="IsSystem">1</Column>
      <Column id="14" name="StartTime">2020-09-17T10:52:43.543+02:00</Column>
      <Column id="26" name="ServerName">SQLSRV</Column>
    </Event>
    <Event id="148" name="Deadlock graph">
      <Column id="1" name="TextData">&lt;deadlock-list&gt;
 &lt;deadlock victim="process1ed033964e8"&gt;
  &lt;process-list&gt;
   &lt;process id="process1ed033964e8" taskpriority="0" logused="0" waitresource="KEY: 5:72057594262650880 (d56851196b62)" waittime="3469" ownerId="494616313" transactionname="SELECT" lasttranstarted="2020-09-17T11:01:36.890" XDES="0x1f05d2cede0" lockMode="S" schedulerid="5" kpid="1460" status="suspended" spid="71" sbid="0" ecid="0" priority="0" trancount="0" lastbatchstarted="2020-09-17T11:01:36.890" lastbatchcompleted="2020-09-17T11:01:36.883" lastattention="1900-01-01T00:00:00.883" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="494616313" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="174" stmtend="3584" sqlhandle="0x020000007d7b2a2ea5f891f667a4693b50cd0cface76b0390000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 nvarchar(40),@1 nvarchar(40),@2 nvarchar(4000),@3 nvarchar(4000),@4 nvarchar(4000))SELECT a.id, a.value, a.sortorder, a.alias, a.datatypeNodeId
FROM cmsDataTypePreValues a
WHERE EXISTS(
    SELECT DISTINCT b.id as preValIdInner
    FROM cmsDataTypePreValues b
    INNER JOIN cmsPropertyType
    ON b.datatypeNodeId = cmsPropertyType.dataTypeId
    INNER JOIN 
        (SELECT cmsContent.contentType FROM [cmsMember]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [cmsMember].[nodeId]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE (([umbracoNode].[nodeObjectType] = @0))
AND umbracoNode.id IN (SELECT DISTINCT(umbracoNode.id)
FROM [umbracoNode]
INNER JOIN [cmsContent]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]    &lt;/inputbuf&gt;
   &lt;/process&gt;
   &lt;process id="process1f4164828c8" taskpriority="0" logused="252" waitresource="OBJECT: 5:1621580815:0 " waittime="3930" ownerId="494616797" transactionname="user_transaction" lasttranstarted="2020-09-17T11:01:37.033" XDES="0x1ecd7f18e58" lockMode="IX" schedulerid="7" kpid="11712" status="suspended" spid="61" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2020-09-17T11:01:37.140" lastbatchcompleted="2020-09-17T11:01:37.137" lastattention="1900-01-01T00:00:00.137" clientapp=".Net SqlClient Data Provider" hostname="WEB" hostpid="6728" loginname="Umbraco" isolationlevel="read committed (2)" xactid="494616797" currentdb="5" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"&gt;
    &lt;executionStack&gt;
     &lt;frame procname="adhoc" line="1" stmtstart="256" stmtend="650" sqlhandle="0x02000000705b8924d8731bb71e7579e2fedd3f71962d61be0000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
     &lt;frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"&gt;
unknown     &lt;/frame&gt;
    &lt;/executionStack&gt;
    &lt;inputbuf&gt;
(@0 int,@1 nvarchar(40),@2 int,@3 nvarchar(4000),@4 nvarchar(4000),@5 nvarchar(4000),@6 nvarchar(4000),@7 nvarchar(4000),@8 int)UPDATE [cmsPropertyData] SET [contentNodeId] = @0, [versionId] = @1, [propertytypeid] = @2, [dataInt] = @3, [dataDecimal] = @4, [dataDate] = @5, [dataNvarchar] = @6, [dataNtext] = @7 WHERE [id] = @8    &lt;/inputbuf&gt;
   &lt;/process&gt;
  &lt;/process-list&gt;
  &lt;resource-list&gt;
   &lt;keylock hobtid="72057594262650880" dbid="5" objectname="Umbraco_Prod.dbo.cmsContentVersion" indexname="PK_cmsContentVersion" id="lock1e03eb70b80" mode="X" associatedObjectId="72057594262650880"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1f4164828c8" mode="X"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1ed033964e8" mode="S" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/keylock&gt;
   &lt;objectlock lockPartition="0" objid="1621580815" subresource="FULL" dbid="5" objectname="Umbraco_Prod.dbo.cmsPropertyData" id="lock1e5269fdc00" mode="S" associatedObjectId="1621580815"&gt;
    &lt;owner-list&gt;
     &lt;owner id="process1ed033964e8" mode="S"/&gt;
    &lt;/owner-list&gt;
    &lt;waiter-list&gt;
     &lt;waiter id="process1f4164828c8" mode="IX" requestType="wait"/&gt;
    &lt;/waiter-list&gt;
   &lt;/objectlock&gt;
  &lt;/resource-list&gt;
 &lt;/deadlock&gt;
&lt;/deadlock-list&gt;
</Column>
      <Column id="41" name="LoginSid">01</Column>
      <Column id="11" name="LoginName">sa</Column>
      <Column id="51" name="EventSequence">108454</Column>
      <Column id="12" name="SPID">25</Column>
      <Column id="60" name="IsSystem">1</Column>
      <Column id="14" name="StartTime">2020-09-17T11:01:41.07+02:00</Column>
      <Column id="26" name="ServerName">SQLSRV</Column>
    </Event>
  </Events>
</TraceData>

Copy Link

Tajamal 87 posts 175 karma points

Sep 17, 2020 @ 09:48
0
This occassionaly happens when i calling method GetMembersByPropertyValue in MemberService.
```
var memberService = Services.MemberService;
var member = memberService.GetMembersByPropertyValue("memberNumber", memberNumber).FirstOrDefault();
```
Copy Link
is working on a reply...

Please Sign in or register to post replies