Deadlock between Distribution Agent and Distribution Agent Cleanup
- From: zerg2k@xxxxxxxxx
- Date: 21 Dec 2006 12:22:10 -0800
I am experiencing this problem. Deadlock of these two M$ stored
procedures :
sp_MSget_repl_commands (Executed by the Distribution Agent --pull
subscriber ) and
sp_MSdistribution_cleanup (Executed by the Distribution Agent Cleanup
job)
the offending queries are :
From sp_MSdistribution_cleanup:
DELETE MSrepl_commands WITH (PAGLOCK) where
publisher_database_id = @publisher_database_id and
xact_seqno <= @max_xact_seqno
select @max_xact_seqno = max(xact_seqno) from MSrepl_commandsFrom sp_MSget_repl_commands:
(READPAST)
where
publisher_database_id = @publisher_database_id and
command_id = 1 and
type <> -2147483611
I searched this and other groups and no convincing answer was posted.
Is there anyone experiencing this problem ? if so what did you do to
"resolve" it (not to decrease its frequency)
Thanks in Advance.
-Noel
Sr. DBA
.
- Follow-Ups:
- Re: Deadlock between Distribution Agent and Distribution Agent Cleanup
- From: Raymond Mak [MSFT]
- Re: Deadlock between Distribution Agent and Distribution Agent Cleanup
- From: Kevin3NF
- Re: Deadlock between Distribution Agent and Distribution Agent Cleanup
- Prev by Date: Re: "Hidden" Replication Stored Procedures?
- Next by Date: Re: "Hidden" Replication Stored Procedures?
- Previous by thread: Re: "Hidden" Replication Stored Procedures?
- Next by thread: Re: Deadlock between Distribution Agent and Distribution Agent Cleanup
- Index(es):