<div dir="ltr"><div>Hi</div><div><br></div><div>The OS version for three servers is: CentOS Linux release 7.7.1908 (Core)</div><div>server1: 192.168.1.91</div><div>server2: 192.168.1.92</div><div>server3: 192.168.1.95</div><div>virtual IP : 192.168.1.90<br></div><div><br></div><div>the pgpool config for three servers are attached with other config files</div><div><br></div><div>also the virtual IP issue seem fixed after I changed the 24 CIDR to 32 as this if_up_cmd = '/usr/bin/sudo /sbin/ip addr add $_IP_$/<font size="4"><b>32</b></font> and fixed sudo issue in server1.( i got pgpool error
<code>sudo: sorry, you must have a tty to run sudo ) in /var/log/messages , by putting<b> <span style="color:rgb(204,0,0)">!</span> </b>in the line of sudoers file ( Defaults <span style="color:rgb(204,0,0)"><b>!</b></span>requiretty).</code></div><div><code><br></code></div><div><code>the case now still server2, server3 seems down while services are up .</code></div><div><code><br></code></div><div><div><img src="cid:ii_k6kiwvxs1" alt="image.png" width="471" height="67"><br><br></div><code></code></div><div><code>Thanks for your help and time <br></code></div><div><code><br></code></div><div><code>Best Regards<br></code>
</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Feb 13, 2020 at 7:45 AM Bo Peng <<a href="mailto:pengbo@sraoss.co.jp">pengbo@sraoss.co.jp</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi,<br>
<br>
Could you share your pgpool.conf and the OS version.<br>
<br>
On Wed, 12 Feb 2020 22:30:53 +0200<br>
Loai Abdallatif <<a href="mailto:loai.abdallatif@gmail.com" target="_blank">loai.abdallatif@gmail.com</a>> wrote:<br>
<br>
> also from postgres promt:i see only server1 up as below<br>
> <br>
> -bash-4.2$ psql -h server1 -p 9999 -U pgpool postgres -c "show pool_nodes"<br>
> node_id | hostname | port | status | lb_weight | role | select_cnt<br>
> | load_balance_node | replication_delay | replication_state |<br>
> replication_sync_state | last_s<br>
> tatus_change<br>
> ---------+--------------+------+--------+-----------+---------+------------+-------------------+-------------------+-------------------+------------------------+-------<br>
> --------------<br>
> 0 | 192.168.1.91 | 5432 | up | 0.333333 | primary | 0<br>
> | true | 0 | |<br>
> | 2020-0<br>
> 2-12 22:29:54<br>
> 1 | 192.168.1.92 | 5432 | down | 0.333333 | standby | 0<br>
> | false | 0 | |<br>
> | 2020-0<br>
> 2-12 22:28:54<br>
> 2 | 192.168.1.95 | 5432 | down | 0.333333 | standby | 0<br>
> | false | 0 | |<br>
> | 2020-0<br>
> 2-12 22:28:54<br>
> (3 rows)<br>
> <br>
> On Wed, Feb 12, 2020 at 10:27 PM Loai Abdallatif <<a href="mailto:loai.abdallatif@gmail.com" target="_blank">loai.abdallatif@gmail.com</a>><br>
> wrote:<br>
> <br>
> > Hello Peng, all<br>
> ><br>
> > I have followed the setup for pgpool on CentOS 7 as per this link<br>
> > <a href="https://www.pgpool.net/docs/latest/en/html/example-cluster.html" rel="noreferrer" target="_blank">https://www.pgpool.net/docs/latest/en/html/example-cluster.html</a>.<br>
> ><br>
> > [image: image.png]<br>
> ><br>
> > unfortunately i got virtual ip not assigned as per below image and i see<br>
> > pgpool logs in server1 ( master ) as below , and suddenly the interface<br>
> > ba1> disappear<br>
> ><br>
> ><br>
> ><br>
> > Feb 12 22:26:12 server1 pgpool[1136]: [471-1] 2020-02-12 22:26:12: pid<br>
> > 1136: LOG: get_query_result falied: status: -1<br>
> > Feb 12 22:26:12 server1 pgpool[1136]: [471-2] 2020-02-12 22:26:12: pid<br>
> > 1136: CONTEXT: while checking replication time lag<br>
> > Feb 12 22:26:12 server1 pgpool[1136]: [472-1] 2020-02-12 22:26:12: pid<br>
> > 1136: DEBUG: do_query: extended:0 query:"SELECT pg_is_in_recovery()"<br>
> > Feb 12 22:26:12 server1 pgpool[1136]: [473-1] 2020-02-12 22:26:12: pid<br>
> > 1136: DEBUG: verify_backend_node_status: there's no standby node<br>
> > Feb 12 22:26:12 server1 pgpool[1136]: [474-1] 2020-02-12 22:26:12: pid<br>
> > 1136: DEBUG: node status[0]: 1<br>
> > Feb 12 22:26:12 server1 pgpool[1136]: [475-1] 2020-02-12 22:26:12: pid<br>
> > 1136: DEBUG: node status[1]: 0<br>
> > Feb 12 22:26:12 server1 pgpool[1136]: [476-1] 2020-02-12 22:26:12: pid<br>
> > 1136: DEBUG: node status[2]: 0<br>
> > Feb 12 22:26:12 server1 pgpool[1131]: [203-1] 2020-02-12 22:26:12: pid<br>
> > 1131: DEBUG: watchdog heartbeat: send heartbeat signal to server2:9694<br>
> > Feb 12 22:26:12 server1 pgpool[1133]: [203-1] 2020-02-12 22:26:12: pid<br>
> > 1133: DEBUG: watchdog heartbeat: send heartbeat signal to server3:9694<br>
> > Feb 12 22:26:13 server1 pgpool[1132]: [203-1] 2020-02-12 22:26:13: pid<br>
> > 1132: DEBUG: received heartbeat signal from "192.168.1.92(server2):9999"<br>
> > node:server2:9999 Linux <a href="http://server2.post.ps" rel="noreferrer" target="_blank">server2.post.ps</a><br>
> ><br>
> ><br>
> > Feb 12 22:26:14 server1 pgpool[1131]: [204-1] 2020-02-12 22:26:14: pid<br>
> > 1131: DEBUG: watchdog heartbeat: send heartbeat signal to server2:9694<br>
> > Feb 12 22:26:14 server1 pgpool[1133]: [204-1] 2020-02-12 22:26:14: pid<br>
> > 1133: DEBUG: watchdog heartbeat: send heartbeat signal to server3:9694<br>
> > Feb 12 22:26:15 server1 pgpool[1132]: [204-1] 2020-02-12 22:26:15: pid<br>
> > 1132: DEBUG: received heartbeat signal from "192.168.1.92(server2):9999"<br>
> > node:server2:9999 Linux <a href="http://server2.post.ps" rel="noreferrer" target="_blank">server2.post.ps</a><br>
> > Feb 12 22:26:16 server1 pgpool[1131]: [205-1] 2020-02-12 22:26:16: pid<br>
> > 1131: DEBUG: watchdog heartbeat: send heartbeat signal to server2:9694<br>
> > Feb 12 22:26:16 server1 pgpool[1133]: [205-1] 2020-02-12 22:26:16: pid<br>
> > 1133: DEBUG: watchdog heartbeat: send heartbeat signal to server3:9694<br>
> > Feb 12 22:26:17 server1 pgpool[1090]: [767-1] 2020-02-12 22:26:17: pid<br>
> > 1090: DEBUG: STATE MACHINE INVOKED WITH EVENT = TIMEOUT Current State =<br>
> > MASTER<br>
> > Feb 12 22:26:17 server1 pgpool[1090]: [768-1] 2020-02-12 22:26:17: pid<br>
> > 1090: DEBUG: sending packet, watchdog node:[server2:9999 Linux<br>
> > <a href="http://server2.post.ps" rel="noreferrer" target="_blank">server2.post.ps</a>] command id:[50] type:[IAM COORDINATOR] state:[MASTER]<br>
> > Feb 12 22:26:17 server1 pgpool[1090]: [769-1] 2020-02-12 22:26:17: pid<br>
> > 1090: DEBUG: sending watchdog packet to socket:9, type:[M], command ID:50,<br>
> > data Length:118<br>
> > Feb 12 22:26:17 server1 pgpool[1090]: [770-1] 2020-02-12 22:26:17: pid<br>
> > 1090: DEBUG: received watchdog packet type:I<br>
> > Feb 12 22:26:17 server1 pgpool[1090]: [771-1] 2020-02-12 22:26:17: pid<br>
> > 1090: DEBUG: reading packet type I of length 330<br>
> > Feb 12 22:26:17 server1 pgpool[1090]: [772-1] 2020-02-12 22:26:17: pid<br>
> > 1090: DEBUG: STATE MACHINE INVOKED WITH EVENT = PACKET RECEIVED Current<br>
> > State = MASTER<br>
> > Feb 12 22:26:17 server1 pgpool[1090]: [773-1] 2020-02-12 22:26:17: pid<br>
> > 1090: DEBUG: received packet, watchdog node:[server2:9999 Linux<br>
> > <a href="http://server2.post.ps" rel="noreferrer" target="_blank">server2.post.ps</a>] command id:[50] type:[NODE INFO] state:[MASTER]<br>
> > Feb 12 22:26:17 server1 pgpool[1090]: [774-1] 2020-02-12 22:26:17: pid<br>
> > 1090: DEBUG: packet I with command ID 50 is reply to the command M<br>
> > Feb 12 22:26:17 server1 pgpool[1090]: [775-1] 2020-02-12 22:26:17: pid<br>
> > 1090: DEBUG: Watchdog node "server2:9999 Linux <a href="http://server2.post.ps" rel="noreferrer" target="_blank">server2.post.ps</a>" has<br>
> > replied for command id 50<br>
> > Feb 12 22:26:17 server1 pgpool[1090]: [776-1] 2020-02-12 22:26:17: pid<br>
> > 1090: DEBUG: command I with command id 50 is finished with<br>
> > COMMAND_FINISHED_ALL_REPLIED<br>
> > Feb 12 22:26:17 server1 pgpool[1090]: [777-1] 2020-02-12 22:26:17: pid<br>
> > 1090: DEBUG: STATE MACHINE INVOKED WITH EVENT = COMMAND FINISHED Current<br>
> > State = MASTER<br>
> > Feb 12 22:26:17 server1 pgpool[1090]: [778-1] 2020-02-12 22:26:17: pid<br>
> > 1090: DEBUG: I am the cluster leader node command finished with<br>
> > status:[ALL NODES REPLIED]<br>
> > Feb 12 22:26:17 server1 pgpool[1090]: [778-2] 2020-02-12 22:26:17: pid<br>
> > 1090: DETAIL: The command was sent to 1 nodes and 1 nodes replied to it<br>
> > Feb 12 22:26:17 server1 pgpool[1137]: [469-1] 2020-02-12 22:26:17: pid<br>
> > 1137: DEBUG: health check: clearing alarm<br>
> > Feb 12 22:26:17 server1 pgpool[1137]: [470-1] 2020-02-12 22:26:17: pid<br>
> > 1137: DEBUG: authenticate kind = 0<br>
> > Feb 12 22:26:17 server1 pgpool[1137]: [471-1] 2020-02-12 22:26:17: pid<br>
> > 1137: DEBUG: authenticate backend: key data received<br>
> > Feb 12 22:26:17 server1 pgpool[1137]: [472-1] 2020-02-12 22:26:17: pid<br>
> > 1137: DEBUG: authenticate backend: transaction state: I<br>
> > Feb 12 22:26:17 server1 pgpool[1137]: [473-1] 2020-02-12 22:26:17: pid<br>
> > 1137: DEBUG: health check: clearing alarm<br>
> > Feb 12 22:26:17 server1 pgpool[1137]: [474-1] 2020-02-12 22:26:17: pid<br>
> > 1137: DEBUG: health check: clearing alarm<br>
> > Feb 12 22:26:17 server1 pgpool[1132]: [205-1] 2020-02-12 22:26:17: pid<br>
> > 1132: DEBUG: received heartbeat signal from "192.168.1.92(server2):9999"<br>
> > node:server2:9999 Linux <a href="http://server2.post.ps" rel="noreferrer" target="_blank">server2.post.ps</a><br>
> ><br>
> > On Mon, Feb 10, 2020 at 10:10 AM Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>> wrote:<br>
> ><br>
> >> On Thu, 6 Feb 2020 12:39:48 +0200<br>
> >> Loai Abdallatif <<a href="mailto:loai.abdallatif@gmail.com" target="_blank">loai.abdallatif@gmail.com</a>> wrote:<br>
> >><br>
> >> > Dear Colleagues<br>
> >> ><br>
> >> > any one have a document for setup Pgpool-II's failover functionality (<br>
> >> > active-standby ) on Debian ?<br>
> >><br>
> >><br>
> >> Below is a setup example on CentOS7.<br>
> >> <a href="https://www.pgpool.net/docs/latest/en/html/example-cluster.html" rel="noreferrer" target="_blank">https://www.pgpool.net/docs/latest/en/html/example-cluster.html</a><br>
> >><br>
> >> > thanks<br>
> >><br>
> >><br>
> >> --<br>
> >> Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
> >> SRA OSS, Inc. Japan<br>
> >><br>
> ><br>
<br>
<br>
-- <br>
Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
SRA OSS, Inc. Japan<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</blockquote></div>