<div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
As per doc, RESUBSCRIBE NODE its says we could change the provider. So,<br>
planned to move Provider to Slave1-5556 (node 2).<br>
</blockquote>
<br></div>
If you want node 3 to receive subscriptions from node 2 then there must be a direct path between node 2 and 3. Your sl_path entries don't show a path between 2->3 and 3->2.<br>
<br></blockquote><div>Got it. I should fix this before RESUBSCRIBE NODE. Thank You.</div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
> DETAIL: Key (sub_provider, sub_receiver)=(2, 2) is not present in table<br>
> "sl_path".<br>
<br></div>
Is concerning, I would have expected it to say (2,3) not (2,2). If you somehow did call resubscribeNode with the provider and receiver the same I would have expected you to see the error message : 'Slony-I: subscribeSet(): set origin and receiver cannot be identical'<br>
<br>
Are you didn't do a search/replace on node id's when pasting that message?<br>
<br></blockquote><div><br></div>Its my bad, wrong paste of error message actually, because I've duplicate scripts one I pasted above error message was from the script which includes wrong ID numbers.<div><br></div><div>
resubscribe node ( origin = 1, provider = 2 , receiver = 2);</div><div><br></div><div>Here's the correct one.</div><div><div><br></div><div><div>resubscribe node ( origin = 1, provider = 2 , receiver = 3);</div></div>
<div><br></div><div>-bash-4.1$ slonik resub_set.sh</div><div>resub_set.sh:8: PGRES_FATAL_ERROR lock table "_rep220".sl_event_lock, "_rep220".sl_config_lock;select "_rep220".resubscribeNode(1, 2, 3); - ERROR: insert or update on table "sl_subscribe" violates foreign key constraint "sl_subscribe-sl_path-ref"</div>
<div>DETAIL: Key (sub_provider, sub_receiver)=(2, 3) is not present in table "sl_path".</div><div>CONTEXT: SQL statement "update "_rep220".sl_subscribe</div><div> set sub_provider = p_sub_provider,</div>
<div> sub_forward = p_sub_forward</div><div> where sub_set = p_sub_set</div><div> and sub_receiver = p_sub_receiver"</div><div>PL/pgSQL function _rep220.subscribeset_int(integer,integer,integer,boolean,boolean) line 35 at SQL statement</div>
<div>SQL statement "SELECT "_rep220".subscribeSet_int(v_record.sub_set,</div><div> p_provider,</div><div> p_receiver, v_record.sub_forward, false)"</div>
<div>PL/pgSQL function _rep220.resubscribenode(integer,integer,integer) line 75 at PERFORM</div><div>-bash-4.1$</div><div>-bash-4.1$</div></div><div><br></div><div>I will fix this as mentioned. Thank you.</div><div><br></div>
<div>--Raghav</div></div>