[pgpool-general: 1413] Pgpool 3.2.2 issue on AIX

[Daniele Di Vito]

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.

Thanks in advance

--
Daniele Di Vito
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130220/f3da0160/attachment.html>