all groups > sql server replication > january 2005 >
You're in the

sql server replication

group:

Queue Reader Aborting


Queue Reader Aborting Daniel Inman
1/14/2005 8:45:07 AM
sql server replication:
I am using transactional replication with queued updating. The publisher is
located in Norway, with a single subscriber in the US. The Queue Reader
Agent starts successfully, and transactions originating on either side are
properly replicated. However, the Queue Reader agent eventually shuts down
with the message "Queue Reader Aborting". When I check the session log, I
find occurrences of the error: "Server does not exist or access denied"
throughout the entire time the agent runs. Right before the agent actually
shuts down, I get the following three errors:
"Communication link failure"
"Error in caching messages from SQL Queue"
"Queue Reader Aborting"

After the queue reader fails, it does not restart automatically - it
requires manual intervention. We are aware that the connection is sporatic,
and can accept the queue building up on both sides. Is the communication
link failure a result of some threshold being reached? Can that threshold be
removed? If not, is there a way to have the queue reader agent automatically
Re: Queue Reader Aborting ed.d NO[at]SPAM osgbilling.com
1/21/2005 7:04:16 PM
Hi,

I have a replication scenario similar to yours, and my queue reader also
periodically aborts with those same messages. I don't have any insight yet
as to what causes it, but at least now you know you're not alone!

Ed


[quoted text, click to view]

AddThis Social Bookmark Button