Home > Archive > Slony1 PostgreSQL Replication > February 2006 > replication just stopped









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author replication just stopped
Vivek Khera

2006-02-25, 9:50 am

Last weekend around 2:30am saturday, the master node slon stopped
processing events. sl_status on that node was not updating the
timestamps or event numbers. I thought it might have been some
vacuum interlocking so killed my nightly vacuum, but that didn't
clear it up, so I had to kill the slon and restart it. It took about
2 minutes to catch up once I did that at 3am (damn I hate waking up
to the pager!). There was nothing in the logs either after the 2:30
mark. The slon on the replica was still logging cleanup thread
events so it wasn't stuck.

Anyone else seen this? Server is FreeBSD 5.4. slony 1.1.5 Pg 8.0.4
on master, 8.1.2 on replica.
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com