<html><body><body bgcolor="#FFFFFF" text="#000000"><div>slon has a parent pid and a child process. On all sorts of errors the child worker will ask the parent to kill it. Chances are slon is issuing the kill signal. The question is what earlier error is causing this to happen. Yesterday or maybe the day before someone else from consistent state was asking about a similiar setup with utf8 encoding errors. Maybe this is the same or a related issue? <br/><br/>in anycase you need to find the earlier error in the slon log<br/><br/>steve<br/><br/>Grant Schaefer wrote:</div><blockquote cite="mid:CACbSrfKmyUxtR9X-rV7-T+4VW64SQcKqGeByRqMDaP87VMJ7dg@mail.gmail.com" type="cite"><div dir="ltr"><div><div><div><div>Hello - <br/><br/></div>I'm deploying Slony1-2.2.4 from a PG 9.2 instance to 9.4. All data within subscribed tables is UTF8, the subscribed node contains a firewall so that the slon daemon is not killed during its initial sync and connectivity is reliable. But I still see a repeated "server closed the connection error" during Slony's initial sync. This seems to happen randomly after an hour or two of running through the initial sync. The target database is 140 GB. I'm not exceeding SHMMAX settings. <br/><span style="font-family:arial,helvetica,sans-serif"><br/></span></div><font size="2"><span style="font-family:arial,helvetica,sans-serif">This error: "<span style="color:rgb(0,0,0)"><span>CONFIG slon: child terminated signal:
9; pid: 300, current worker pid: 300" has me wondering what is issuing kill -9 to slon daemons. Is it postgres? I know that Slony uses OS TCP keepalive settings and those are set to allow the daemon to run indefinitely.<br/><br/></span></span></span></font></div><span style="font-size:11pt;;font-family:""><font size="2"><span style="font-family:arial,helvetica,sans-serif"><span style="color:rgb(0,0,0)">Any thoughts on this?</span></span></font><br/><br/></span></div><span style="font-size:11pt;;font-family:""><span style="color:rgb(0,0,0)">Thank you.</span><br/></span></div></blockquote><div></div>
<pre class="moz-signature" cols="72">Sent Using Firefox OS</pre></body></html>