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

Alexander Dorogensky amazinglifetime at gmail.com
Sat Aug 11 07:37:34 JST 2018


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180810/89c5e525/attachment.html>


More information about the pgpool-general mailing list