View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000691 | Pgpool-II | Bug | public | 2021-02-15 10:39 | 2021-02-15 10:40 |
| Reporter | t-ishii | Assigned To | Muhammad Usama | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | assigned | Resolution | open | ||
| Product Version | 4.2.2 | ||||
| Summary | 0000691: Split brain problem with wathdog | ||||
| Description | If communication between 2 watchdog nodes of 3 watchdog nodes are disconnected, split brain problem occurs. | ||||
| Steps To Reproduce | $ watchdog_setup -wn 3 (pgpool0, pgpool1, pgpool2) # set wrong wd_port1 and hearbeat_port_port1 to pgpool0/pgpool.conf # set wrong wd_port0 and hearbeat_port_port0 to pgpool1/pgpool.conf # these will cut off the communication between pgpool0 and pgpool1 start whole cluster $ ./startall Sometimes (not every time) I see two leader nodes in the output of pcp_watchdog_info: t-ishii$ pcp_watchdog_info -w -p 50009 -v Watchdog Cluster Information Total Nodes : 3 Remote Nodes : 2 Quorum state : QUORUM EXIST Alive Remote Nodes : 1 VIP up on local node : NO Leader Node Name : localhost:50000 Linux tishii-CFSV7-1 Leader Host Name : localhost Watchdog Node Information Node Name : localhost:50008 Linux tishii-CFSV7-1 Host Name : localhost Delegate IP : Not_Set Pgpool port : 50008 Watchdog port : 50010 Node priority : 1 Status : 7 Status Name : STANDBY Node Name : localhost:50000 Linux tishii-CFSV7-1 Host Name : localhost Delegate IP : Not_Set Pgpool port : 50000 Watchdog port : 50002 Node priority : 3 Status : 4 Status Name : LEADER Node Name : localhost:50004 Linux tishii-CFSV7-1 Host Name : localhost Delegate IP : Not_Set Pgpool port : 50004 Watchdog port : 50006 Node priority : 2 Status : 4 Status Name : LEADER | ||||
| Additional Information | pgpool.conf and Pgpool-II logs are attached. | ||||
| Tags | No tags attached. | ||||
