Wed Jun 12 04:14:59 PDT 2013
- Previous message: [Slony1-general] Slony 2.2.0 beta 4 released
- Next message: [Slony1-general] Slony cleanupEvent erroring out with "server closed the connection unexpectedly" - Soln version: 2.1.2
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hello,
The slony logs are consistently posting this error:
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
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
checked and found that sl_confirm table is not cleaned up. cleanup event
never succeeds.
Additionally, the child processes terminates and restarts after each such
cleanup failure.
2013-06-11 11:20:04 GMT CONFIG slon: child terminated signal: 9; pid:
20172, current worker pid: 20172
2013-06-11 11:20:04 GMT CONFIG slon: restart of worker in 10 seconds
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
"begin;lock table "_xx_cluster".sl_config_lock;select
"_xx_cluster".cleanupEvent('10 minutes'::interval);commit;"
Soln version: 2.1.2
Any help/insight would be greatly appreciated.
Thanks,
Sridevi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20130612/aedc192b/attachment.htm
- Previous message: [Slony1-general] Slony 2.2.0 beta 4 released
- Next message: [Slony1-general] Slony cleanupEvent erroring out with "server closed the connection unexpectedly" - Soln version: 2.1.2
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list