[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.pgpool.net/pipermail/pgpool-general/attachments/20180810/89c5e525/attachment.htm>
More information about the pgpool-general
mailing list