On Feb 18, 2005, at 10:58 AM, Christopher Browne wrote:

> I would instead go to the node with empty sl_listen and do:
>
> -# select _somecluster.storelisten(2,3,2), 
> _somecluster.storelisten(3,2,3);
>
> That will add both entries on that node, and propagate the event to 
> add them everywhere else.
>

Cool.  that added the listens... but now my slon process on node2 won't 
start.  it is failing with this query:

ERROR  remoteWorkerThread_3: "begin transaction; set transaction 
isolation level
  serializable; lock table "_mailermailer".sl_config_lock; select 
"_mailermailer"
.storeListen_int(2, 1, 3); notify "_mailermailer_Event"; notify 
"_mailermailer_C
onfirm"; insert into "_mailermailer".sl_event     (ev_origin, ev_seqno, 
ev_times
tamp,      ev_minxid, ev_maxxid, ev_xip, ev_type , ev_data1, ev_data2, 
ev_data3
    ) values ('3', '2215', '2005-02-18 10:30:42.529048', '3286814', 
'3286815', ''
, 'STORE_LISTEN', '2', '1', '3'); insert into "_mailermailer".sl_confirm
(con_origin, con_received, con_seqno, con_timestamp)    values (3, 2, 
'2215', CU
RRENT_TIMESTAMP); commit transaction;" PGRES_FATAL_ERROR ERROR:  insert 
or updat
e on table "sl_listen" violates foreign key constraint 
"sl_listen-sl_path-ref"
DETAIL:  Key (li_provider,li_receiver)=(1,3) is not present in table 
"sl_path".
DEBUG1 syncThread: thread done


ie, it is attempting to insert a listen path for a node that is 
non-existent now.


Vivek Khera, Ph.D.
+1-301-869-4449 x806