Christopher Browne cbbrowne at ca.afilias.info
Fri Oct 10 07:50:02 PDT 2008
Ow Mun Heng <Ow.Mun.Heng at wdc.com> writes:
> there's 4 days of delay now.
>
> the status says
>
>  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 |          10 |       2463535 | 2008-10-10 11:50:26.809136 |
> 2463502 | 2008-10-06 00:24:05.498648 | 2008-10-06 00:23:59.276714 |
> 33 | 4 days 11:27:59.004091
>
>
> and the table is already filled up like a 10GB in size.There definitely
> is more than 33 lag_num_events
>
> What do I do? do I need to be concerned about that number?

Generally, if *any* slon daemon dies, you need to restart it.

The concerns one should have about the life and death of slon daemons
are documented here:
  <http://www.slony.info/documentation/faq.html#AEN5771>
-- 
let name="cbbrowne" and tld="linuxfinances.info" in String.concat "@" [name;tld];;
http://linuxdatabases.info/info/lsf.html
Rules of the Evil Overlord #44. "I will only employ bounty hunters who
work for money. Those who work for the pleasure of the hunt tend to do
dumb  things like  even the  odds  to give  the other  guy a  sporting
chance." <http://www.eviloverlord.com/>


More information about the Slony1-general mailing list