<br><div class="gmail_quote">Thanks for your quick reply Tatsuo,<br><br>Before to get your reply i tried to understand where the main process stops adding some print in the line right above every exit call in the main.c class.<br>
I found out that it never stops calling the exit command in an explicit way.<br>
<br>After your reply I tracked it's behaviour using truss.<br>Truss output is in the attched file.<br><br><br>Commenting the dup2 file in the demonize function, I'd been able to get which error happens just before the process "death".<br>
<br>This is the error:<br><br>pool_flush_it: write failed to backend (0). reason: Socket is not connected offset: 0 wlen: 41<br><br>it happens after the first health_check call. <br><br>it seems that the socket is not connected to the local backend (backend 0 is on the same host where pgpool is running) but stragely the replication on the backend 0 it work normally so I think that it's connected. <br>
<br>The real trouble is that pgppol will never check for failover or failback loosing the main process.<br><br>The pgsql version of every backend is 8.3. I attach the pgpool config file too.<br><br> <br>Thanks again for your help<br>
<br><br>--<br><br>Daniele Di vito<div class="HOEnZb"><div class="h5"><br><br><div class="gmail_quote">2013/2/21 Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div>> HI everybody, I've compiled pgpool 3.2.2 on AIX 5.2.<br>
><br>
> I configured the pool for using replication mode. The configuration is<br>
> working really fine on some linux virtual machine, but when I try to use<br>
> pgpool with the same configuration on AIX I have a big trouble.<br>
><br>
> Starting with "pgpool -d" the server seems to be starting normally. it<br>
> create pcp process and it create the pool connections waiting for<br>
> connection requests.<br>
><br>
> When I lunch a "ps -fu postgres | grep pgpool" i get this output:<br>
><br>
><br>
><br>
> postgres 62164 1 0 10:05:48 - 0:00 pgpool: wait for<br>
> connection request<br>
> postgres 75470 1 0 10:05:48 - 0:00 pgpool: PCP: wait for<br>
> connection request<br>
> postgres 84072 1 0 10:05:48 - 0:00 pgpool: wait for<br>
> connection request<br>
> postgres 96828 1 0 10:05:48 - 0:00 pgpool: wait for<br>
> connection request<br>
> postgres 100026 1 0 10:05:48 - 0:00 pgpool: wait for<br>
> connection request<br>
> postgres 106670 1 0 10:05:47 - 0:00 pgpool: wait for<br>
> connection request<br>
> postgres 109864 1 0 10:05:48 - 0:00 pgpool: worker process<br>
> postgres 116412 1 0 10:05:48 - 0:00 pgpool: wait for<br>
> connection request<br>
><br>
> but, as you can see looking at the output listed above,no pgpool daemon is<br>
> running and every subprocess created by it now have as ppid 1.<br>
><br>
> if I look into the pgpool.pid i get a pid that is not running on the AIX<br>
> machine.<br>
> Obviously if i try to stop pgpool it says that the process is not running<br>
> so i have to kill every process and to remove every temporary file manually.<br>
><br>
> If i run it without a daemon using "pgppool -n"<br>
><br>
> the pgpool -n process is listed for some minutes in the "ps -fu postgres |<br>
> grep pgpool" and every subprocess have the right ppid.<br>
> Some minutes later i get the same output I listed for the "pgpool -d"<br>
> command start.<br>
><br>
> Any idea on how to solve this trouble?<br>
><br>
> I've already tried to find some error while in debug mode, but no error<br>
> listed.<br>
<br>
</div></div>Does AIX have something like "strace" or "truss"? If so, taking a<br>
system call trace by using it, may provide valuable information. You<br>
take system call trace until pgpool-II parent process disappears.<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
</blockquote></div><br>
</div></div></div><br>