<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">> subscribe set ( id = 1, provider = 1, receiver = 2, forward = yes);<br>> subscribe set ( id = 2, provider = 1, receiver = 2, forward = yes);<br>> subscribe set ( id = 3, provider = 1, receiver = 2, forward = yes);<br>><br>> subscribe set ( id = 1, provider = 1, receiver = 3, forward = yes);<br>> subscribe set ( id = 2, provider = 1, receiver = 3, forward = yes);<br>> subscribe set ( id = 3, provider = 1, receiver = 3, forward = yes);<br><br>> subscribe set ( id = 1, provider = 2, receiver = 4, forward = yes);<br><br>>ERROR:<br>><stdin>:74: PGRES_FATAL_ERROR select "_cls".subscribeSet(1, 2, 4,<br>>'t'); - ERROR: Slony-I: subscribeSet(): provider 2 is not an active<br>>forwarding node for replication set 1<br><br>Try
adding a <br>wait for event (origin = <origin_node>, confirmed = <subscriber_node>);<br>after _each_ of your subscribe commands.<br><br>eg:<br> subscribe set ( id = 1, provider = 1, receiver = 2, forward = yes);<br>wait for event (origin = 1 confirmed = 2);<br>subscribe set ( id = 2, provider = 1, receiver = 2, forward = yes);<br>wait for event (origin = 1 confirmed = 2);<br>...<br>...<br>...<br>subscribe set ( id = 3, provider = 1, receiver = 3, forward = yes);<br>
wait for event (origin = 1 confirmed = 3);<br><br>subscribe set ( id = 1, provider = 2, receiver = 4, forward = yes);<br>
<br>
<font size="4"><span style="font-weight: bold; font-family: arial; color: rgb(0, 0, 255);">Melvin Davidson </span></font><br><div id="RTEContent"> <font size="3"> </font><font size="3"><span style="font-weight: bold; font-family: courier;"><br></span></font></div><br><br></td></tr></table><br>