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

[Maksym Filenko]

Hey Muhammad,

thank you for your reply!

Please, find gzipped logs attached below. pgpool-1 is for master, pgpool-2
is for standby. Master Postgres node was shutted down at 18:01:01. You can
see a failover.sh call with insufficient parameters. It should be something
like '/srv/pgsql/bin/failover.sh 0 db2.tx.dev.mydomain' (new master
hostname).

Again, thank you!

On Wed, Jul 29, 2015 at 10:53 AM, Muhammad Usama <m.usama at gmail.com> wrote:

> 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/875a84bb/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool-1.log.gz
Type: application/x-gzip
Size: 7280 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150729/875a84bb/attachment-0002.gz>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool-2.log.gz
Type: application/x-gzip
Size: 7102 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150729/875a84bb/attachment-0003.gz>