----- Original Message ----

> From: Jaime Casanova <jcasanov at systemguards.com.ec>
> To: slony1-general at lists.slony.info
> Sent: Monday, 17 August, 2009 16:35:01
> Subject: [slony1-general] switch from sl_log_1 to sl_log_2 never ends
> 
> Hi,
> 
> For some reason the switch from sl_log_1 to sl_log_2 never ends, if i
> execute logswitch_finish() i get this "NOTICE:  Slony-I: log switch to
> sl_log_1 still in progress - sl_log_2 not truncated" and it returns -1
> and if i execute logswitch_start() it says "ERROR:  Previous logswitch
> still in progress"
> 
> right now the sl_log_* tables have grown a lot
> relname  | n_live_tup
> -------------+--------------------
> sl_log_1 |  392275506
> sl_log_2 |   59708331
> 
> this is a situation that has been like that for several days now. this
> is slony 1.2.15...
> 


Sorry to state the obvious, but have you checked for any open transactions that it might be waiting on?