[pgpool-general: 6196] Re: New master id (%m) is -1 after failover?
Tatsuo Ishii
ishii at sraoss.co.jp
Sun Aug 12 11:20:25 JST 2018
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
>>
>>
More information about the pgpool-general
mailing list