[pgpool-general: 6196] Re: New master id (%m) is -1 after failover?

[Tatsuo Ishii]

Can you please provide the pgpool.log when failover happens?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> 3.6.9
> 
> We’re planing to upgrade to 3.6.12
> 
> On Fri, Aug 10, 2018 at 11:02 PM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> 
>> Can you please tell the exact Pgpool-II version?
>>
>>
>>
>> Best regards,
>>
>> --
>>
>> Tatsuo Ishii
>>
>> SRA OSS, Inc. Japan
>>
>> English: http://www.sraoss.co.jp/index_en.php
>>
>> Japanese:http://www.sraoss.co.jp
>>
>>
>>
>> > How is that possible that new master id -1?
>>
>> > Is that a valid case?
>>
>> >
>>
>> > failover_command = '/etc/pgpool-II/failover.sh %d %h %p %D %m %M %H %P %r
>>
>> > %R'
>>
>> > # Executes this command at failover
>>
>> > # Special values:
>>
>> > #   %d = node id
>>
>> > #   %h = host name
>>
>> > #   %p = port number
>>
>> > #   %D = database cluster path
>>
>> > #   %m = new master node id
>>
>> > #   %H = hostname of the new master node
>>
>> > #   %M = old master node id
>>
>> > #   %P = old primary node id
>>
>> > #   %r = new master port number
>>
>> > #   %R = new master database cluster path
>>
>> > #   %% = '%' character
>>
>> >
>>
>> > failover.sh,
>>
>> >
>>
>> > failed_node_id=$1
>>
>> > failed_host=$2
>>
>> > failed_port=$3
>>
>> > failed_dir=$4
>>
>> > new_master_id=$5
>>
>> > old_master_id=$6
>>
>> > new_master_host=$7
>>
>> > old_primary_node_id=$8
>>
>> > new_master_port=$9
>>
>> > new_master_dir=${10}
>>
>> >
>>
>> > failover.log,
>>
>> >
>>
>> > [ failed node ]
>>
>> > failed_node_id         1
>>
>> > failed_host            192.168.20.58
>>
>> > failed_port            5433
>>
>> > failed_dir             /opt/redsky/db/data
>>
>> >
>>
>> > [ before failover ]
>>
>> > old_primary_node_id    1
>>
>> > old_master_id          1
>>
>> >
>>
>> > [ after failover ]
>>
>> > new_master_id          -1
>>
>> > new_master_host
>>
>> > new_master_port
>>
>> > new_master_dir
>>
>>