I need a help with a three-node slony 1.0.5 setup, where one of the two
slave slon-daemons fails with an error. The setup is that 9mcons001
is a master host, and 8kdb001 is one of two slaves. The strange sting is
that slon on the other slave host runs o.k., and the both slaves have
identical configuration. Any ideas? 


mail8kdb001:~ # slon newsmtp 'dbname=newsmtp user=postgres host=8kdb001'
CONFIG main: slon version 1.0.5 starting up
CONFIG main: local node id = 4
CONFIG main: loading current cluster configuration
CONFIG storeNode: no_id=1 no_comment='Master Node'
CONFIG storeNode: no_id=2 no_comment='Slave node'
CONFIG storePath: pa_server=1 pa_client=4 pa_conninfo="dbname=newsmtp
host=9mcons001 user=postgres" pa_connretry=10
CONFIG storeListen: li_origin=1 li_receiver=4 li_provider=1
CONFIG storeSet: set_id=1 set_origin=1 set_comment='All newsmtp replication
tables'
WARN   remoteWorker_wakeup: node 1 - no worker thread
CONFIG main: configuration complete - starting threads
CONFIG enableNode: no_id=1
CONFIG enableNode: no_id=2
ERROR  remoteWorkerThread_1: "begin transaction; set transaction isolation
level serializable; lock table "_newsmtp".sl_config_lock; select
"_newsmtp".enableSubscription(1, 1, 2); notify "_newsmtp_Event"; notify
"_newsmtp_Confirm"; insert into "_newsmtp".sl_event     (ev_origin,
ev_seqno, ev_timestamp,      ev_minxid, ev_maxxid, ev_xip, ev_type ,
ev_data1, ev_data2, ev_data3, ev_data4    ) values ('1', '17', '2005-05-23
11:39:58.652283', '203665', '203666', '', 'ENABLE_SUBSCRIPTION', '1', '1',
'2', 'f'); insert into "_newsmtp".sl_confirm   (con_origin, con_received,
con_seqno, con_timestamp)    values (1, 4, '17', CURRENT_TIMESTAMP); commit
transaction;" PGRES_FATAL_ERROR ERROR:  insert or update on table
"sl_subscribe" violates foreign key constraint "sl_subscribe-sl_path-ref"
DETAIL:  Key (sub_provider,sub_receiver)=(1,2) is not present in table
"sl_path".
CONTEXT:  SQL statement "insert into "_newsmtp".sl_subscribe (sub_set,
sub_provider, sub_receiver, sub_forward, sub_active) values ( $1 ,  $2 ,
$3 , false, true)"
PL/pgSQL function "enablesubscription_int" line 22 at SQL statement
PL/pgSQL function "enablesubscription" line 6 at return
INFO   remoteListenThread_1: disconnecting from 'dbname=newsmtp
host=9mcons001 user=postgres'


-- 
Sincerely,
	Dmitry Karasik