Dead lock problem

• g_theone

  SSC Veteran

  Points: 244

  More actions

  June 7, 2013 at 2:17 am

  #294916

  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?