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

Tatsuo Ishii ishii at sraoss.co.jp
Sat Aug 11 13:02:21 JST 2018


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