[pgpool-general: 1419] Fwd: Pgpool 3.2.2 issue on AIX

[Daniele Di Vito]

Thanks for your quick reply Tatsuo,

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.
I found out that it never stops calling the exit command in  an explicit
way.

After your reply I tracked it's behaviour using truss.
Truss output is in the attched file.


Commenting the dup2 file in the demonize function, I'd been able to get
which error happens just before the process "death".

This is the error:

pool_flush_it: write failed to backend (0). reason: Socket is not connected
offset: 0 wlen: 41

it happens after the first health_check call.

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.

The real trouble is that pgppol will never check for failover or failback
loosing the main process.

The pgsql version of every backend is 8.3. I attach the pgpool config file
too.


Thanks again for your help


--

Daniele Di vito


2013/2/21 Tatsuo Ishii <ishii at postgresql.org>

> > 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130222/44dba5a7/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.out
Type: application/octet-stream
Size: 14522 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130222/44dba5a7/attachment-0002.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: main_modificato.c
Type: text/x-csrc
Size: 72834 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130222/44dba5a7/attachment-0001.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 25129 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130222/44dba5a7/attachment-0003.obj>