Wed May 30 22:33:48 PDT 2007
- Previous message: [Slony1-general] How do I remove all traces of slony from my database?
- Next message: [Slony1-general] how can i clean sl_events?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi All :)
I'm using Slony1-1.2.9 and PostgreSQL8.0.11, and i have a problem with
sl_event,
when i setup the replication (with the slon_tools) everything be OK,
but after then, the engineer of the our partner setup firerwall, and we
have connection only from slave to master, and no connection from master
to slave....
at first look with the replication data it's OK, but after the
reconfigure firewall (when we have connection both side from slave to
master and from master to slave)
and restart slon daemon, i have such messages in LOGS on SLAVE
May 30 14:31:36 stalingrad slon_mmedia[19197]: [533-1] 2007-05-30
14:31:36 MSD [19175] ERROR remoteWorkerThread_3: "notify
"_multimedia_Event"; notify "_multimedia_Confirm"; insert
May 30 14:31:36 stalingrad slon_mmedia[19197]: [533-2] into
"_multimedia".sl_event (ev_origin, ev_seqno, ev_timestamp,
ev_minxid, ev_maxxid, ev_xip, ev_type ) values
May 30 14:31:36 stalingrad slon_mmedia[19197]: [533-3] ('3', '121342',
'2007-05-30 12:13:12.08808', '6006148', '6006154', '''6006148''',
'SYNC'); insert into "_multimedia".sl_confirm
May 30 14:31:36 stalingrad slon_mmedia[19197]: [533-4] ^I(con_origin,
con_received, con_seqno, con_timestamp) values (3, 2, '121342',
now()); notify "_multimedia_Event"; notify
May 30 14:31:36 stalingrad slon_mmedia[19197]: [533-5]
"_multimedia_Confirm"; insert into "_multimedia".sl_event
(ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid,
May 30 14:31:36 stalingrad slon_mmedia[19197]: [533-6] ev_xip,
ev_type ) values ('3', '121343', '2007-05-30 12:13:22.098347',
'6006184', '6006185', '', 'SYNC'); insert into
May 30 14:31:36 stalingrad slon_mmedia[19197]: [533-7]
"_multimedia".sl_confirm ^I(con_origin, con_received, con_seqno,
con_timestamp) values (3, 2, '121343', now()); notify
May 30 14:31:36 stalingrad slon_mmedia[19197]: [533-8]
"_multimedia_Event"; notify "_multimedia_Confirm"; insert into
"_multimedia".sl_event (ev_origin, ev_seqno, ev_timestamp,
May 30 14:31:36 stalingrad slon_mmedia[19197]: [533-9] ev_minxid,
ev_maxxid, ev_xip, ev_type ) values ('3', '121344', '2007-05-30
12:13:32.098602', '6006214', '6006227',
May 30 14:31:36 stalingrad slon_mmedia[19197]: [533-10] '''6006214''',
'SYNC'); insert into "_multimedia".sl_confirm ^I(con_origin,
con_received, con_seqno, con_timestamp) values
May 30 14:31:36 stalingrad slon_mmedia[19197]: [533-11] (3, 2,
'121344', now()); commit transaction;" PGRES_FATAL_ERROR ERROR:
duplicate key violates unique constraint
May 30 14:31:36 stalingrad slon_mmedia[19197]: [533-12] "sl_event-pkey"
May 30 14:31:36 stalingrad slon_mmedia[19194]: [534-1] 2007-05-30
14:31:36 MSD [19175] DEBUG2 remoteListenThread_1: queue event 3,121383 SYNC
I'm manually deleting 5-6 rows from sl_event on slave and data
replication OK,
BUT I HAVE ~300K rows in sl_event on master, and that not cleaning....
i see this on master logs
May 31 07:33:31 vps137 slon_mmedia[7337]: [251775-1] DEBUG3
cleanupThread: minxid: 86393132
May 31 07:33:33 vps137 slon_mmedia[7337]: [251776-1] DEBUG2
cleanupThread: 2.622 seconds for vacuuming
May 31 08:09:45 vps137 slon_mmedia[7337]: [260208-1] DEBUG3
cleanupThread: minxid: 86528109
May 31 08:09:48 vps137 slon_mmedia[7337]: [260217-1] DEBUG2
cleanupThread: 2.899 seconds for vacuuming
May 31 08:44:27 vps137 slon_mmedia[7337]: [268320-1] DEBUG3
cleanupThread: minxid: 86717718
May 31 08:44:29 vps137 slon_mmedia[7337]: [268344-1] DEBUG2
cleanupThread: 3.335 seconds for vacuuming
May 31 09:21:15 vps137 slon_mmedia[7337]: [276864-1] DEBUG3
cleanupThread: minxid: 86814805
May 31 09:21:18 vps137 slon_mmedia[7337]: [276877-1] DEBUG2
cleanupThread: 2.771 seconds for vacuuming
I'm right that cleanupThread call PL/SQL function cleanupevent() ???
I'm not understant why the number of rows in sl_event more and more, and
they not cleanup......
in view sl_status i see the huge lags....
[root at vps135 ~]# psql multimedia postgres -c "select * from
_multimedia.sl_status"
st_origin | st_received | st_last_event | st_last_event_ts |
st_last_received | st_last_received_ts |
st_last_received_event_ts | st_lag_num_events | st_lag_time
-----------+-------------+---------------+----------------------------+------------------+----------------------------+----------------------------+-------------------+------------------------
1 | 2 | 124097 | 2007-05-31 09:30:45.389851
| 124097 | 2007-05-31 09:30:53.626126 | 2007-05-31
09:30:45.389851 | 0 | 00:00:13.345121
1 | 3 | 124097 | 2007-05-31 09:30:45.389851
| 124097 | 2007-05-31 09:30:39.250211 | 2007-05-31
09:30:45.389851 | 0 | 00:00:13.345121
1 | 6 | 124097 | 2007-05-31 09:30:45.389851
| 69838 | 2007-05-24 09:29:13.589914 | 2007-05-24
09:29:12.580015 | 54259 | 7 days 00:01:46.154957
1 | 4 | 124097 | 2007-05-31 09:30:45.389851
| 124097 | 2007-05-31 10:19:44.532959 | 2007-05-31
09:30:45.389851 | 0 | 00:00:13.345121
1 | 5 | 124097 | 2007-05-31 09:30:45.389851
| 124097 | 2007-05-31 09:30:09.487824 | 2007-05-31
09:30:45.389851 | 0 | 00:00:13.345121
(5 rows)
How can i clean sl_status ???
PS sorry for my english.
thanks,
Open
- Previous message: [Slony1-general] How do I remove all traces of slony from my database?
- Next message: [Slony1-general] how can i clean sl_events?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list