View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000584 | Pgpool-II | General | public | 2020-02-15 02:34 | 2020-04-14 15:40 |
| Reporter | dani | Assigned To | hoshiai | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | feedback | Resolution | open | ||
| Product Version | 4.1.0 | ||||
| Summary | 0000584: Watchdog session disconnected when any node disconnected (even the standby) | ||||
| Description | Hi, I set up pgpool successfully based on this article (https://www.pgpool.net/docs/41/en/html/example-cluster.html). Now I'm able to connect to postgresql via watchdog virtual ip. Also when runing show pool_nodes command both nodes are shown with up status. Knowing that I'm using streaming mode, and having two nodes only: one primary and one standby. The issue is that the failover is not working at all! Once I disconnect any node, even the standby one, the watchdog session disconnected! Even if I tried to connect again to watchdog VIP, the connection failed, until I reconnect the disconnected node again. Any help would be appreciated, Thank you. | ||||
| Tags | pgpool-II, standby, streaming replication, virtual ip, watchdog | ||||
|
|
This problem can be mentioned, You can check more infomation at here: http://www.sraoss.jp/pipermail/pgpool-general/2019-December/006849.html https://pgpool.net/mediawiki/index.php/Pgpool-II_4.2_development |
|
|
Could you share pgpool.log and pgpool.conf in all pgpool nodes, when this problem is happend ? |
|
|
It's been more than a month since I replay to you ... Is your problem solved? If you don't have any problems, I would like to close this issue. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-02-15 02:34 | dani | New Issue | |
| 2020-02-15 02:34 | dani | Tag Attached: pgpool-II | |
| 2020-02-15 02:34 | dani | Tag Attached: standby | |
| 2020-02-15 02:34 | dani | Tag Attached: streaming replication | |
| 2020-02-15 02:34 | dani | Tag Attached: virtual ip | |
| 2020-02-15 02:34 | dani | Tag Attached: watchdog | |
| 2020-02-18 04:12 | tiennguyen | Note Added: 0003213 | |
| 2020-02-18 17:07 | hoshiai | Assigned To | => hoshiai |
| 2020-02-18 17:07 | hoshiai | Status | new => assigned |
| 2020-02-18 17:13 | hoshiai | Status | assigned => feedback |
| 2020-02-18 17:13 | hoshiai | Note Added: 0003216 | |
| 2020-04-14 15:40 | hoshiai | Note Added: 0003320 |
