May 11, 2021 at 7:08 pm
Hi ,
deadlock detected in system (you can copy paste xml code bellow ,save to XDL and open in SSMS to have visual graph)
Deadlock on table manager and delivery .Tables have no foreign keys and related triggers .
Since tables have no relations of any kind, does it mean deadlock information not fully captured by database and I see only tails of transactions that have more statements inside ?
Thank you
Alex
--code
<deadlock><victim-list><victimProcess id="process34accf12d079"/></victim-list><process-list><process id="process34accf12d079" taskpriority="0" logused="740" waitresource="KEY: 8:52057595038531511 (cda6e04cf323)" waittime="2289" ownerId="6817132812" transactionname="implicit_transaction" lasttranstarted="2021-05-11T15:15:24.660" XDES="0x21c64c34428" lockMode="U" schedulerid="20" kpid="86468" status="suspended" spid="758" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2021-05-11T15:15:24.667" lastbatchcompleted="2021-05-11T15:15:24.667" lastattention="1900-01-01T00:00:00.667" clientapp="Microsoft JDBC Driver for SQL Server" hostname="customervm-3212dv42" hostpid="0" loginname="user_x" isolationlevel="read committed (2)" xactid="6817132812" currentdb="8" currentdbname="cust02-estcost-z1-db" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128058"><executionStack><frame procname="unknown" queryhash="0xx42156d48ffd400" queryplanhash="0x9914d663ee82d273" line="1" stmtstart="96" stmtend="324" sqlhandle="0x020000008c93113226dda7c848baf7927f734098ca9579050000000000000000000000000000000000000000">
unknown </frame><frame procname="unknown" queryhash="0x0000000000000000" queryplanhash="0x0000000000000000" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
unknown </frame></executionStack><inputbuf>
(@P0 bigint,@P1 datetime2,@P2 bigint,@P3 bigint)UPDATE managers SET hjmpTS = @P0 ,modifiedTS=@P1,p_entrytype=@P2 WHERE PK = @P3 AND (usedBy IS NULL OR usedBy=0) </inputbuf></process><process id="process21aff0fb468" taskpriority="0" logused="31212" waitresource="KEY: 8:72057595034533888 (1331056cbbdd)" waittime="2202" ownerId="7817127617" transactionname="implicit_transaction" lasttranstarted="2021-05-11T15:15:24.547" XDES="0x21be90d4428" lockMode="U" schedulerid="22" kpid="87168" status="suspended" spid="796" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2021-05-11T15:15:24.753" lastbatchcompleted="2021-05-11T15:15:24.753" lastattention="1900-01-01T00:00:00.753" clientapp="Microsoft JDBC Driver for SQL Server" hostname="customer_vm_424569dfh" hostpid="0" loginname="user_x" isolationlevel="read committed (2)" xactid="7817127617" currentdb="8" currentdbname="cust02-estcost-z1-db" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128058"><executionStack><frame procname="unknown" queryhash="0xb0804bbfe75a3306" queryplanhash="0x466ac288a45fc50b" line="1" stmtstart="24" stmtend="170" sqlhandle="0x02000000c00f6d016bf98d3256f2984aa0ce4b7459c7ae980000000000000000000000000000000000000000">
unknown </frame><frame procname="unknown" queryhash="0x0000000000000000" queryplanhash="0x0000000000000000" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
unknown </frame></executionStack><inputbuf>
(@P0 bigint)DELETE FROM delivery WHERE PK = @P0 AND (usedBy IS NULL OR usedBy=0) </inputbuf></process></process-list><resource-list><keylock hobtid="72057595038531584" dbid="8" objectname="03c9aax7-cd89-4af6-ac58-0ed7177a731b.dbo.managers" indexname="PK__managentr__32150787DE0DAE5E" id="lock1fa59800c00" mode="X" associatedObjectId="72057595038531584"><owner-list><owner id="process21aff0fb468" mode="X"/></owner-list><waiter-list><waiter id="process34accf12d079" mode="U" requestType="wait"/></waiter-list></keylock><keylock hobtid="72057595034533888" dbid="8" objectname="03c9aax7-cd89-4af6-ac58-0ed7177a731b.dbo.delivery" indexname="PK__deliverde__32150787FA2385D1" id="lock1ff494c3d80" mode="X" associatedObjectId="72057595034533888"><owner-list><owner id="process34accf12d079" mode="X"/></owner-list><waiter-list><waiter id="process21aff0fb468" mode="U" requestType="wait"/></waiter-list></keylock></resource-list></deadlock>
May 12, 2021 at 7:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply