Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <deadlock-list>
- <deadlock victim="processb292e2c8">
- <process-list>
- <process id="processb292e2c8" taskpriority="0" logused="0" waitresource="PAGE: 6:1:5538641" waittime="2454" ownerId="934602261" transactionname="DELETE" lasttranstarted="2011-08-02T14:03:29.280" XDES="0x8fa77fbd0" lockMode="U" schedulerid="8" kpid="6192" status="suspended" spid="64" sbid="0" ecid="28" priority="0" trancount="0" lastbatchstarted="2011-08-02T13:47:24.437" lastbatchcompleted="2011-08-02T13:39:09.373" clientapp="SQL Query Analyzer" hostname="MyQuery" hostpid="3644" isolationlevel="read committed (2)" xactid="934602261" currentdb="6" lockTimeout="4294967295" clientoption1="673187936" clientoption2="128056">
- <executionStack>
- <frame procname="adhoc" line="11" stmtstart="728" stmtend="1974" sqlhandle="0x02000000573dc22b1bf6453a2467625f5d9acd0f0517098d">
- DELETE D
- FROM MyTempTable AS X
- JOIN dbo.MyTable AS D
- ON D.ThePK_ID = X.ThePK_ID
- WHERE T_ID BETWEEN @intBatchStart AND @intBatchStart + @intBatchSize </frame>
- </executionStack>
- <inputbuf>
- </inputbuf>
- </process>
- <process id="process8c0ad9288" taskpriority="0" logused="1184" waitresource="PAGE: 6:1:5575207" waittime="2458" ownerId="934602634" transactionname="INSERT" lasttranstarted="2011-08-02T14:03:29.463" XDES="0x800dd8a0" lockMode="IX" schedulerid="15" kpid="12480" status="suspended" spid="72" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2011-08-02T14:03:29.443" lastbatchcompleted="2011-08-02T14:03:29.427" clientapp="Internet Information Services" hostname="WebServer" hostpid="2752" loginname="WebServerLogin" isolationlevel="read committed (2)" xactid="934602634" currentdb="6" lockTimeout="4294967295" clientoption1="673316896" clientoption2="128056">
- <executionStack>
- <frame procname="MyDatabase.dbo.rk_SP_CreateNewSession" line="444" stmtstart="27318" stmtend="29482" sqlhandle="0x0300060019e9131729676a00fc9e00000100000000000000">
- unknown </frame>
- <frame procname="MyDatabase.dbo.rk_SP_PageLogInit" line="247" stmtstart="18792" stmtend="20128" sqlhandle="0x030006005f460964d4747300fc9e00000100000000000000">
- EXEC @intErrNo = dbo.rk_SP_CreateNewSession
- @ThePK_ID = @ThePK_ID OUTPUT,
- ... various parameters ...
- </frame>
- </executionStack>
- <inputbuf>
- Proc [Database Id = 6 Object Id = 1678329439] </inputbuf>
- </process>
- <process id="process41eb288" taskpriority="0" logused="10000" waittime="2456" schedulerid="15" kpid="13132" status="suspended" spid="64" sbid="0" ecid="1" priority="0" trancount="0" lastbatchstarted="2011-08-02T13:47:24.437" lastbatchcompleted="2011-08-02T13:39:09.373" clientapp="SQL Query Analyzer" hostname="MyQuery" hostpid="3644" isolationlevel="read committed (2)" xactid="934602261" currentdb="6" lockTimeout="4294967295" clientoption1="673187936" clientoption2="128056">
- <executionStack>
- <frame procname="adhoc" line="11" stmtstart="728" stmtend="1974" sqlhandle="0x02000000573dc22b1bf6453a2467625f5d9acd0f0517098d">
- DELETE D
- FROM MyTempTable AS X
- JOIN dbo.MyTable AS D
- ON D.ThePK_ID = X.ThePK_ID
- WHERE T_ID BETWEEN @intBatchStart AND @intBatchStart + @intBatchSize </frame>
- </executionStack>
- <inputbuf>
- </inputbuf>
- </process>
- <process id="processb292e748" taskpriority="0" logused="10000" waittime="2639" schedulerid="8" kpid="13188" status="suspended" spid="64" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2011-08-02T13:47:24.437" lastbatchcompleted="2011-08-02T13:39:09.373" lastattention="2011-08-02T13:33:17.373" clientapp="SQL Query Analyzer" hostname="MyQuery" hostpid="3644" loginname="MyLogin" isolationlevel="read committed (2)" xactid="934602261" currentdb="6" lockTimeout="4294967295" clientoption1="673187936" clientoption2="128056">
- <executionStack>
- <frame procname="adhoc" line="11" stmtstart="728" stmtend="1974" sqlhandle="0x02000000573dc22b1bf6453a2467625f5d9acd0f0517098d">
- DELETE D
- FROM MyTempTable AS X
- JOIN dbo.MyTable AS D
- ON D.ThePK_ID = X.ThePK_ID
- WHERE T_ID BETWEEN @intBatchStart AND @intBatchStart + @intBatchSize </frame>
- </executionStack>
- <inputbuf>
- DECLARE @intBatchStart int, @intBatchSize int, @intRowCount int, @dtStart datetime, @strMsg nvarchar(1000)
- SET NOCOUNT ON
- SELECT @intBatchStart=MIN(T_ID), @intBatchSize=100, @intRowCount=1
- FROM MyTempTable AS X
- JOIN dbo.MyTable AS D WITH (NOLOCK)
- ON D.ThePK_ID = X.ThePK_ID
- WHILE @intRowCount >= 1
- BEGIN
- SELECT @dtStart = GetDate()
- DELETE D
- FROM MyTempTable AS X
- JOIN dbo.MyTable AS D
- ON D.ThePK_ID = X.ThePK_ID
- WHERE T_ID BETWEEN @intBatchStart AND @intBatchStart + @intBatchSize
- SELECT @intRowCount = @@ROWCOUNT, @ </inputbuf>
- </process>
- </process-list>
- <resource-list>
- <pagelock fileid="1" pageid="5538641" dbid="6" objectname="MyDatabase.dbo.MyTable" id="lock6b8edf500" mode="IX" associatedObjectId="72057594238271488">
- <owner-list>
- <owner id="process8c0ad9288" mode="IX"/>
- </owner-list>
- <waiter-list>
- <waiter id="processb292e2c8" mode="U" requestType="wait"/>
- </waiter-list>
- </pagelock>
- <pagelock fileid="1" pageid="5575207" dbid="6" objectname="MyDatabase.dbo.MyTable" id="lock62de6d300" mode="U" associatedObjectId="72057594238271488">
- <owner-list>
- <owner id="processb292e748" mode="U"/>
- </owner-list>
- <waiter-list>
- <waiter id="process8c0ad9288" mode="IX" requestType="wait"/>
- </waiter-list>
- </pagelock>
- <exchangeEvent id="Pipe9ed160e00" WaitType="e_waitPipeGetRow" nodeId="20">
- <owner-list>
- <owner id="processb292e2c8"/>
- </owner-list>
- <waiter-list>
- <waiter id="process41eb288"/>
- </waiter-list>
- </exchangeEvent>
- <exchangeEvent id="Port802d9a00" WaitType="e_waitPortOpen" nodeId="14">
- <owner-list>
- <owner id="process41eb288"/>
- </owner-list>
- <waiter-list>
- <waiter id="processb292e748"/>
- </waiter-list>
- </exchangeEvent>
- </resource-list>
- </deadlock>
- </deadlock-list>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement