Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <deadlock>
- <victim-list>
- <victimProcess id="process12ce90f848" />
- </victim-list>
- <process-list>
- <process id="process12ce90f848" taskpriority="0" logused="18772" waitresource="RID: 24:1:57228177:30" waittime="623" ownerId="11236734576" transactionname="INSERT" lasttranstarted="2017-01-23T10:31:14.193" XDES="0x2e2994d90" lockMode="S" schedulerid="32" kpid="34436" status="suspended" spid="157" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2017-01-23T10:31:14.197" lastbatchcompleted="2017-01-23T10:31:14.203" lastattention="1900-01-01T00:00:00.203" clientapp="IMG.Share" hostname="WIN01SV0296" hostpid="6660" loginname="IMGUser" isolationlevel="read committed (2)" xactid="11236734576" currentdb="24" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
- <executionStack>
- <frame procname="adhoc" line="1" stmtstart="160" stmtend="366" sqlhandle="0x0200000036829f178721a0c82c83ea2d38a8f64e8fe365290000000000000000000000000000000000000000">
- unknown </frame>
- <frame procname="adhoc" line="1" stmtstart="160" stmtend="366" sqlhandle="0x0200000011b8110afdc6128367011dfd02167125c84417d10000000000000000000000000000000000000000">
- unknown </frame>
- <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
- unknown </frame>
- </executionStack>
- <inputbuf>
- (@Bytes varbinary(max) ,@FileName varchar(max) ,@MediaBinaryId uniqueidentifier)INSERT INTO BinaryFileTable ( stream_id, file_stream, name ) VALUES( @MediaBinaryId, @Bytes, @FileName ); </inputbuf>
- </process>
- <process id="process12cf901c28" taskpriority="0" logused="18832" waitresource="RID: 24:1:56798698:7" waittime="1076" ownerId="11236724841" transactionname="INSERT" lasttranstarted="2017-01-23T10:31:13.847" XDES="0x78e2fb560" lockMode="S" schedulerid="14" kpid="15620" status="suspended" spid="176" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2017-01-23T10:31:13.840" lastbatchcompleted="2017-01-23T10:31:13.843" lastattention="1900-01-01T00:00:00.843" clientapp="IMG.Processor" hostname="WIN03SV0492" hostpid="7424" loginname="IMGUser" isolationlevel="read committed (2)" xactid="11236724841" currentdb="24" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
- <executionStack>
- <frame procname="adhoc" line="1" stmtstart="160" stmtend="366" sqlhandle="0x0200000036829f178721a0c82c83ea2d38a8f64e8fe365290000000000000000000000000000000000000000">
- unknown </frame>
- <frame procname="adhoc" line="1" stmtstart="160" stmtend="366" sqlhandle="0x0200000011b8110afdc6128367011dfd02167125c84417d10000000000000000000000000000000000000000">
- unknown </frame>
- <frame procname="unknown" line="1" sqlhandle="0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000">
- unknown </frame>
- </executionStack>
- <inputbuf>
- (@Bytes varbinary(max) ,@FileName varchar(max) ,@MediaBinaryId uniqueidentifier)INSERT INTO BinaryFileTable ( stream_id, file_stream, name ) VALUES( @MediaBinaryId, @Bytes, @FileName ); </inputbuf>
- </process>
- </process-list>
- <resource-list>
- <ridlock fileid="1" pageid="57228177" dbid="24" objectname="IMG_PROD02_BINARIES.prod.BinaryFileTable" id="lock288d692880" mode="X" associatedObjectId="72057594040680448">
- <owner-list>
- <owner id="process12cf901c28" mode="X" />
- </owner-list>
- <waiter-list>
- <waiter id="process12ce90f848" mode="S" requestType="wait" />
- </waiter-list>
- </ridlock>
- <ridlock fileid="1" pageid="56798698" dbid="24" objectname="IMG_PROD02_BINARIES.prod.BinaryFileTable" id="lock4716c56700" mode="X" associatedObjectId="72057594040680448">
- <owner-list>
- <owner id="process12ce90f848" mode="X" />
- </owner-list>
- <waiter-list>
- <waiter id="process12cf901c28" mode="S" requestType="wait" />
- </waiter-list>
- </ridlock>
- </resource-list>
- </deadlock>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement