Thu Dec 2 16:27:30 PST 2004
- Previous message: [Slony1-general] Just stop'd working ...
- Next message: [Slony1-general] Slony-I Error! Please help me!Thank you!
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
'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
- Previous message: [Slony1-general] Just stop'd working ...
- Next message: [Slony1-general] Slony-I Error! Please help me!Thank you!
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list