<div dir="ltr"><div class="gmail_default" style="font-family:"courier new",monospace">Thank you, Tatsuo. I see what caused this error now. Seems like both databases were down, didn't noticed that.</div><div class="gmail_default" style="font-family:"courier new",monospace"><br></div><div class="gmail_default" style="font-family:"courier new",monospace"><div class="gmail_default">2018-08-10 12:13:41: pid 1393: WARNING: All the DB nodes are in down status and skip writing status file.</div><div class="gmail_default">2018-08-10 12:13:41: pid 1393: LOG: failover: no valid backends node found</div><div class="gmail_default">2018-08-10 12:13:41: pid 1393: LOG: Restart all children</div><div class="gmail_default">2018-08-10 12:13:41: pid 1393: LOG: failover: no follow backends are degenerated<br></div><div class="gmail_default">2018-08-10 12:13:41: pid 1393: LOG: failover: set new primary node: -1<br></div><div class="gmail_default">2018-08-10 12:13:42: pid 1759: DETAIL: all backend nodes are down, pgpool requires at least one valid node<br></div><div class="gmail_default">2018-08-10 12:13:42: pid 1759: HINT: repair the backend nodes and restart pgpool</div><div class="gmail_default"><br></div></div></div><br><div class="gmail_quote"><div dir="ltr">On Sat, Aug 11, 2018 at 9:20 PM Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Can you please provide the pgpool.log when failover happens?<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
<br>
> 3.6.9<br>
> <br>
> We’re planing to upgrade to 3.6.12<br>
> <br>
> On Fri, Aug 10, 2018 at 11:02 PM Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp" target="_blank">ishii@sraoss.co.jp</a>> wrote:<br>
> <br>
>> Can you please tell the exact Pgpool-II version?<br>
>><br>
>><br>
>><br>
>> Best regards,<br>
>><br>
>> --<br>
>><br>
>> Tatsuo Ishii<br>
>><br>
>> SRA OSS, Inc. Japan<br>
>><br>
>> English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
>><br>
>> Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
>><br>
>><br>
>><br>
>> > How is that possible that new master id -1?<br>
>><br>
>> > Is that a valid case?<br>
>><br>
>> ><br>
>><br>
>> > failover_command = '/etc/pgpool-II/failover.sh %d %h %p %D %m %M %H %P %r<br>
>><br>
>> > %R'<br>
>><br>
>> > # Executes this command at failover<br>
>><br>
>> > # Special values:<br>
>><br>
>> > # %d = node id<br>
>><br>
>> > # %h = host name<br>
>><br>
>> > # %p = port number<br>
>><br>
>> > # %D = database cluster path<br>
>><br>
>> > # %m = new master node id<br>
>><br>
>> > # %H = hostname of the new master node<br>
>><br>
>> > # %M = old master node id<br>
>><br>
>> > # %P = old primary node id<br>
>><br>
>> > # %r = new master port number<br>
>><br>
>> > # %R = new master database cluster path<br>
>><br>
>> > # %% = '%' character<br>
>><br>
>> ><br>
>><br>
>> > failover.sh,<br>
>><br>
>> ><br>
>><br>
>> > failed_node_id=$1<br>
>><br>
>> > failed_host=$2<br>
>><br>
>> > failed_port=$3<br>
>><br>
>> > failed_dir=$4<br>
>><br>
>> > new_master_id=$5<br>
>><br>
>> > old_master_id=$6<br>
>><br>
>> > new_master_host=$7<br>
>><br>
>> > old_primary_node_id=$8<br>
>><br>
>> > new_master_port=$9<br>
>><br>
>> > new_master_dir=${10}<br>
>><br>
>> ><br>
>><br>
>> > failover.log,<br>
>><br>
>> ><br>
>><br>
>> > [ failed node ]<br>
>><br>
>> > failed_node_id 1<br>
>><br>
>> > failed_host 192.168.20.58<br>
>><br>
>> > failed_port 5433<br>
>><br>
>> > failed_dir /opt/redsky/db/data<br>
>><br>
>> ><br>
>><br>
>> > [ before failover ]<br>
>><br>
>> > old_primary_node_id 1<br>
>><br>
>> > old_master_id 1<br>
>><br>
>> ><br>
>><br>
>> > [ after failover ]<br>
>><br>
>> > new_master_id -1<br>
>><br>
>> > new_master_host<br>
>><br>
>> > new_master_port<br>
>><br>
>> > new_master_dir<br>
>><br>
>><br>
</blockquote></div>