Thu Dec 2 14:31:56 PST 2004
- Previous message: [Slony1-general] Db replication
- Next message: [Slony1-general] Just stop'd working ...
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Db replication
- Next message: [Slony1-general] Just stop'd working ...
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list