[pgpool-general: 3897] Re: pgpool doesn't see the new master on failover

[Muhammad Usama]

Hi

Can you please share the pgpool-II log with debug enabled.

Thanks
Best regards
Muhammad Usama


On Mon, Jul 27, 2015 at 8:18 PM, Maksym Filenko <
maksym.filenko at kreditech.com> wrote:

> Hey everyone,
>
> I've set up exactly this configuration:
> http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/en.html
>
> I have two instances of pgpool-II version 3.3.4 (tokakiboshi) in front of
> two PostgreSQL 9.4.3.
>
> I have following in my pgpool.conf:
>
> failover_command = '/var/lib/postgresql/9.4/main/failover.sh %d %P %H %R'
>
> When master goes down and failover occurs, pgpool passes nothing to
> failover.sh as the new master hostname (%H) and database cluster path (%R):
>
> $ grep 'failover' /var/log/messages
> failover_handler: no valid DB node found
> execute command: /var/lib/postgresql/9.4/main/failover.sh 0 0
> failover: set new primary node: -1
>
> If the slave fails, everything works as expected:
>
> $ grep 'failover' /var/log/messages
> execute command: /var/lib/postgresql/9.4/main/failover.sh 1 0
> db1.example.com /var/lib/postgresql/9.4/main
> failover: set new primary node: 0
> failover: set new master node: 0
>
> Looks like pgpool doesn't see the slave to promote it.
>
> Any clue would be extremely appreciated!
>
> Best regards,
> Max
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150729/80ff7a1c/attachment.html>