View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000730 | Pgpool-II | Bug | public | 2021-08-20 12:28 | 2021-08-23 10:15 |
| Reporter | qx517971976 | Assigned To | pengbo | ||
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Platform | linux | OS | CentOS | OS Version | 7.4 |
| Product Version | 4.2.3 | ||||
| Summary | 0000730: postgresql Primary server down，Virtual IP cannot be switched | ||||
| Description | hello，Configure according to document：https://www.pgpool.net/docs/latest/en/html/example-cluster.html server1 is primary，server1 postgresql is down，but server1 still the leader，virtual IP is still on server 1。At this point, I can still modify and query through virtual IP。Only when I actively stop the server1 pgpool will the virtual IP switch to server2. pcp_watchdog_info -h 192.168.80.150 -p 9898 -U pgpool： 3 YES server1:9999 Linux server1 server1 server1:9999 Linux server1 server1 9999 9000 4 LEADER server2:9999 Linux server2 server2 9999 9000 7 STANDBY server3:9999 Linux server3 server3 9999 9000 7 STANDBY pgpool log no error，but ： 2021-08-20 10:59:20: pid 1125: LOG: No backend node was detached because of backend status sync from "server1:9999 Linux server1" 2021-08-20 10:59:20: pid 1125: DETAIL: no need to restart children | ||||
| Tags | No tags attached. | ||||
|
|
pgpool user and postgresql user is postgres. |
|
|
pgpool is not down, so VIP will not switch. PostgreSQL down will not automatically close pgpool? |
|
|
It is a normal behaviour. Because VIP is assigned to pgpool, VIP will switch to other pgpool only when pgpool goes down. The status of PostgreSQL doesn't affect VIP. |
|
|
ok，thanks |
|
|
I am going to close this issue. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-08-20 12:28 | qx517971976 | New Issue | |
| 2021-08-20 12:45 | qx517971976 | Note Added: 0003929 | |
| 2021-08-20 13:13 | qx517971976 | Note Added: 0003930 | |
| 2021-08-20 16:18 | pengbo | Note Added: 0003931 | |
| 2021-08-20 16:18 | pengbo | Assigned To | => pengbo |
| 2021-08-20 16:18 | pengbo | Status | new => feedback |
| 2021-08-20 16:27 | qx517971976 | Note Added: 0003932 | |
| 2021-08-20 16:27 | qx517971976 | Status | feedback => assigned |
| 2021-08-23 10:15 | pengbo | Note Added: 0003935 | |
| 2021-08-23 10:15 | pengbo | Status | assigned => closed |
