replication agent has not logged a progress message in 10 minutes

Darin

unread,

Aug 4, 2008, 12:32:24 AM8/4/08

to

SQL 2005 on windows 2003

Staring on Friday, the purblisher started receiving this error to one
subscriber (the other subscriber is fine).

I have changed the agent profile to Slow Link Agent, but that has made
no difference. THe replication monitor stays on "connecting to
subscriber subscriber1" and doesn't change.

ANy ideas about what i can do to correct this??

Darin

*** Sent via Developersdex http://www.developersdex.com ***

Darin

unread,

Aug 5, 2008, 10:46:47 AM8/5/08

to

SQL 2005 on windows 2003

Staring on Friday, the purblisher started receiving this error to one
subscriber (the other subscriber is fine).

"replication agent has not logged a progress message in 10 minutes"

Hilary Cotter

unread,

Aug 9, 2008, 8:00:38 AM8/9/08

to

There are two possibilities, the merge agent has sent a command to the
subscriber and there have been no status messages returned for over 10
minutes. This could be normal, use sp_who2 or query sysprocesses to see if
the agent is doing any io or cpu. Also check for blocking and deadlocks.

If not you have run into the second possibility which is your agent has
hung. You might have to restart sql server on the subcriber or reboot it.

You can set the threshold when sql server reports this status message by
issuing the below on your distributor.

sp_changedistributor_property, 'heartbeat_interval',600

"Darin" <darin_nospam@nospamever> wrote in message
news:ursrYse9...@TK2MSFTNGP06.phx.gbl...

Darin

unread,

Aug 10, 2008, 3:27:30 PM8/10/08

to

I ahve the heartbeat interval set to 120 and it is still erroring out.
We have rebooted both the distributor and the subscriber and that didn't
help. After rebooting the subscriber, the CPU would go to 100%, but if i
were to stop and then start the subscription from the distributor, the
subscriber's CPU doesn't go to 100%. And the distributor sits there with
the message: CONNECTING TO SUBSCRIBER 'subscriber name'.

THe activity monitor on the subscriber does not show any processes
locked.

Darin

unread,

Aug 11, 2008, 5:27:57 PM8/11/08

to

This is not making any sense.

I looked at the performance monitor for Repl. Pending Xacts and there is
over 4billion transactions - there is NO WAY that there are that many
that need to be replicated, espeically since the other subscriber only
gets about 10,000 transactions per day.

Now, if someone hit re-initialize subscription instead of hitting
stop/start, would this create numbers that are that far out there? also,
what can i do to see what transactions it says needs to be replicated
and whether these are transactions from the publisher to the subscriber
or from the subscriber to the publisher. That is really what i want to
know - which direction are these 4billion transactions going, because
both the distributor and the subscriber show 4billing pending xacts.

Help me please.

Paul Ibison

unread,

Oct 3, 2008, 11:48:15 AM10/3/08

to

I'd look at connectivity issues first of all. Ask your network guys or run
ping -t against this subscriber.
HTH,
Paul Ibison (www.replicationanswers.com)

Paul Ibison

unread,

Oct 3, 2008, 11:53:02 AM10/3/08

to

If you are talking about transactional replication, please have a look at
MSdistribution_status. Also which type of replication do you have (queued
updating, peer-to-peer etc?).
HTH,
Paul Ibison (www.replicationanswers.com)

brianwakhutu

unread,

Oct 28, 2009, 8:43:22 AM10/28/09

to

This problem, while in Replication monitor Select the publication and right click the Subsequent Subscriber Stop it and Start it again.
This should sort the problem.

Darin wrote:

replication agent has not logged a progress message in 10 minutes

05-Aug-08

Darin

Previous Posts In This Thread:

On Tuesday, August 05, 2008 10:46 AM
Darin wrote:

replication agent has not logged a progress message in 10 minutes
SQL 2005 on windows 2003

Staring on Friday, the purblisher started receiving this error to one
subscriber (the other subscriber is fine).

"replication agent has not logged a progress message in 10 minutes"

I have changed the agent profile to Slow Link Agent, but that has made
no difference. THe replication monitor stays on "connecting to
subscriber subscriber1" and doesn't change.

ANy ideas about what i can do to correct this??

Darin

*** Sent via Developersdex http://www.developersdex.com ***

On Friday, October 03, 2008 11:48 AM
Paul.Ibiso wrote:

EggHeadCafe - Software Developer Portal of Choice
Asynchronous Fire and Forget Pattern Redux
http://www.eggheadcafe.com/tutorials/aspnet/6ced07fc-a95e-4f4d-b3eb-1f5810590fca/asynchronous-fire-and-for.aspx

Hilary Cotter

unread,

Oct 28, 2009, 12:01:51 PM10/28/09

to

This just means your agent is waiting for a response from the replication
subsystem.

I normally bump this setting up to 30 minutes, however this will mean your
agents can hang for up to 30 minutes.

sp_changedistributor_property 'heartbeat_interval',30

Now, you will need to determine what your agent is doing while it is
hanging. So run the following on your publisher/distributor/subscriber

select spid from sys.sysprocesses where program_name like 'publisher_name%'

where Publisher_name is the name of your publisher server.

Then using the spids you find issue the following call

dbcc inputbuffer(spid_returned_from_above)

"Brian Wakhutu" wrote in message news:2009102884...@yahoo.com...