Cyril SCETBON wrote:

> Hi,
>
>
>
> I get the following configuration :
>
>
> select * from "_CLUSTER1".sl_subscribe;
> sub_set | sub_provider | sub_receiver | sub_forward | sub_active
> ---------+--------------+--------------+-------------+------------
>       1 |            1 |            2 | t           | t
>       1 |            1 |            3 | t           | t
>       1 |            3 |            4 | t           | t
>
>
> I used the following slonik script to make node 2 the new provider :
>
>
> CLUSTER NAME = CLUSTER1;
> NODE 1 ADMIN CONNINFO = 'dbname=dbrep host=host1 user=postgres 
> port=5433';
> NODE 2 ADMIN CONNINFO = 'dbname=dbrep host=host2 user=postgres 
> port=5434';
> NODE 3 ADMIN CONNINFO = 'dbname=dbrep host=host3 user=postgres 
> port=5435';
> NODE 4 ADMIN CONNINFO = 'dbname=dbrep host=host4 user=postgres 
> port=5436';
> LOCK SET (ID = 1, ORIGIN = 1);
> MOVE SET (ID = 1, OLD ORIGIN = 1, NEW ORIGIN = 2);
>
>
> But the new configuration is :
>
>
> select * from "_CLUSTER1".sl_subscribe;
> sub_set | sub_provider | sub_receiver | sub_forward | sub_active
> ---------+--------------+--------------+-------------+------------
>       1 |            1 |            3 | t           | t
>       1 |            3 |            4 | t           | t
>       1 |            2 |            1 | t           | t
>
>
> on nodes 1,2,3 but not on node 3 :
>
>
> select * from "_CLUSTER1".sl_subscribe;
> sub_set | sub_provider | sub_receiver | sub_forward | sub_active
> ---------+--------------+--------------+-------------+------------
>       1 |            1 |            2 | t           | t
>       1 |            1 |            3 | t           | t
>       1 |            3 |            4 | t           | t
>
>
> I was thinking that the one node 4 is displaying would be the new
> configuration.
>
>
> On node 3, I see ACCEPT_SET - MOVE_SET or FAILOVER_SET exists -
> adjusting setsync status in slon.log, while on node 4, I get ACCEPT_SET
> - MOVE_SET or FAILOVER_SET not received yet - sleep
After having test a lot it seems that event ACCEPT_SET is received on 
node 3 et 4 but not the FAILOVER_SET and they are both waiting this 
event that never come :-(
>
>
>
> Thanks for you help.
>
>