June 7, 2013 at 2:17 am
i am trouble shooting one dead lock problem on SQL Server 2008 R2 SP1 which is weird for me i believe it is Intra-Query Parallel Thread Deadlocks,
but i have question is this suppose that in this kind of deadlock victim is not present ?
cause when i see xml then i could not find victim-list.
another thing i extract this information from extended event health session .
here is xml
<deadlock>
<victim-list />
<process-list>
<process id="process1a167a508" taskpriority="0" logused="10000" waittime="380" schedulerid="12" kpid="41496" status="suspended" spid="75" sbid="0" ecid="90" priority="0" trancount="0" lastbatchstarted="2013-06-06T12:43:42.467" lastbatchcompleted="2013-06-06T12:43:40.923" clientapp=".Net SqlClient Data Provider" hostname="MSWEB02" hostpid="60772" isolationlevel="read committed (2)" xactid="360175586" currentdb="20" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
<executionStack>
<frame procname="" line="206" stmtstart="32758" stmtend="77810" sqlhandle="0x03001400fb3f7b6d4772f600d4a100000100000000000000" />
</executionStack>
<inputbuf />
</process>
<process id="process6a258a988" taskpriority="0" logused="10000" waittime="109" schedulerid="3" kpid="59444" status="suspended" spid="75" sbid="0" ecid="99" priority="0" trancount="0" lastbatchstarted="2013-06-06T12:43:42.467" lastbatchcompleted="2013-06-06T12:43:40.923" clientapp=".Net SqlClient Data Provider" hostname="MSWEB02" hostpid="60772" isolationlevel="read committed (2)" xactid="360175586" currentdb="20" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
<executionStack>
<frame procname="" line="206" stmtstart="32758" stmtend="77810" sqlhandle="0x03001400fb3f7b6d4772f600d4a100000100000000000000" />
</executionStack>
<inputbuf />
</process>
<process id="process189753948" taskpriority="0" logused="10000" waittime="311" schedulerid="2" kpid="58892" status="suspended" spid="75" sbid="0" ecid="86" priority="0" trancount="0" lastbatchstarted="2013-06-06T12:43:42.467" lastbatchcompleted="2013-06-06T12:43:40.923" clientapp=".Net SqlClient Data Provider" hostname="MSWEB02" hostpid="60772" isolationlevel="read committed (2)" xactid="360175586" currentdb="20" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
<executionStack>
<frame procname="" line="206" stmtstart="32758" stmtend="77810" sqlhandle="0x03001400fb3f7b6d4772f600d4a100000100000000000000" />
</executionStack>
<inputbuf />
</process>
<process id="process1a167b708" taskpriority="0" logused="10000" waittime="381" schedulerid="12" kpid="62392" status="suspended" spid="75" sbid="0" ecid="55" priority="0" trancount="0" lastbatchstarted="2013-06-06T12:43:42.467" lastbatchcompleted="2013-06-06T12:43:40.923" clientapp=".Net SqlClient Data Provider" hostname="MSWEB02" hostpid="60772" isolationlevel="read committed (2)" xactid="360175586" currentdb="20" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
<executionStack>
<frame procname="" line="206" stmtstart="32758" stmtend="77810" sqlhandle="0x03001400fb3f7b6d4772f600d4a100000100000000000000" />
</executionStack>
<inputbuf />
</process>
</process-list>
<resource-list>
<exchangeEvent id="Pipe4a9b36c70" WaitType="e_waitPipeNewRow" nodeId="22">
<owner-list>
<owner id="process1a167b708" />
</owner-list>
<waiter-list>
<waiter id="process1a167a508" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe523680ab0" WaitType="e_waitPipeNewRow" nodeId="32">
<owner-list>
<owner id="process1a167a508" />
</owner-list>
<waiter-list>
<waiter id="process6a258a988" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe6dc6ea3e0" WaitType="e_waitPipeGetRow" nodeId="32">
<owner-list>
<owner id="process6a258a988" />
</owner-list>
<waiter-list>
<waiter id="process189753948" />
</waiter-list>
</exchangeEvent>
<exchangeEvent id="Pipe52050ce30" WaitType="e_waitPipeGetRow" nodeId="22">
<owner-list>
<owner id="process189753948" />
</owner-list>
<waiter-list>
<waiter id="process1a167b708" />
</waiter-list>
</exchangeEvent>
</resource-list>
</deadlock>
We had turned trace flag 1222 globally on but i could not find information about this dead lock in sql server error log.
So my question "is this normal to have empty victim-list ?"
and if there is no victim and this deadlock does not recorded in sql server error log so should i consider dead lock?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy