<div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><br></div><div>Hence, I have created a script to perform RESUBSCRIBE NODE:</div><div>
<br></div><div>Resub.sh script:</div><div><br></div><div><div>cluster name = rep220;</div><div>node 1 admin conninfo='host=localhost dbname=postgres user=postgres port=5555';</div>
<div>node 2 admin conninfo='host=localhost dbname=postgres user=postgres port=5556';</div><div>node 3 admin conninfo='host=localhost dbname=postgres user=postgres port=5557';</div><div>resubscribe node ( origin = 1, provider = 2 , receiver = 3);</div>
</div><div><br></div><div>While executing it gives me error as:</div><div><br></div><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, 2); - </div>
</div></div></blockquote><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div>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, 2) is not present in table "sl_path".</div></div></div></blockquote><div><br></div><div>Merely a blind guess, any step ( between 5556 to 5557) I missed before executing RESUBSCRIBE NODE.</div>
<div><br></div><div>--Raghav</div><div><br></div></div>