[pgpool-general: 2418] Re: watchdog: different statuses on different pgpool nodes.

Sergey Arlashin sergeyarl.maillist at gmail.com
Wed Jan 15 22:56:25 JST 2014


# pgpool -v
pgpool-II version 3.3.1 (tokakiboshi)


On Jan 15, 2014, at 5:26 PM, Lazaro Ruben Garcia Martinez <lgarciam at vnz.uci.cu> wrote:

> What version of pgpool are you using?
> 
> Regards.
> ________________________________________
> De: pgpool-general-bounces at pgpool.net [pgpool-general-bounces at pgpool.net] En nombre de Sergey Arlashin [sergeyarl.maillist at gmail.com]
> Enviado el: miércoles, 15 de enero de 2014 4:14
> Para: pgpool-general at pgpool.net
> Asunto: [pgpool-general: 2412] watchdog: different statuses on different        pgpool nodes.
> 
> Hi!
> 
> I'm trying set up watchdog and cannot figure out why sometimes I get different statuses on different pgpool nodes. It looks like this:
> 
> Two nodes : pgpool-node1and pgpool-node2. Watchdog mutual IP address is currently assigned to pgpool-node1.
> 
> pgpool-node1:~# psql -U postgres -h watchdog.mutual-ip -p 9999
> 
> Password for user postgres:
> psql (9.3.2)
> Type "help" for help.
> 
> postgres=# show pool_nodes;
> node_id |   hostname    | port | status | lb_weight |  role
> ---------+---------------+------+--------+-----------+---------
> 0       | db-node1.site | 5432 | 2      | 0.500000  | primary
> 1       | db-node2.site | 5432 | 2      | 0.500000  | standby
> (2 rows)
> 
> 
> 
> pgpool-node2:~# psql -U postgres -h localhost -p 9999
> Password for user postgres:
> psql (9.3.2)
> Type "help" for help.
> 
> postgres=# show pool_nodes;
> node_id |   hostname    | port | status | lb_weight |  role
> ---------+---------------+------+--------+-----------+---------
> 0       | db-node1.site | 5432 | 2      | 0.500000  | primary
> 1       | db-node2.site | 5432 | 3      | 0.500000  | standby
> (2 rows)
> 
> I cannot see any problems in pgpool logs. Or any other indication that something goes wrong.
> 
> Could you please tell me why this could happen?
> 
> 
> Thanks in advance.
> 
> --
> Best regards,
> Sergey Arlashin
> 
> 
> _______________________________________________
> 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



More information about the pgpool-general mailing list