Glyn Astill <glynastill at yahoo.co.uk> writes:
> Hi chaps,
>
> We have a setup with 3 nodes. Initially nodes 2 and 3 were subscribed to 1, but last night I moved the origin to 2 as per the docs.
>
> All seems to be well, but I'm confused with what the logs are showing. Node 1 has the following in it's logs for each set;
>
> remoteWorkerThread_2: syncing set 2 with 43 table(s) from provider 2
>
> But node 3 is saying this;
>
> remoteWorkerThread_2: syncing set 2 with 43 table(s) from provider 1
>
> Surely when I moved the origin from node 1 to 2, both nodes should be syncing from node 2?
>
> Anyone?

Why should this be "surely"?

The subscription chain from the old origin to the new origin is
reversed (see <http://slony.info/documentation/stmtmoveset.html>).

The subscriptions for node #3 are only revised if they are members of
the chain from the old origin to the new one.  Since [1,3] is not part
of the [1,2] chain, there is no need to do so.
-- 
(reverse (concatenate 'string "ofni.secnanifxunil" "@" "enworbbc"))
http://www3.sympatico.ca/cbbrowne/sgml.html
Rules of  the Evil  Overlord #34. "I  will not  turn into a  snake. It
never helps." <http://www.eviloverlord.com/>