Fri Oct 10 07:50:02 PDT 2008
- Previous message: [Slony1-general] Slony daemon died on master
- Next message: [Slony1-general] 1 BIG SYNC - 9million rows
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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/>
- Previous message: [Slony1-general] Slony daemon died on master
- Next message: [Slony1-general] 1 BIG SYNC - 9million rows
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list