I reported this earlier this week, and after doing some checking, Darcy 
suggested dumping the node and rebuilding it ... now the problem has 
migrated to the other subscriber :(

Dec  4 14:30:21 neptune postgres[48458]: [4-1] ERROR:  insert or update on table "sl_subscribe" violates foreign key constraint "sl_subscribe-sl_path-ref"
Dec  4 14:30:21 neptune postgres[48458]: [4-2] DETAIL:  Key (sub_provider,sub_receiver)=(1,2) is not present in table "sl_path".
Dec  4 14:30:21 neptune 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, 2); 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', '14566', '2004-12-02 18:17:00.301693', '71494598', '71494601', '''71494599'',''71494598''', 'ENABLE_SUBSCRIPTION', '1', '1', '2', 'f'); insert into "_distributed_dns".sl_confirm      (con_origin, con_received, con_seqno, con_timestamp)    values (1, 3, '14566', 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  4 14:30:21 neptune slony_dns: DETAIL:  Key (sub_provider,sub_receiver)=(1,2) is not present in table "sl_path".
Dec  4 14:30:21 neptune slony_dns: INFO   remoteListenThread_1: disconnecting from 'dbname=ams host=db.hub.org user=pgsql'
Dec  4 14:30:21 neptune postgres[48458]: [5-1] LOG:  unexpected EOF on client connection

I'm going to dump both nodes and rebuilt the whole thing ... thank god I'm 
only dealing with one table and not a multi-table database :(

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