[pgpool-general: 5064] Re: PGPOOL-II is showing incorrect status after failover

[Chris Pacejo]

Oh you better hope pgpool doesn't think node 0 is an active slave!  Or
you'll hit the bug I just did where it fails every request.

(Follow the logic in pool_read_kind() in auth/pool_auth.c when the
master is not the first active node to see what I mean.)

On Wed, Oct 19, 2016 at 4:59 AM, Veeresh Patel <veereshnitw at gmail.com> wrote:
> Hi all,
>
> I have a postgresql cluster setup (master -slave with streaming replication
> scenario).
>
> NOTE: assume master=node1
>                         slave= node2
>
> I am using pgpool in front of postgresql cluster.
> I did one failover in following way:
> 1. stopped the master node.
> 2. started the master node.
>
> So, now node2 should act as master and node 1 should act as slave, which is
> happening.And streaming replication is also working fine.
> But when I execute "show pool_nodes;"  command from pgpool, it shows the
> status of node 1 (old master) as 3, which means it is down.
>
> But when I directly connect to it, its working fine.
> For the cross check, I checked pgpool_status file and found wrong entry
> there also. Its also showing node 1 as down.
>
> Kindly tell me what could be the probable reason for this incorrect status
> information.
>
>
> Thanks & Regards
> Veeresh Patel
> SAP LAbs India Pvt. Ltd.
>
> Voice at : +91-8142164400
>
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>