Marc G. Fournier scrappy
Thu Dec 2 14:31:56 PST 2004
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


More information about the Slony1-general mailing list