[pgpool-general: 6033] failover fails sometimes with failover: set new primary node: -1

rachel Ajebon rachel_ajebon at yahoo.com
Sat Apr 7 03:49:53 JST 2018


I am new to pgpool, I have tried setting up  3 pgpool nodes and 3 backend Postgresql databaseand 3 pgppool node  and 2 backend Postgres database.
The issue with the above 2 settings are that I sometimes get this error when performing a failover "failover: set new primary node: -1" and the failover does not occur and all databases becomes standby databases please what does the -1 stand for and what might I be doing wrong. Please let me know.

Apr  6 18:41:20 admin1 pgpool[7156]: [241-1] 2018-04-06 18:41:20: pid 7156: LOG:  find_primary_node: checking backend no 0Apr  6 18:41:20 admin1 pgpool[7156]: [242-1] 2018-04-06 18:41:20: pid 7156: LOG:  find_primary_node: checking backend no 1Apr  6 18:41:21 admin1 pgpool[7156]: [243-1] 2018-04-06 18:41:21: pid 7156: LOG:  find_primary_node: checking backend no 0Apr  6 18:41:21 admin1 pgpool[7156]: [244-1] 2018-04-06 18:41:21: pid 7156: LOG:  find_primary_node: checking backend no 1Apr  6 18:41:22 admin1 pgpool[7156]: [245-1] 2018-04-06 18:41:22: pid 7156: LOG:  find_primary_node: checking backend no 0Apr  6 18:41:22 admin1 pgpool[7156]: [246-1] 2018-04-06 18:41:22: pid 7156: LOG:  find_primary_node: checking backend no 1Apr  6 18:41:23 admin1 pgpool[7157]: [79-1] 2018-04-06 18:41:23: pid 7157: LOG:  new IPC connection receivedApr  6 18:41:23 admin1 pgpool[7157]: [80-1] 2018-04-06 18:41:23: pid 7157: LOG:  received the failover command lock request from local pgpool-II on IPC interfaceApr  6 18:41:23 admin1 pgpool[7157]: [81-1] 2018-04-06 18:41:23: pid 7157: LOG:  failover command lock request from local pgpool-II node received on IPC interface is forwarded to master watchdog node "172.28.33.10:9998 Linux config"Apr  6 18:41:23 admin1 pgpool[7157]: [81-2] 2018-04-06 18:41:23: pid 7157: DETAIL:  waiting for the reply...Apr  6 18:41:23 admin1 pgpool[7156]: [247-1] 2018-04-06 18:41:23: pid 7156: LOG:  failover: set new primary node: -1Apr  6 18:41:23 admin1 pgpool[7156]: [248-1] 2018-04-06 18:41:23: pid 7156: LOG:  failover: set new master node: 0

the second question for the first setup which is 3 pgpool nodes and 3 postgres database, how do I make the second standby sync with the master database after failover? Please let me know.
Thanks so much for your help!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180406/7913b5ce/attachment.html>


More information about the pgpool-general mailing list