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

[rachel Ajebon]

This is the pool status:

postgres=# show pool_nodes;            node_id |   hostname   | port | status | lb_weight |  role   | select_cnt | load_balance_node | replication_delay ---------+--------------+------+--------+-----------+---------+------------+-------------------+------------------- 0       | 172.28.33.10 | 5432 | up     | 0.500000  | standby | 2          | false             | 0 1       | 172.28.33.11 | 5432 | up     | 0.500000  | primary | 4          | true              | 0(2 rows)
postgres=# show pool_nodes;server closed the connection unexpectedly        This probably means the server terminated abnormally        before or while processing the request.The connection to the server was lost. Attempting reset: Succeeded.postgres=# show pool_nodes; node_id |   hostname   | port | status | lb_weight |  role   | select_cnt | load_balance_node | replication_delay ---------+--------------+------+--------+-----------+---------+------------+-------------------+------------------- 0       | 172.28.33.10 | 5432 | up     | 0.500000  | standby | 2          | true              | 0 1       | 172.28.33.11 | 5432 | down   | 0.500000  | standby | 4          | false             | 0(2 rows)
postgres=# 



    On Friday, April 6, 2018, 2:49:53 PM EDT, rachel Ajebon <rachel_ajebon at yahoo.com> wrote:  
 
 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/2298a982/attachment-0001.html>