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

Thu Jul 19 06:09:27 JST 2012

Yugo I have started pgpool through pgpoolAdmin-3.2 alfa1 with watchdog functionality, however in the pgpool. log file I see this warning:

2012-07-18 11:25:29 DEBUG: pid 2510: pool_init_memory_cache: request size:67108864
2012-07-18 11:25:29 LOG:   pid 2510: pool_discard_oid_maps: discarded memqcache oid maps
2012-07-18 11:25:31 ERROR: pid 2510: wd_create_send_socket: connect() is failed(Connection refused)
2012-07-18 11:25:31 LOG:   pid 2510: wd_escalation: eslcalated to master pgpool
WARNING: interface is ignored: Operation not permitted
2012-07-18 11:25:33 DEBUG: pid 2510: wd_declare: send the packet to declare the new master
2012-07-18 11:25:33 ERROR: pid 2510: wd_create_send_socket: connect() is failed(Connection refused)
2012-07-18 11:25:33 LOG:   pid 2510: wd_escalation:  escaleted to delegate_IP holder
2012-07-18 11:25:33 LOG:   pid 2510: wd_init: start watchdog

The apache server is configured like this:

User pgpool
Group apache

Another issue. When i try to stop pgpool through pgpoolAdmin, the pgpool is stoped, however the apache server is stoped to but the apache process id exist in the machine.

Could you help my to solve this problems?

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