View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000266 | Pgpool-II | Bug | public | 2016-12-07 19:10 | 2017-02-15 22:58 |
| Reporter | zoe.chou | Assigned To | Muhammad Usama | ||
| Priority | normal | Severity | minor | Reproducibility | sometimes |
| Status | resolved | Resolution | fixed | ||
| Platform | Linux | OS | Centos 7 | ||
| Summary | 0000266: Standby server Pgpool shutdown when master server postgresql down due to ipc key conflict | ||||
| Description | We are testing pgpool master-slave mode and watchdog function. Before enable watchdog, we can failover to standby node successfully, however after enable watchdog mode, the failover mechanism failed, and the pgpool service on standby server shutdown due to the following error message. pgpool: 2016-12-07 13:01:00: pid 18762: DETAIL: bind on "/tmp/pgpool/.s.PGPOOLWD_CMD.9000" failed with reason: "Address already in use" | ||||
| Steps To Reproduce | 1. Start postgres 9.6 on master node 2. Start postgres 9.6 on standby node 3. Start pgpool 3.6.0 on master node, enable master-slave mode and watchdog 4. Start pgpool 3.6.0 on standby node, enable master-slave mode and watchdog 5. Double check master server node is the master cluster of watchdog, show pool_nodes can indicate the right status of both node. 6. shutdown postgres on master node 7. standby node pgpool shutdown | ||||
| Tags | load balancing, master slave, watchdog | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-12-07 19:10 | zoe.chou | New Issue | |
| 2016-12-08 11:30 | zoe.chou | Tag Attached: load balancing | |
| 2016-12-08 11:30 | zoe.chou | Tag Attached: master slave | |
| 2016-12-08 11:30 | zoe.chou | Tag Attached: watchdog | |
| 2016-12-08 12:49 | zoe.chou | File Added: error message.txt | |
| 2016-12-20 09:29 | t-ishii | Assigned To | => Muhammad Usama |
| 2016-12-20 09:29 | t-ishii | Status | new => assigned |
| 2017-02-15 22:58 | Muhammad Usama | Status | assigned => resolved |
| 2017-02-15 22:58 | Muhammad Usama | Resolution | open => fixed |
| 2017-02-15 22:58 | Muhammad Usama | Note Added: 0001344 |
