[pgpool-general: 756] Re: Possible bug in the watchdog fucntionality

[Lazáro Rubén García Martínez]

Yugo thank you very much for your answer, I am configured pgpool as you say, and now It seems working, the only difference is that the watchdog checking seems running every 12 seconds, but the configuration stablish that this may be run every 10 seconds. Is this the expected behavior?

Attached is the pgpool.conf and pgpool.log files of each server.

Regards.
________________________________________
From: Yugo Nagata [nagata at sraoss.co.jp]
Sent: Wednesday, July 18, 2012 2:58 AM
To: Lazáro Rubén García Martínez
Cc: pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 753] Possible bug in the watchdog fucntionality

On Tue, 17 Jul 2012 19:14:21 -0430
Lazáro Rubén García Martínez <lgarciam at vnz.uci.cu> wrote:

> I am configured wd_interval = 10 but the wd_lifecheck_query (SELECT 1) seems not be executed in this time. Is this the expected behavior?. Attached is the pgpool.conf, postgresql.log and pgpool.log files.

In pgpool.conf, the listen_addresses value should be '*', because pgpool
accepts connections on both the real IP / hostname (specified by wd_hostname)
and the virtual IP (specified by delegate_IP).

In your configuration, the listen_addresses value is wrong, so pgpools *cannot*
monitor each other, and watchdog doesn't start successfully. The query "SELECT 1"
appearing in the log  was sent during preparation of starting alive monitoring.

>
> Another questions.
>
> Would be posible to start up pgpool with a user different of root using the watchdog functionality with a combination of sudo command?.

Yes, you can start up pgpool with watchdog functionality by using sudo command.

>
> Would be possible to start up pgpool with pgpoolAdmin tool when the wathdogfunctionality is running?

Yes, but pgpool must be started with root privilege. There are a few way.
One is to use setuid as follows;
 # chown root bin/pgpool
 # chmod 4755 bin/pgpool

Another way is to set "User" directive in httpd.conf of apache  to "root".
However, it requires to rebulid the apache server.

>
> Do you know a candidate date for releasing another version of pgpoolAdmin that supports the watchdog functionality?

The next version of pgpoolAdmin will be released in this month.

>
> Regards.
>
> ________________________________________
> From: Yugo Nagata [nagata at sraoss.co.jp]
> Sent: Monday, July 16, 2012 10:48 PM
> To: Lazáro Rubén García Martínez
> Cc: pgpool-general at pgpool.net
> Subject: Re: [pgpool-general: 743] Watchdog configuration parameters
>
> > Supose wd_interval = 10 and wd_life_point = 2
> >
> > It means pgpool sends the query "SELECT 1" to another pgpool each 10 seconds and waits for a response in 2 seconds at most. If there is not response in 2 seconds, then the watchdog process is started?
>
> No.
>
> In this case, the watchdog process sends the query "SELECT 1" to another pgpool
> every 10 seconds. If there is no response in 2 trials, then the pgpool is
> considered to be DOWN.
>
> On Mon, 16  Jul 2012 22:35:16 -0430
> Lazáro Rubén García Martínez <lgarciam at vnz.uci.cu> wrote:
>
> > Hello everyone in the list.
> >
> > I don´t understand very well the explanation about this configurations parameters related with watchdog functionality.
> >
> > wd_interval: This parameter specifies the interval between life checks of pgpool-II in second.
> >
> > wd_life_point: The times to retry a failed life check of pgpool-II.
> >
> > wd_lifecheck_query: Actual query to check pgpool-II. Default is "SELECT 1"
> >
> > Supose wd_interval = 10 and wd_life_point = 2
> >
> > It means pgpool sends the query "SELECT 1" to another pgpool each 10 seconds and waits for a response in 2 seconds at most. If there is not response in 2 seconds, then the watchdog process is started?
> >
> > 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
>
>
> --
> Yugo Nagata <nagata at sraoss.co.jp>
> SRA OSS, Inc. Japan
>
> 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


--
Yugo Nagata <nagata at sraoss.co.jp>
SRA OSS, Inc. Japan

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool_230.conf
Type: application/octet-stream
Size: 25015 bytes
Desc: pgpool_230.conf
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120718/860f6b76/attachment-0004.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool_231.conf
Type: application/octet-stream
Size: 25015 bytes
Desc: pgpool_231.conf
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120718/860f6b76/attachment-0005.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool_230.rar
Type: application/octet-stream
Size: 18560 bytes
Desc: pgpool_230.rar
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120718/860f6b76/attachment-0006.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool_231.rar
Type: application/octet-stream
Size: 17491 bytes
Desc: pgpool_231.rar
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120718/860f6b76/attachment-0007.obj>