Robert Ngo robertngo
Fri Sep 16 16:14:08 PDT 2005
Hi,

I have installed postgresql 7.4.8 from source and then install slony on 
both master and slave node. i follow the example given in 
http://gborg.postgresql.org/project/slony1/genpage.php?howto_basic

i run pgbench and start slon on both side to start the replication, 
there is error at the slavenode

ERROR  remoteWorkerThread_1: "delete from only public.history where 
"_Slony-I_slony_example_rowID"='1000000000005001';delete from only 
public.history where 
"_Slony-I_slony_example_rowID"='1000000000005002';delete from only 
public.history where 
"_Slony-I_slony_example_rowID"='1000000000005003';delete from only 
public.history where 
"_Slony-I_slony_example_rowID"='1000000000005004';delete from only 
public.history where 
"_Slony-I_slony_example_rowID"='1000000000005005';delete from only 
public.history where 
"_Slony-I_slony_example_rowID"='1000000000005006';delete from only 
public.history where 
"_Slony-I_slony_example_rowID"='1000000000005007';delete from only 
public.history where 
"_Slony-I_slony_example_rowID"='1000000000005008';delete from only 
public.history where 
"_Slony-I_slony_example_rowID"='1000000000005009';delete from only 
public.history where "_Slony-I_slony_example_rowID"='1000000000005010';" 
ERROR:  Slony-I: logTrigger() called in non-client session
 - qualification was: where log_origin = 1 and (  (
 log_tableid in (4,3,2,1)
    and (log_xid < '22068')
    and (log_xid >= '10910')
) )
ERROR  remoteWorkerThread_1: helper 1 finished with error
ERROR  remoteWorkerThread_1: SYNC aborted

why slony have problem with removing the old record?


More information about the Slony1-general mailing list