On Thursday 03 July 2008, "Peter Sheats" <psheats at pbpost.com> wrote:
> I have noticed that Slony is logging the same thing over  and over.  You
> can see the logs here: http://dpaste.com/60428/
>
> Also, it seems that Slony is replicating new records but not updates. 
> Could these be related?  Are those logs harmless or are they telling me
> something.
>

2008-07-02 15:54:29 EDT INFO   completed DDL script - run 
ddlScript_complete_int()
2008-07-02 15:54:31 EDT ERROR  
remoteWorkerThread_6: "notify "_dbname_replication_Event"; insert 
into "_dbname_replication".sl_event     (ev_origin, ev_seqno, ev_timestamp,      
ev_minxid, ev_maxxid, ev_xip, ev_type , ev_data1, ev_data2, ev_data3    ) 
values ('6', '14405', '2008-06-06 
14:43:59.361661', '5559800', '5559800', '', 'DDL_SCRIPT', '1', 'update 
features_address set address = ''* * CONFIDENTIAL RECORD * *'' where 
raw_address like ''* * CONFIDENTIAL%'';
    ', '-1'); insert into "_dbname_replication".sl_confirm        
(con_origin, con_received, con_seqno, con_timestamp)    values (6, 
8, '14405', now()); commit transaction;" PGRES_FATAL_ERROR ERROR:  could 
not find trigger 1649923
2008-07-02 15:54:31 EDT INFO   remoteListenThread_6: disconnecting 
from 'host=host6 dbname=dbname user=slony port=5432 password=********'


This DDL update is failing (could not find trigger 1649923). Have any tables 
on the slave been modified directly, not using EXECUTE SCRIPT?


-- 
Alan