Re: Deadlock between Distribution Agent and Distribution Agent Cleanup

I can't promise there is anything M$ can do about it (how often does this
occur?) but it would be great if you can post the deadlock trace here. (Or,
you can log a feedback item @ http://www.microsoft.com/connect)

-Raymond

<zerg2k@xxxxxxxxx> wrote in message
news:1166732530.463614.305580@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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

From sp_MSget_repl_commands:
select @max_xact_seqno = max(xact_seqno) from MSrepl_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



.