Thu May 31 06:44:26 PDT 2007
- Previous message: [Slony1-general] how can i clean sl_events?
- Next message: [Slony1-general] how can i clean sl_events?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Yes, i know about this problem, but the mission of my replication is a sync critical data to remote servers, and the soft on the remote servers work with local data. > That would only be true if all subscribers are direct subscribers that > use the origin as data provider. The problem with this setup is that > if you ever need to switchover or failover to one of the subscribers, > you will have to abandon all others (of fix the network connectivity > before doing so). > >> So now we have connect about a day, but number of event (sl_event) is >> grow.... > > Check the output of the sl_status view over a couple of minutes. If > the column st_last_event for any of your subscribers is not advancing, > the event confirmations from that node still don't make it back to the > origin and your engineer has more to fix. .....bad news, sl_status looks nornally.... st_last_event increases normally.... have you any ideas ? WBR, open. [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 | 125597 | 2007-05-31 17:34:11.315586 | 125596 | 2007-05-31 17:34:00.400391 | 2007-05-31 17:33:51.299999 | 1 | 00:00:39.454171 1 | 3 | 125597 | 2007-05-31 17:34:11.315586 | 125597 | 2007-05-31 17:34:12.837879 | 2007-05-31 17:34:11.315586 | 0 | 00:00:19.438584 1 | 6 | 125597 | 2007-05-31 17:34:11.315586 | 69838 | 2007-05-24 09:29:13.589914 | 2007-05-24 09:29:12.580015 | 55759 | 7 days 08:05:18.174155 1 | 4 | 125597 | 2007-05-31 17:34:11.315586 | 125597 | 2007-05-31 18:23:10.653676 | 2007-05-31 17:34:11.315586 | 0 | 00:00:19.438584 1 | 5 | 125597 | 2007-05-31 17:34:11.315586 | 125597 | 2007-05-31 17:33:29.585481 | 2007-05-31 17:34:11.315586 | 0 | 00:00:19.438584 (5 rows) [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 | 125598 | 2007-05-31 17:34:31.419948 | 125597 | 2007-05-31 17:34:21.424266 | 2007-05-31 17:34:11.315586 | 1 | 00:00:28.263841 1 | 3 | 125598 | 2007-05-31 17:34:31.419948 | 125597 | 2007-05-31 17:34:12.837879 | 2007-05-31 17:34:11.315586 | 1 | 00:00:28.263841 1 | 6 | 125598 | 2007-05-31 17:34:31.419948 | 69838 | 2007-05-24 09:29:13.589914 | 2007-05-24 09:29:12.580015 | 55760 | 7 days 08:05:26.9994119999 1 | 4 | 125598 | 2007-05-31 17:34:31.419948 | 125598 | 2007-05-31 18:23:31.422288 | 2007-05-31 17:34:31.419948 | 0 | 00:00:08.159479 1 | 5 | 125598 | 2007-05-31 17:34:31.419948 | 125597 | 2007-05-31 17:33:29.585481 | 2007-05-31 17:34:11.315586 | 1 | 00:00:28.263841 (5 rows) [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 | 125618 | 2007-05-31 17:41:12.190197 | 125617 | 2007-05-31 17:41:01.543596 | 2007-05-31 17:40:52.162198 | 1 | 00:00:31.501594 1 | 3 | 125618 | 2007-05-31 17:41:12.190197 | 125618 | 2007-05-31 17:41:04.928925 | 2007-05-31 17:41:12.190197 | 0 | 00:00:11.473595 1 | 6 | 125618 | 2007-05-31 17:41:12.190197 | 69838 | 2007-05-24 09:29:13.589914 | 2007-05-24 09:29:12.580015 | 55780 | 7 days 08:12:11.083777 1 | 4 | 125618 | 2007-05-31 17:41:12.190197 | 125618 | 2007-05-31 18:30:16.192276 | 2007-05-31 17:41:12.190197 | 0 | 00:00:11.473595 1 | 5 | 125618 | 2007-05-31 17:41:12.190197 | 125618 | 2007-05-31 17:40:31.441314 | 2007-05-31 17:41:12.190197 | 0 | 00:00:11.473595 (5 rows)
- Previous message: [Slony1-general] how can i clean sl_events?
- 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