http://www.slony.info/bugzilla/show_bug.cgi?id=136

           Summary: listen paths not being rebuilt correctly
           Product: Slony-I
           Version: 2.0
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: enhancement
          Priority: low
         Component: slon
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: ssinger at ca.afilias.info
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


I have a database (node 4) in my cluster that contains the following in
sl_listen, sl_set and sl_subscribe



test4=# select * FROM _disorder_replica.sl_set;
 set_id | set_origin | set_locked |                         set_comment         
--------+------------+------------+--------------------------------------------------------------
      1 |          1 |            | A replication set so boring no one thought
to give it a name
(1 row)

test4=# select * FROM _disorder_replica.sl_subscribe ;
 sub_set | sub_provider | sub_receiver | sub_forward | sub_active 
---------+--------------+--------------+-------------+------------
       1 |            1 |            2 | t           | t
       1 |            2 |            5 | t           | t
       1 |            2 |            4 | t           | t
(3 rows)

 select * FROM _disorder_replica.sl_listen where li_origin=1;
 li_origin | li_provider | li_receiver 
-----------+-------------+-------------
         1 |           1 |           2
         1 |           2 |           5
         1 |           2 |           4
(3 rows)

The remote listener_1 on node 4 are: 
 remoteListenThread_1: select ev_origin, ev_seqno, ev_timestamp,       
ev_snapshot,        "pg_catalog".txid_snapshot_xmin(ev_snapshot),       
"pg_catalog".txid_snapshot_xmax(ev_snapshot),        ev_type,        ev_data1,
ev_data2,        ev_data3, ev_data4,        ev_data5, ev_data6,       
ev_data7, ev_data8 from "_disorder_replica".sl_event e where (e.ev_origin = '5'
and e.ev_seqno > '5000000012') or (e.ev_origin = '2' and e.ev_seqno >
'5000000020') order by e.ev_origin, e.ev_seqno limit 40


The slon for node 4 is not receiving events from node 1 that have originated at
one 1.   To get in this situation my cluster is in the state:

1===>2====>4
     \\
      5
I then issue a subscribe set so node 4 and 5 will receive data directly from
node 1.

The slon for node 4 receives the 'subscribe' event via node 2 and then stops
listening on events from node 1.

-- 
Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
You are the assignee for the bug.