Cyril Scetbon cscetbon.ext at orange-ftgroup.com
Tue Jan 20 07:50:17 PST 2009
My configuration is as follows :

psql db1 -c 'select * from "_CLUSTER1".sl_subscribe'
sub_set | sub_provider | sub_receiver | sub_forward | sub_active
---------+--------------+--------------+-------------+------------
     1 |            3 (M2)|            1 (M1)| t           | t
     1 |            1 (M1)|            2 (S1) | t           | t
     1 |            3 (M2)|            4 (S2) | t           | t


When I check sl_confirm using the script provided I get :

 con_origin | con_received |  minseq  |  maxseq  |   age1   |   age2   | 
tooold
------------+--------------+----------+----------+----------+----------+--------
          1 |            2 | 29365860 | 29365951 | 00:00:00 | 00:15:00 | f
          1 |            3 | 29365860 | 29365952 | 00:00:00 | 00:15:00 | f
          1 |            4 | 29365860 | 29365952 | 00:00:00 | 00:15:00 | f
          2 |            4 |   337242 |   337333 | 00:00:00 | 00:15:00 | f
          3 |            1 | 19073648 | 19074557 | 00:00:00 | 00:15:00 | f
          3 |            2 | 19073648 | 19074551 | 00:00:00 | 00:15:00 | f
          3 |            4 | 19073650 | 19074558 | 00:00:00 | 00:15:00 | f
          4 |            1 | 14353126 | 14353217 | 00:00:00 | 00:15:00 | f
          4 |            2 | 14353126 | 14353217 | 00:00:00 | 00:15:00 | f
          4 |            3 | 14353126 | 14353217 | 00:00:00 | 00:15:00 | f

psql db1 -c 'select pa_server,pa_client from "_CLUSTER1".sl_path'


  pa_server | pa_client
-----------+-----------
         1 |         4
         3 |         4
         1 |         3
         4 |         3
         3 |         1
         4 |         1
         2 |         4
         2 |         3
         2 |         1
         1 |         2
         3 |         2
         4 |         2

Do I have to worry about the fact that no event are sent from node 2 to 
nodes 1 and 3. I can see in sl_listen that all combinations of paths 
have been created. But, Why node 1 send events to node 3 and node 4 and 
node 2 does not send events to his provider ?

Regards
-- 
Cyril SCETBON
Happy New Year


More information about the Slony1-general mailing list