On Feb 18, 2005, at 11:05 AM, Vivek Khera wrote:

>
> 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
>
Ok.. figured this out.  deleted the STORE_LISTEN event from node 3 that 
was doing this insert and all is well now.

What a scare!  now I just have a big whopper of a sync event to catch 
up... :-)