Thu Jan 24 00:13:08 PST 2008
- Previous message: [Slony1-bugs] [Slony] vacuum locks all tables?
- Next message: [Slony1-bugs] [Bug 32] Once every two to three months Slony fails to commit confirms
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
http://www.slony.info/bugzilla/show_bug.cgi?id=32 Summary: Once every two to three months Slony fails to commit confirms Product: Slony-I Version: 1.2 Platform: PC OS/Version: Linux Status: NEW Severity: critical Priority: urgent Component: stored procedures AssignedTo: slony1-bugs at lists.slony.info ReportedBy: pwnell at telkomsa.net CC: slony1-bugs at lists.slony.info Estimated Hours: 0.0 Slony will run fine for weeks on our production server consisting of a 40GB PostgreSQL 8.1 DB, running Slony 1.2.9. We have one master and one slave. It usually recovers by itself over the course of a couple of days, which is unacceptable as the business is halted because of that. It typically only occurs when large amount of transactions are being generated. Here is the failure statement in the log: 008-01-24 09:47:32 SAST ERROR remoteWorkerThread_1: "notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214870', '2008-01-22 18:16:15.462066', '525065321', '525067977', '''525065602'',''525067975'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214870', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214871', '2008-01-22 18:16:25.46206', '525065321', '525068005', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214871', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214872', '2008-01-22 18:16:35.462076', '525065321', '525068029', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214872', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214873', '2008-01-22 18:16:45.462082', '525065321', '525068053', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214873', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214874', '2008-01-22 18:16:55.462066', '525065321', '525068075', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214874', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214875', '2008-01-22 18:17:04.462071', '525065321', '525068099', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214875', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214876', '2008-01-22 18:17:14.4621', '525065321', '525068123', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214876', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214877', '2008-01-22 18:17:24.462063', '525065321', '525068147', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214877', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214878', '2008-01-22 18:17:34.46207', '525065321', '525068171', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214878', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214879', '2008-01-22 18:17:44.462067', '525065321', '525068195', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214879', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214880', '2008-01-22 18:17:54.462049', '525065321', '525068226', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214880', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214881', '2008-01-22 18:18:04.461995', '525065321', '525068251', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214881', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214882', '2008-01-22 18:18:14.462071', '525065321', '525068275', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214882', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214883', '2008-01-22 18:18:24.462055', '525065321', '525068299', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214883', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214884', '2008-01-22 18:18:34.462047', '525065321', '525068323', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214884', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214885', '2008-01-22 18:18:44.462024', '525065321', '525068347', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214885', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214886', '2008-01-22 18:18:54.46206', '525065321', '525068375', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214886', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214887', '2008-01-22 18:19:04.462076', '525065321', '525068396', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214887', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214888', '2008-01-22 18:19:14.462015', '525065321', '525068421', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214888', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214889', '2008-01-22 18:19:24.462016', '525065321', '525068445', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214889', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214890', '2008-01-22 18:19:34.462019', '525065321', '525068469', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214890', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214891', '2008-01-22 18:19:44.462036', '525065321', '525068493', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214891', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214892', '2008-01-22 18:19:54.46206', '525065321', '525068527', '''525065602'',''525066844'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214892', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214893', '2008-01-22 18:20:04.46204', '525065321', '525068552', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214893', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214894', '2008-01-22 18:20:14.462028', '525065321', '525068573', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214894', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214895', '2008-01-22 18:20:23.462049', '525065321', '525068598', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214895', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214896', '2008-01-22 18:20:33.471993', '525065321', '525068622', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214896', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214897', '2008-01-22 18:20:43.472043', '525065321', '525068646', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214897', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214898', '2008-01-22 18:20:53.472036', '525065321', '525068670', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214898', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214899', '2008-01-22 18:21:03.47202', '525065321', '525068694', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214899', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214900', '2008-01-22 18:21:13.471991', '525065321', '525068715', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214900', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214901', '2008-01-22 18:21:23.472026', '525065321', '525068739', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214901', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214902', '2008-01-22 18:21:33.471998', '525065321', '525068764', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214902', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214903', '2008-01-22 18:21:42.472426', '525065321', '525068788', '''525065602'',''525068786'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214903', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214904', '2008-01-22 18:21:51.472104', '525065321', '525068821', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214904', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214905', '2008-01-22 18:22:01.472014', '525065321', '525068842', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214905', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214906', '2008-01-22 18:22:09.472504', '525065321', '525068866', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214906', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214907', '2008-01-22 18:22:19.472068', '525065321', '525068890', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214907', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214908', '2008-01-22 18:22:29.472064', '525065321', '525068914', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214908', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214909', '2008-01-22 18:22:39.472084', '525065321', '525068937', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214909', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214910', '2008-01-22 18:22:49.472099', '525065321', '525068960', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214910', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214911', '2008-01-22 18:22:59.49208', '525065321', '525068984', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214911', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214912', '2008-01-22 18:23:09.49206', '525065321', '525069008', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214912', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214913', '2008-01-22 18:23:19.492076', '525065321', '525069032', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214913', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214914', '2008-01-22 18:23:27.492054', '525065321', '525069053', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214914', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214915', '2008-01-22 18:23:37.492047', '525065321', '525069077', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214915', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214916', '2008-01-22 18:23:47.492045', '525065321', '525069101', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214916', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214917', '2008-01-22 18:23:57.492037', '525065321', '525069139', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214917', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214918', '2008-01-22 18:24:07.492085', '525065321', '525069163', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214918', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214919', '2008-01-22 18:24:17.492053', '525065321', '525069187', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214919', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214920', '2008-01-22 18:24:27.492028', '525065321', '525069211', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214920', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214921', '2008-01-22 18:24:37.492046', '525065321', '525069233', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214921', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214922', '2008-01-22 18:24:47.492076', '525065321', '525069257', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214922', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214923', '2008-01-22 18:24:57.492031', '525065321', '525069281', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214923', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214924', '2008-01-22 18:25:07.492046', '525065321', '525069305', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214924', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214925', '2008-01-22 18:25:17.492021', '525065321', '525069329', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214925', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214926', '2008-01-22 18:25:27.492072', '525065321', '525069353', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214926', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214927', '2008-01-22 18:25:37.492048', '525065321', '525069377', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214927', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214928', '2008-01-22 18:25:47.492052', '525065321', '525069399', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214928', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214929', '2008-01-22 18:25:56.49206', '525065321', '525069433', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214929', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214930', '2008-01-22 18:26:06.492057', '525065321', '525069457', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214930', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214931', '2008-01-22 18:26:15.492057', '525065321', '525069481', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214931', now()); notify "_OasisCluster_Event"; notify "_OasisCluster_Confirm"; insert into "_OasisCluster".sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type ) values ('1', '2214932', '2008-01-22 18:26:25.492055', '525065321', '525069505', '''525065602'',''525068533'',''525065321''', 'SYNC'); insert into "_OasisCluster".sl_confirm (con_origin, con_received, con_seqno, con_timestamp) values (1, 2, '2214932', now()); commit transaction;" PGRES_FATAL_ERROR could not receive data from server: Connection timed out -- Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. You are the assignee for the bug.
- Previous message: [Slony1-bugs] [Slony] vacuum locks all tables?
- Next message: [Slony1-bugs] [Bug 32] Once every two to three months Slony fails to commit confirms
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-bugs mailing list