September 22, 2010 at 11:24 am
I kind of understand these but this one has me confused. The insert is from replication and if I am reading this right, it has an exclusive lock on the table INC.dbo.IV00101 which is not the one the replication procedure is inserting into.
<EVENT_INSTANCE>
<EventType>DEADLOCK_GRAPH</EventType>
<PostTime>2010-09-21T20:10:15.290</PostTime>
<SPID>16</SPID>
<TextData>
<deadlock-list>
<deadlock victim="processd69c78">
<process-list>
<process id="processd69c78" taskpriority="0" logused="0" waitresource="KEY: 11:72057594112770048 (b401183b4cfb)" waittime="2039" ownerId="8842146" transactionname="SELECT INTO" lasttranstarted="2010-09-21T20:00:56.890" XDES="0x19839220" lockMode="S" schedulerid="3" kpid="4684" status="suspended" spid="67" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2010-09-21T20:00:48.117" lastbatchcompleted="2010-09-21T20:00:48.117" clientapp="Microsoft SQL Server" hostname="SV0510SQL1" hostpid="4516" loginname="COSMO\SV0510SQL1_AGENT" isolationlevel="read committed (2)" xactid="8842146" currentdb="14" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
<executionStack>
<frame procname="DataWarehouse_Live.dbo.LoadRevenueFact_Inc_GP" line="46" stmtstart="3904" stmtend="24264" sqlhandle="0x03000e00277ba35b0d66c600669d00000100000000000000">
select
cast(@Company_ID as int) as Company_ID, -- 1 = INC
dbo.GetSalesCompanyID(@Company_ID, dbo.GetSalesTeamID(@Company_ID, invd.SLSINDX,rtrim(inv.SALSTERR),rtrim(invd.ITEMNMBR))) as SalesCompany_ID,
dbo.GetPeriodID(inv.docdate) as Period_ID,
inv.docdate as InvoiceDate,
dbo.GetBusinessTypeID(dbo.GetOrderTypeID(@Company_ID, rtrim(inv.orignumb)), rtrim(invd.PRCLEVEL)) as BusType_ID, --mak 10/27/06 need to modify this for Returns
dbo.GetOrderTypeID(@Company_ID, rtrim(inv.orignumb)) as OrderType_ID, --mak 10/27/06 need to modify this for Returns
dbo.GetSaleTypeID_FromGLAcct(@Company_ID, invd.SLSINDX) as SaleType_ID,
dbo.GetRevenueTypeID(rtrim(invd.PRCLEVEL)) as RevType_ID,
cast(0 as int) as BillToRegion_ID,
cast(0 as int) as ShipToRegion_ID,
dbo.GetTerritoryID(dbo.GetSalesCompanyID(@Company_ID, (select SalesTeamID from SalesTeam where SalesTeam = rtrim(inv.SALSTERR))), rtrim(inv.SALSTERR)) as Territory_ID,
dbo.GetMarketID_FromGLAcct(@Company_ID, invd.SLSINDX) as Market_ID, </frame>
<frame procname="adhoc" line="1" stmtend="54" sqlhandle="0x01000e00bf22790ff8a3547a000000000000000000000000">
exec LoadRevenueFact_Inc_GP </frame>
</executionStack>
<inputbuf>
exec LoadRevenueFact_Inc_GP
exec LoadRevenueFact_Ltd_GP
exec LoadRevenueFact_Sarl_GP
exec LoadRevenueFact_Pty_GP
</inputbuf>
</process>
<process id="processc2fab0" taskpriority="0" logused="5808" waitresource="PAGE: 11:1:105767" waittime="336493" ownerId="8866231" transactionname="user_transaction" lasttranstarted="2010-09-21T20:04:03.673" XDES="0x729d35a0" lockMode="IX" schedulerid="2" kpid="5276" status="suspended" spid="62" sbid="0" ecid="0" priority="0" trancount="2" lastbatchstarted="2010-09-21T20:04:38.700" lastbatchcompleted="2010-09-21T20:04:03.673" clientapp="Replication Distribution Agent" hostname="SV0510SQL1" hostpid="268" loginname="COSMO\SV0510SQL1_AGENT" isolationlevel="read committed (2)" xactid="8866231" currentdb="11" lockTimeout="4294967295" clientoption1="671156320" clientoption2="128024">
<executionStack>
<frame procname="INC.dbo.sp_MSins_dboSOP10202" line="15" stmtstart="504" stmtend="1156" sqlhandle="0x03000b00f326e26d09ffb500b69d00000100000000000000">
insert into [dbo].[SOP10202](
[SOPNUMBE],
[SOPTYPE],
[CMPNTSEQ],
[LNITMSEQ],
[TRXSORCE],
[COMMENT_1],
[COMMENT_2],
[COMMENT_3],
[COMMENT_4],
[DEX_ROW_ID],
[CMMTTEXT]
) values (
@c1,
@c2,
@c3,
@c4,
@c5,
@c6,
@c7,
@c8,
@c9,
@c10,
@c11) </frame>
</executionStack>
<inputbuf>
Proc [Database Id = 11 Object Id = 1843537651] </inputbuf>
</process>
</process-list>
<resource-list>
<keylock hobtid="72057594112770048" dbid="11" objectname="INC.dbo.IV00101" indexname="PKIV00101" id="lock1ffe2a80" mode="X" associatedObjectId="72057594112770048">
<owner-list>
<owner id="processc2fab0" mode="X" />
</owner-list>
<waiter-list>
<waiter id="processd69c78" mode="S" requestType="wait" />
</waiter-list>
</keylock>
<pagelock fileid="1" pageid="105767" dbid="11" objectname="INC.dbo.SOP10202" id="lock79cf6f80" mode="S" associatedObjectId="72057594114408448">
<owner-list>
<owner id="processd69c78" mode="S" />
</owner-list>
<waiter-list>
<waiter id="processc2fab0" mode="IX" requestType="wait" />
</waiter-list>
</pagelock>
</resource-list>
</deadlock>
</deadlock-list>
</TextData>
<TransactionID />
<LoginName>sa</LoginName>
<StartTime>2010-09-21T20:10:15.257</StartTime>
<ServerName>SV0510SQL1</ServerName>
<LoginSid>AQ==</LoginSid>
<EventSequence>346253</EventSequence>
<IsSystem>1</IsSystem>
<SessionLoginName />
</EVENT_INSTANCE>
September 23, 2010 at 10:54 am
Cough, Cough
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply