Melvin Davidson melvin6925 at yahoo.com
Thu Jan 28 15:46:41 PST 2010
>    subscribe set ( id = 1, provider = 1, receiver = 2, forward = yes);
>    subscribe set ( id = 2, provider = 1, receiver = 2, forward = yes);
>   subscribe set ( id = 3, provider = 1, receiver = 2, forward = yes);
>
>    subscribe set ( id = 1, provider = 1, receiver = 3, forward = yes);
>    subscribe set ( id = 2, provider = 1, receiver = 3, forward = yes);
>    subscribe set ( id = 3, provider = 1, receiver = 3, forward = yes);

>    subscribe set ( id = 1, provider = 2, receiver = 4, forward = yes);

>ERROR:
><stdin>:74: PGRES_FATAL_ERROR select "_cls".subscribeSet(1, 2, 4,
>'t');  - ERROR:  Slony-I: subscribeSet(): provider 2 is not an active
>forwarding node for replication set 1

Try adding  a 
wait for event (origin = <origin_node>, confirmed = <subscriber_node>);
after _each_ of your subscribe commands.

eg:
 subscribe set ( id = 1, provider = 1, receiver = 2, forward = yes);
wait for event (origin = 1 confirmed = 2);
subscribe set ( id = 2, provider = 1, receiver = 2, forward = yes);
wait for event (origin = 1 confirmed = 2);
...
...
...
subscribe set ( id = 3, provider = 1, receiver = 3, forward = yes);

wait for event (origin = 1 confirmed = 3);

subscribe set ( id = 1, provider = 2, receiver = 4, forward = yes);



Melvin Davidson 
  





      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20100128/81501b4c/attachment.htm 


More information about the Slony1-general mailing list