[pgpool-general: 861] Re: Error with pgpoolAdmin-3.2

Tatsuo Ishii ishii at postgresql.org
Sun Aug 5 18:58:25 JST 2012


Did not reproduce here.
Can you reproduce the problem reliably?
If so, please use strace command as root user:

strace -p pgpool_parent_process_id

This will show which pid pgpool sends SIGINT signal to. Below is my
example:

kill(14780, SIGINT)                     = 0
kill(14781, SIGINT)                     = 0
kill(14782, SIGINT)                     = 0
kill(14783, SIGINT)                     = 0
kill(14784, SIGINT)                     = 0
kill(14785, SIGINT)                     = 0
kill(14786, SIGINT)                     = 0
kill(14787, SIGINT)                     = 0
kill(14788, SIGINT)                     = 0
kill(14789, SIGINT)                     = 0
kill(14790, SIGINT)                     = 0
:
:

The first argument is the process id and you can check if pgpool
actually sends SIGINT signal to apache process. If so, then surely
pgpool must be blamed.

Note that SIGINT is used for fast or immediate shutdown. SIGTERM is
used for smart shutdown.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> It only happens if pgpool is started from pgpoolAdmin and then stoped from pgpolAdmin.
> 
> Regards.
> ________________________________________
> From: pgpool-general-bounces at pgpool.net [pgpool-general-bounces at pgpool.net] On Behalf Of Lazáro Rubén García Martínez [lgarciam at vnz.uci.cu]
> Sent: Friday, August 03, 2012 12:34 PM
> To: pgpool-general at pgpool.net
> Subject: [pgpool-general: 856] Error with pgpoolAdmin-3.2
> 
> Hello every one in the list. I have installed pgpoolAdmin-3.2.0, but I have a problem with this.
> 
> I have installed pgpoolAdmin step by step like docs says.
> 
> The pgpool binary has been configured like this for allowing apache user to start up pgpool:
> 
> chown root /opt/pgpool/bin/pgpool
> chmod 4755 /opt/pgpool/bin/pgpool
> 
> The problem is when I try to stop pgpool through pgpoolAdmin, the pgpool service is stoped but the apache service is stoped to and when I verify the status of the httpd service, It says that the service was interrupted but exist a pid file:
> 
> /etc/init.d/httpd status
> httpd interrumpido pero existe un archivo pid
> 
> The httpd.conf is configured like this:
> 
> User apache
> Group apache
> 
> Any help for solving this problem is welcome.
> 
> Regards.
> 
> 
> 
> 
> 
> Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
> http://www.antiterroristas.cu
> http://justiciaparaloscinco.wordpress.com
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
> 
> Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
> http://www.antiterroristas.cu
> http://justiciaparaloscinco.wordpress.com
> 
> Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
> http://www.antiterroristas.cu
> http://justiciaparaloscinco.wordpress.com
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


More information about the pgpool-general mailing list