<div dir="ltr"><div><div><div>Hello,<br><br>The slony logs are consistently posting this error:<br><br>2013-06-12 10:01:05 GMT FATAL cleanupThread: "begin;lock table "_xx_cluster".sl_config_lock;select "_xx_cluster".cleanupEvent('10 minutes'::interval);commit;" - server closed the connection unexpectedly<br>
2013-06-12 10:12:24 GMT FATAL cleanupThread: "begin;lock table "_xx_cluster".sl_config_lock;select "_xx_cluster".cleanupEvent('10 minutes'::interval);commit;" - server closed the connection unexpectedly<br>
<br></div>checked and found that sl_confirm table is not cleaned up. cleanup event never succeeds.<br>Additionally, the child processes terminates and restarts after each such cleanup failure.<br><br>2013-06-11 11:20:04 GMT CONFIG slon: child terminated signal: 9; pid: 20172, current worker pid: 20172<br>
2013-06-11 11:20:04 GMT CONFIG slon: restart of worker in 10 seconds<br><br>When cleanup is run manually, on the psql prompt it runs to completion without any issues and cleans up sl_event and sl_confirm tables<br></div>"begin;lock table "_xx_cluster".sl_config_lock;select "_xx_cluster".cleanupEvent('10 minutes'::interval);commit;"<br>
<br><div>Soln version: 2.1.2<br><br></div><div>Any help/insight would be greatly appreciated.<br></div><br>Thanks,<br></div>Sridevi<br><br></div>