View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000684 | Pgpool-II | Bug | public | 2021-01-15 11:06 | 2023-04-14 14:42 |
| Reporter | pengbo | Assigned To | Muhammad Usama | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 4.1.5 | ||||
| Target Version | 4.1.8 | Fixed in Version | 4.1.8 | ||
| Summary | 0000684: The standby status of pcp_watchdog_info isn't changed from "LOADING", after rebooting a standby server. | ||||
| Description | This issue can be reproduced in pgpool 4.1 and 4.2. Reproduction steps: 1) 3 pgpool nodes (pgpool1, pgpool2, pgpool3) are started 2) reboot server of pgpool3 3) pcp_watchdog_info of pgpool1 shows the state of pgpool3 is "STANDBY", but pcp_watchdog_info of pgpool2 shows the state of pgpool3 "LOADING" # pcp_watchdog_info -w -h pgpool1 -U postgres -p 9898 3 YES pgpool1:9999 Linux pgpool1 pgpool1 pgpool1:9999 Linux pgpool1 pgpool1 9999 9000 4 MASTER pgpool2:9999 Linux pgpool2 pgpool2 9999 9000 7 STANDBY pgpool3:9999 Linux pgpool3 pgpool3 9999 9000 7 STANDBY # pcp_watchdog_info -w -h pgpool2 -U postgres -p 9898 3 NO pgpool1:9999 Linux pgpool1 pgpool1 pgpool2:9999 Linux pgpool2 pgpool2 9999 9000 7 STANDBY pgpool1:9999 Linux pgpool1 pgpool1 9999 9000 4 MASTER pgpool3:9999 Linux pgpool3 pgpool3 9999 9000 1 LOADING | ||||
| Steps To Reproduce | Reproduction steps: 1) 3 pgpool nodes (pgpool1, pgpool2, pgpool3) are started 2) reboot server of pgpool3 3) pcp_watchdog_info of pgpool1 shows the state of pgpool3 is "STANDBY", but pcp_watchdog_info of pgpool2 shows the state of pgpool3 "LOADING" | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-01-15 11:06 | pengbo | New Issue | |
| 2021-01-15 11:06 | pengbo | Status | new => assigned |
| 2021-01-15 11:06 | pengbo | Assigned To | => Muhammad Usama |
| 2021-01-15 11:07 | pengbo | Description Updated | |
| 2021-01-15 11:07 | pengbo | Steps to Reproduce Updated | |
| 2021-01-15 11:09 | pengbo | File Added: pgpool1_pgpool.log | |
| 2021-01-15 11:09 | pengbo | File Added: pgpool2_pgpool.log | |
| 2021-01-15 11:09 | pengbo | File Added: pgpool3_pgpool.log | |
| 2021-05-25 14:36 | pengbo | Status | assigned => resolved |
| 2021-05-25 14:36 | pengbo | Target Version | => 4.1.8 |
| 2021-05-25 14:36 | pengbo | Note Added: 0003854 | |
| 2021-08-05 14:25 | administrator | Status | resolved => closed |
| 2021-08-05 14:25 | administrator | Resolution | open => fixed |
| 2021-08-05 14:25 | administrator | Fixed in Version | => 4.1.8 |
