On Tuesday 14 February 2006 03:14, Robert Treat wrote:
> 3 node setup. I moved the origin of a set from svr1 to sv3, and now svr2
> doesn't appear to be updating anymore, even after issuing a subscribe set
> to specifically point svr2 to svr3.
>
> sl_status on all three nodes shows no signifigant lag_time, sl_subscribe
> shows svr2 as a reciever for svr3 and svr1 with both active. even sl_event
> seems to have timestamps relativly inline on all three machines.  the thing
> is that the count(*) on the tables and the values of the sequences are not
> updating on the svr2 machine, as if there was no updating going on.
>
> is there something else i should be looking for?  suppose i could create
> the setup on svr2 but theres a large table involved that i'd rather not
> have to resync...  anyone have pointers on jump starting svr2 again?

Have you tried killing your slons and starting them again? I've found some 
strangeness similar to what you describe in the past, and restarting slons 
straightened it out. (That was a long time ago though, in an older version of 
Slony-I) What version of Slony-I are you using? 

-- 
Tim Goodaire    416-673-4126    tgoodair at ca.afilias.info
Database Administrator, Afilias Canada Corp.