'k, just risked starting slon up on neptune again, based on information 
received from a client earlier today ... the replication appears to be 
working fine to neptune, but still getting this on saturn ...

saturn (the server) hasn't been restarted in 68 days now ... and the 
postmaster not since I setup slon on the 19th ... startup of the daemon 
itself looks fine, I think ...

Dec  2 10:30:03 saturn slony_dns: CONFIG main: slon version 1.0.5 starting up 
Dec  2 10:30:03 saturn slony_dns: CONFIG main: local node id = 2 
Dec  2 10:30:03 saturn slony_dns: CONFIG main: loading current cluster configuration 
Dec  2 10:30:03 saturn slony_dns: CONFIG storeNode: no_id=1 no_comment='Node 1' 
Dec  2 10:30:03 saturn slony_dns: CONFIG storeNode: no_id=3 no_comment='Node 3' 
Dec  2 10:30:03 saturn slony_dns: CONFIG storePath: pa_server=1 pa_client=2 pa_conninfo="dbname=ams host=db.hub.org user=pgsql" pa_connretry=10 
Dec  2 10:30:03 saturn slony_dns: CONFIG storeListen: li_origin=1 li_receiver=2 li_provider=1 
Dec  2 10:30:03 saturn slony_dns: CONFIG storeSet: set_id=1 set_origin=1 set_comment='Distributed DNS Database' 
Dec  2 10:30:03 saturn slony_dns: WARN   remoteWorker_wakeup: node 1 - no worker thread 
Dec  2 10:30:03 saturn slony_dns: CONFIG storeSubscribe: sub_set=1 sub_provider=1 sub_forward='f' 
Dec  2 10:30:03 saturn slony_dns: WARN   remoteWorker_wakeup: node 1 - no worker thread 
Dec  2 10:30:03 saturn slony_dns: CONFIG enableSubscription: sub_set=1 
Dec  2 10:30:03 saturn slony_dns: WARN   remoteWorker_wakeup: node 1 - no worker thread 
Dec  2 10:30:03 saturn slony_dns: CONFIG main: configuration complete - starting threads 
Dec  2 10:30:03 saturn slony_dns: CONFIG enableNode: no_id=1 
Dec  2 10:30:03 saturn slony_dns: CONFIG enableNode: no_id=3



On Thu, 2 Dec 2004, Marc G. Fournier wrote:

>
> On the first server I setup slony on, that *was* working, I can't start slony 
> anymore, with the logs showing:
>
> Dec  2 10:30:10 saturn pgsql[79016]: [5-1] ERROR:  insert or update on table 
> "sl_subscribe" violates foreign key constraint "sl_subscribe-sl_path-ref"
> Dec  2 10:30:10 saturn pgsql[79016]: [5-2] DETAIL:  Key 
> (sub_provider,sub_receiver)=(1,3) is not present in table "sl_path".
> Dec  2 10:30:10 saturn slony_dns: ERROR  remoteWorkerThread_1: "begin 
> transaction; set transaction isolation level serializable; lock table 
> "_distributed_dns".sl_config_lock; select 
> "_distributed_dns".enableSubscription(1, 1, 3); notify 
> "_distributed_dns_Event"; notify "_distributed_dns_Confirm"; insert into 
> "_distributed_dns".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', '1658', '2004-11-21 20:17:29.661446', '32705551', 
> '32716734', '''32705551''', 'ENABLE_SUBSCRIPTION', '1', '1', '3', 'f'); 
> insert into "_distributed_dns".sl_confirm        (con_origin, con_received, 
> con_seqno, con_timestamp)    values (1, 2, '1658', CURRENT_TIMESTAMP); commit 
> transaction;" PGRES_FATAL_ERROR ERROR:  insert or update on table 
> "sl_subscribe" violates foreign key constraint "sl_subscribe-sl_path-ref" Dec 
> 2 10:30:10 saturn slony_dns: DETAIL:  Key (sub_provider,sub_receiver)=(1,3) 
> is not present in table "sl_path". Dec  2 10:30:10 saturn slony_dns: INFO 
> remoteListenThread_1: disconnecting from 'dbname=ams host=db.hub.org 
> user=pgsql' Dec  2 10:30:10 saturn pgsql[79016]: [6-1] LOG:  unexpected EOF 
> on client connection
>
> that definitely doesn't look right ... anything I can do to provide more 
> information?  suggestions on how to fix?  remove and rebuild both 
> master/subscriber? :(
>
>
> ----
> Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> Email: scrappy at hub.org           Yahoo!: yscrappy              ICQ: 7615664
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general
>

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy at hub.org           Yahoo!: yscrappy              ICQ: 7615664