>
> As per doc, RESUBSCRIBE NODE its says we could change the provider. So,
>> planned to move Provider to Slave1-5556 (node 2).
>>
>
> 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.
>
> Got it. I should fix this before RESUBSCRIBE NODE. Thank You.



> > DETAIL:  Key (sub_provider, sub_receiver)=(2, 2) is not present in table
> > "sl_path".
>
> 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'
>
> Are you didn't do a search/replace on node id's when pasting that message?
>
>
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.

resubscribe node ( origin = 1, provider = 2 , receiver = 2);

Here's the correct one.

resubscribe node ( origin = 1, provider = 2 , receiver = 3);

-bash-4.1$ slonik resub_set.sh
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"
DETAIL:  Key (sub_provider, sub_receiver)=(2, 3) is not present in table
"sl_path".
CONTEXT:  SQL statement "update "_rep220".sl_subscribe
                        set sub_provider = p_sub_provider,
                                sub_forward = p_sub_forward
                        where sub_set = p_sub_set
                        and sub_receiver = p_sub_receiver"
PL/pgSQL function
_rep220.subscribeset_int(integer,integer,integer,boolean,boolean) line 35
at SQL statement
SQL statement "SELECT "_rep220".subscribeSet_int(v_record.sub_set,
                                p_provider,
                                p_receiver, v_record.sub_forward, false)"
PL/pgSQL function _rep220.resubscribenode(integer,integer,integer) line 75
at PERFORM
-bash-4.1$
-bash-4.1$

I will fix this as mentioned. Thank you.

--Raghav
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20130705/b5d9e3b3/attachment.htm