On 5/31/2007 9:44 AM, open wrote:
>> 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 ?

Ooops ... my fault ... I meant the column st_received. As it looks to 
me, node 6 is either not replicating, or the confirmations don't make it 
back to the origin. The origin thinks it is stuck on event 69838.


Jan


> 
> 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)
> 
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general


-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #