<deadlock-list>
<deadlock victim="process176af4988">
<process-list>
<process id="process176af4988" taskpriority="0" logused="1028" waitresource="KEY: 9:72057594041663488 (266fc93ba77f)" waittime="414" ownerId="20808905" transactionname="implicit_transaction" lasttranstarted="2013-07-18T14:42:31.483" XDES="0x19115b950" lockMode="U" schedulerid="4" kpid="8736" status="suspended" spid="134" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2013-07-18T14:42:31.483" lastbatchcompleted="2013-07-18T14:42:31.480" clientapp="jTDS" hostname="CLDEV4" hostpid="123" loginname="PANS_USER" isolationlevel="read committed (2)" xactid="20808905" currentdb="9" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128058">
<executionStack>
<frame procname="CATE.dbo.pr_mergeCurrentPosition" line="24" stmtstart="1116" sqlhandle="0x03000900fd706e5bbc5df000ffa100000100000000000000">
MERGE
CATE.dbo.CURRENT_POSITION_AIS WITH (UPDLOCK) AS cpa
USING (
VALUES(@mmsiNbr)
) AS cpatemp (mmsi_nbr)
ON cpa.mmsi_nbr = cpatemp.mmsi_nbr
WHEN MATCHED THEN
UPDATE SET nav_status = @navStatus, rot = @rot, sog = @sog, pos_accuracy = @posAccuracy, lat = @lat,
lon = @lon, cog = @cog, true_heading = @trueHeading, time_stamp_sec = @timeStampSec, special_maneuver_ind = @specialManeuverInd,
raim_flag = @raimFlag, comm_state = @commState, updt_dt = @updtDt, position = @position,
imo_nbr = @imoNbr, call_sign = @callSign, vessel_name = @vesselName
WHEN NOT MATCHED THEN
INSERT (mmsi_nbr,nav_status,rot,sog,pos_accuracy,lat,lon,cog,true_heading,time_stamp_sec,special_maneuver_ind,raim_flag,comm_state,updt_dt,position,
imo_nbr, call_sign, vessel_name)
VALUES(@mmsiNbr,@navStatus,@rot,@sog,@posAccuracy,@lat,@lon,@cog,@trueHeading,@timeStampSec,@specialManeuverInd,@raimFlag,@commState,@updtDt,@position,
@imoNbr, @callSign, @vesselName)
; </frame>
</executionStack>
<inputbuf>
Proc [Database Id = 9 Object Id = 1533964541] </inputbuf>
</process>
<process id="process52dddc8" taskpriority="0" logused="29980" waitresource="KEY: 9:72057594041663488 (a8535ed1a10a)" waittime="387" ownerId="20808883" transactionname="implicit_transaction" lasttranstarted="2013-07-18T14:42:31.470" XDES="0x96688e80" lockMode="U" schedulerid="8" kpid="5256" status="suspended" spid="133" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2013-07-18T14:42:31.470" lastbatchcompleted="2013-07-18T14:42:31.460" clientapp="jTDS" hostname="CLDEV4" hostpid="123" loginname="PANS_USER" isolationlevel="read committed (2)" xactid="20808883" currentdb="9" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128058">
<executionStack>
<frame procname="CATE.dbo.pr_mergeCurrentPosition" line="24" stmtstart="1116" sqlhandle="0x03000900fd706e5bbc5df000ffa100000100000000000000">
MERGE
CATE.dbo.CURRENT_POSITION_AIS WITH (UPDLOCK) AS cpa
USING (
VALUES(@mmsiNbr)
) AS cpatemp (mmsi_nbr)
ON cpa.mmsi_nbr = cpatemp.mmsi_nbr
WHEN MATCHED THEN
UPDATE SET nav_status = @navStatus, rot = @rot, sog = @sog, pos_accuracy = @posAccuracy, lat = @lat,
lon = @lon, cog = @cog, true_heading = @trueHeading, time_stamp_sec = @timeStampSec, special_maneuver_ind = @specialManeuverInd,
raim_flag = @raimFlag, comm_state = @commState, updt_dt = @updtDt, position = @position,
imo_nbr = @imoNbr, call_sign = @callSign, vessel_name = @vesselName
WHEN NOT MATCHED THEN
INSERT (mmsi_nbr,nav_status,rot,sog,pos_accuracy,lat,lon,cog,true_heading,time_stamp_sec,special_maneuver_ind,raim_flag,comm_state,updt_dt,position,
imo_nbr, call_sign, vessel_name)
VALUES(@mmsiNbr,@navStatus,@rot,@sog,@posAccuracy,@lat,@lon,@cog,@trueHeading,@timeStampSec,@specialManeuverInd,@raimFlag,@commState,@updtDt,@position,
@imoNbr, @callSign, @vesselName)
; </frame>
</executionStack>
<inputbuf>
Proc [Database Id = 9 Object Id = 1533964541] </inputbuf>
</process>
</process-list>
<resource-list>
<keylock hobtid="72057594041663488" dbid="9" objectname="CATE.dbo.CURRENT_POSITION_AIS" indexname="CURRENT_POSITION_AIS_PK" id="locke97e7a80" mode="X" associatedObjectId="72057594041663488">
<owner-list>
<owner id="process52dddc8" mode="X"/>
</owner-list>
<waiter-list>
<waiter id="process176af4988" mode="U" requestType="wait"/>
</waiter-list>
</keylock>
<keylock hobtid="72057594041663488" dbid="9" objectname="CATE.dbo.CURRENT_POSITION_AIS" indexname="CURRENT_POSITION_AIS_PK" id="lock101f14a00" mode="X" associatedObjectId="72057594041663488">
<owner-list>
<owner id="process176af4988" mode="X"/>
</owner-list>
<waiter-list>
<waiter id="process52dddc8" mode="U" requestType="wait"/>
</waiter-list>
</keylock>
</resource-list>
</deadlock>
</deadlock-list>