Copied to clipboard

Flag this post as spam?

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


  • Tajamal 69 posts 157 karma points
    Sep 17, 2020 @ 09:11
    Tajamal
    0

    cmsContentVersion deadlock

    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>
    
  • Tajamal 69 posts 157 karma points
    Sep 17, 2020 @ 09:48
    Tajamal
    0

    This occassionaly happens when i calling method GetMembersByPropertyValue in MemberService.

    var memberService = Services.MemberService;
    var member = memberService.GetMembersByPropertyValue("memberNumber", memberNumber).FirstOrDefault();
    
Please Sign in or register to post replies

Write your reply to:

Draft