|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2008-03-03 : 14:15:32
|
| hi there got my first deadlock today.I was researching.http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx I do not see the same record being deadlock but two separate tables So im confused why it got deadlock..if not on same record. <TextData> <deadlock-list> <deadlock victim="process92ee38"> <process-list> <process id="process92ee38" taskpriority="0" logused="0" waitresource="PAGE: 62:1:65675" waittime="1968" ownerId="126815134" transactionname="SELECT" lasttranstarted="2008-03-03T12:13:23.267" XDES="0x3fc4648" lockMode="S" schedulerid="3" kpid="7936" status="suspended" spid="73" sbid="0" ecid="0" priority="0" transcount="0" lastbatchstarted="2008-03-03T12:13:23.267" lastbatchcompleted="2008-03-03T12:13:23.267" clientapp=".Net SqlClient Data Provider" hostname="SERVERNAME" hostpid="1000" loginname="LOGIN_NAME2" isolationlevel="read committed (2)" xactid="126815134" currentdb="62" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056"> <executionStack> <frame procname="MYDB_NAME.dbo.DBChangelog$getColumnLastChangedDate" line="9" stmtstart="390" stmtend="694" sqlhandle="0x03003e0012d9d35613dc4e01449a00000000000000000000">select @returnVal = max(CreatedTime) from vDBChangeLogValue v where PkTableName = @PkTableName and PkValue = @PkValue and ColumnName = @ColumnName </frame> <frame procname="adhoc" line="1" sqlhandle="0x020000005a9f290efb3b3eee5900741447ad1eb072c310a4">select workorderl0_.WOID as WOID, workorderl0_.ExpectedCompletionPendingDueAlarmDate as Expecte13_, workorderl0_.WorkOrderStatusId_Date as WorkOrde6_, workorderl0_.LastMonitoredDate as LastMoni3_, workorderl0_.WorkOrderStatusId as WorkOrd16_, workorderl0_.PolicyOverdueAlarmDate as PolicyO11_, workorderl0_.PolicyComponentId_Date as PolicyCo4_, workorderl0_.DUEDATE as DUEDATE, workorderl0_.OPENDATE as OPENDATE, workorderl0_.PolicyDueDate as PolicyD12_, workorderl0_.DUEDATE_Date as DUEDATE_5_, workorderl0_.COMPFLAG as COMPFLAG, workorderl0_.MODIDATE as MODIDATE, workorderl0_.ExpectedCompletionOverdueAlarmDate as Expecte14_, workorderl0_.CLSDDATE as CLSDDATE, workorderl0_.PolicyPendingDueAlarmDate as PolicyP10_, workorderl0_.PolicyComponentId as PolicyC17_ from vWorkOrderLifecycleState workorderl0_ where (((workorderl0_.CLSDDATE is null)or(workorderl0_.LastMonitoredDate is null)or(workorderl0_.CLSDDATE>=workorderl0_.LastMonitoredDate))and((workorderl0_.COMPFLAG is null)or(workorderl0_.COMPFLAG=''))and(workorderl0 </frame> </executionStack> <inputbuf>select workorderl0_.WOID as WOID, workorderl0_.ExpectedCompletionPendingDueAlarmDate as Expecte13_, workorderl0_.WorkOrderStatusId_Date as WorkOrde6_, workorderl0_.LastMonitoredDate as LastMoni3_, workorderl0_.WorkOrderStatusId as WorkOrd16_, workorderl0_.PolicyOverdueAlarmDate as PolicyO11_, workorderl0_.PolicyComponentId_Date as PolicyCo4_, workorderl0_.DUEDATE as DUEDATE, workorderl0_.OPENDATE as OPENDATE, workorderl0_.PolicyDueDate as PolicyD12_, workorderl0_.DUEDATE_Date as DUEDATE_5_, workorderl0_.COMPFLAG as COMPFLAG, workorderl0_.MODIDATE as MODIDATE, workorderl0_.ExpectedCompletionOverdueAlarmDate as Expecte14_, workorderl0_.CLSDDATE as CLSDDATE, workorderl0_.PolicyPendingDueAlarmDate as PolicyP10_, workorderl0_.PolicyComponentId as PolicyC17_ from vWorkOrderLifecycleState workorderl0_ where (((workorderl0_.CLSDDATE is null)or(workorderl0_.LastMonitoredDate is null)or(workorderl0_.CLSDDATE>=workorderl0_.LastMonitoredDate))and((workorderl0_.COMPFLAG is null)or(workorderl0_.COMPFLAG=''))and(workorderl </inputbuf> </process> <process id="process92f108" taskpriority="0" logused="23028" waitresource="PAGE: 62:1:76163" waittime="1968" ownerId="126816558" transactionname="user_transaction" lasttranstarted="2008-03-03T12:13:25.203" XDES="0x1242abe0" lockMode="IX" schedulerid="3" kpid="7288" status="suspended" spid="94" sbid="0" ecid="0" priority="0" transcount="2" lastbatchstarted="2008-03-03T12:13:26.140" lastbatchcompleted="2008-03-03T12:13:25.203" clientapp=".Net SqlClient Data Provider" hostname="SERVERNAME" hostpid="3308" loginname="LOGIN_NAME2" isolationlevel="read committed (2)" xactid="126816558" currentdb="62" lockTimeout="4294967295" clientoption1="673316896" clientoption2="128056"> <executionStack> <frame procname="MYDB_NAME.dbo.TASKS$AutoLog" line="1982" stmtstart="128848" stmtend="129062" sqlhandle="0x03003e00a41a895f20144f01449a00000000000000000000">update tasks set wo_num = t.WOID from tasks t, inserted i where t.woid = i.woid and i.wo_num is NULL </frame> <frame procname="adhoc" line="1" stmtstart="676" sqlhandle="0x020000002f33b02904d5344955f9b87750fab2a49deb9d52">INSERT INTO TASKS (DESCRIPT, PolicyComponentId, REQDATE, ASSNDATE, EMAILADDR, MODIDATE, MODIBY, PolicyOverdueAlarmDate, ExpectedCompletionPendingDueAlarmDate, OPENBY, PolicyDueDate, OPENDATE, PolicyPendingDueAlarmDate, DUEDATE, REQUEST, RESPONS, TASK, ExpectedCompletionOverdueAlarmDate, ATTACHCOUNT, PolicyComponentName, PRIORITY, WorkOrderTypeId, WOID) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, 0, @p21) </frame> <frame procname="unknown" line="1" sqlhandle="0x000000000000000000000000000000000000000000000000">unknown </frame> </executionStack> <inputbuf>(@p0 nvarchar(4000),@p1 int,@p2 datetime,@p3 datetime,@p4 nvarchar(4000),@p5 datetime,@p6 nvarchar(4000),@p7 datetime,@p8 datetime,@p9 nvarchar(4000),@p10 datetime,@p11 datetime,@p12 datetime,@p13 datetime,@p14 nvarchar(4000),@p15 nvarchar(4000),@p16 nvarchar(4000),@p17 datetime,@p18 int,@p19 nvarchar(4000),@p20 nvarchar(4000),@p21 int)INSERT INTO TASKS (DESCRIPT, PolicyComponentId, REQDATE, ASSNDATE, EMAILADDR, MODIDATE, MODIBY, PolicyOverdueAlarmDate, ExpectedCompletionPendingDueAlarmDate, OPENBY, PolicyDueDate, OPENDATE, PolicyPendingDueAlarmDate, DUEDATE, REQUEST, RESPONS, TASK, ExpectedCompletionOverdueAlarmDate, ATTACHCOUNT, PolicyComponentName, PRIORITY, WorkOrderTypeId, WOID) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, 0, @p21) </inputbuf> </process> </process-list> <resource-list> <pagelock fileid="1" pageid="65675" dbid="62" objectname="MYDB_NAME.dbo.DbChangeLog" id="lock441994c0" mode="IX" associatedObjectId="72057594056081408"> <owner-list> <owner id="process92f108" mode="IX" /> </owner-list> <waiter-list> <waiter id="process92ee38" mode="S" requestType="wait" /> </waiter-list> </pagelock> <pagelock fileid="1" pageid="76163" dbid="62" objectname="MYDB_NAME.dbo.TASKS" id="lock71d05700" mode="S" associatedObjectId="72057594091536384"> <owner-list> <owner id="process92ee38" mode="S" /> </owner-list> <waiter-list> <waiter id="process92f108" mode="IX" requestType="wait" /> </waiter-list> </pagelock> </resource-list> </deadlock></deadlock-list></TextData> |
|
First Deadlock