[pgpool-general: 1416] Re: Pgpool 3.2.2 issue on AIX

[Tatsuo Ishii]

> HI everybody, I've compiled pgpool 3.2.2 on AIX 5.2.
> 
> I configured the pool for using replication mode. The configuration is
> working really fine on some linux virtual machine, but when I try to use
> pgpool with the same configuration on AIX I have a big trouble.
> 
> Starting with "pgpool -d" the server seems to be starting normally. it
> create pcp process and it create the pool connections waiting for
> connection requests.
> 
> When I lunch a "ps -fu postgres | grep pgpool"  i get this output:
> 
> 
> 
> postgres  62164      1   0 10:05:48      -  0:00 pgpool: wait for
> connection request
> postgres  75470      1   0 10:05:48      -  0:00 pgpool: PCP: wait for
> connection request
> postgres  84072      1   0 10:05:48      -  0:00 pgpool: wait for
> connection request
> postgres  96828      1   0 10:05:48      -  0:00 pgpool: wait for
> connection request
> postgres 100026      1   0 10:05:48      -  0:00 pgpool: wait for
> connection request
> postgres 106670      1   0 10:05:47      -  0:00 pgpool: wait for
> connection request
> postgres 109864      1   0 10:05:48      -  0:00 pgpool: worker process
> postgres 116412      1   0 10:05:48      -  0:00 pgpool: wait for
> connection request
> 
> but, as you can see looking at the output listed above,no pgpool daemon is
> running and every subprocess created by it now have as ppid 1.
> 
> if I look into the pgpool.pid i get a pid that is not running on the AIX
> machine.
> Obviously if i try to stop pgpool it says that  the process is not running
> so i have to kill every process and to remove every temporary file manually.
> 
> If i run it without a daemon using  "pgppool -n"
> 
> the pgpool -n process is listed for some minutes in the  "ps -fu postgres |
> grep pgpool" and every subprocess have the right ppid.
> Some minutes later i get the same output I listed for the "pgpool -d"
> command start.
> 
> Any idea on how to solve this trouble?
> 
> I've already tried to find some error while in debug mode, but no error
> listed.

Does AIX have something like "strace" or "truss"? If so, taking a
system call trace by using it, may provide valuable information.  You
take system call trace until pgpool-II parent process disappears.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp