Hi all, I'm getting strange behavior when testing out failover on a 1 master, 2 subscriber system.
When I run the following script: > cluster name = $CLUSTER_NAME; > > # ---- > # Admin conninfo's are used by the slonik program to connect > # to the node databases. So therse are the PQconnectdb arguments > # that connect from the administrators workstation (where > # slonik is executed). > # ---- > node 1 admin conninfo = '$MASTER_CONNINFO'; > node 2 admin conninfo = '$SLAVE1_CONNINFO'; > node 3 admin conninfo = '$SLAVE2_CONNINFO'; > > # ---- > # Switch provider from node 1 to node 2 > # ---- > > failover( id=1, backup node = 2); I get the following messages: > <stdin>:21: NOTICE: failedNode: set 1 has other direct receivers - > change providers only > <stdin>:21: NOTICE: failedNode: set 1 has other direct receivers - > change providers only Then, on the remaining machines (the ones that didn't fail), I get the following: > ith_dev=# select * from _ith_dev.sl_subscribe ; > sub_set | sub_provider | sub_receiver | sub_forward | sub_active > ---------+--------------+--------------+-------------+------------ > 1 | 3 | 2 | t | t > 1 | 2 | 3 | t | t > (2 rows) I'm not sure what to do at this point, since the two nodes subscribe to each other. Would anyone know what's going on? Thanks! --Richard _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
