| Christian Storm 2005-08-03, 8:24 pm |
| We performed one large transactional update (2.3 million rows) on our
master db yesterday
that took roughly 15 minutes to execute. Seventeen hours later it
still hasn't cleared through to
the two slave subscribers. The status for one of the subscribers is:
st_origin | 1
st_received | 3
st_last_event | 579105
st_last_event_ts | 2005-08-03 12:10:21.826932
st_last_received | 536291
st_last_received_ts | 2005-08-03 12:07:52.816493
st_last_received_eve
nt_ts | 2005-08-02 18:34:29.121862
st_lag_num_events | 42814
st_lag_time | 17:35:54.432473
After pouring over the literature I haven't been able to determine
how I can figure out where this big update stands on the slaves by
looking at the slony logs or sl_* tables. I'm trying to figure out
whether it is stalled or how much has been processed. In short, I'm
trying to figure out whether we should wait (its almost done) or just
start over and resync the subscribers.
Does anyone know how to figure this out?
We are using Slony 1.0.5 with Postgres 7.4.6.
Thanks ahead of time for any help.
Christian
|