August 31, 2004 at 10:10 pm
I have SQL 2000 SP3a on Windows 2000 Server replicating to SQL 2000 SP3a on Windows 2003 server. There is a combination of transactional and merge replication publications. The distributor is on the publisher.
The queue reader agent is failing. I have turned on logging, and the message I get is:
[8/31/2004 11:08:14 PM]longbchdc.distribution: select count(*) from master.dbo.sysprocesses where [program_name] = 'Queue Reader Main (distribution)'
Cannot have more than one instance of Queue reader agent for the distribution database <distribution>
Unable to connect to Local Distributor
Queue Reader aborting
There is no duplicate agent running that I can see. I can't find a reference to this anywhere. This has happened before and all I could do was tear down replication, remove replication from the server altogether, then add replication again, and rebuild the publications.
Anyone got any better ideas?
September 1, 2004 at 7:56 am
For anyone else who may run into this, I don't know what caused this for me, but to resolve it for now -- went to the Management\Current Activity\Process Info in the enterprise manager. Found the queue reader main (distribution) process, right click and kill process. Wait about a minute, then go restart the queue reader.
If anyone knows the cause so it doesn't happen again, that would be great.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply