View Issue Details

IDProjectCategoryView StatusLast Update
0000584Pgpool-II[All Projects] Generalpublic2020-02-18 17:13
ReporterdaniAssigned Tohoshiai 
PrioritynormalSeverityminorReproducibilityhave not tried
Status feedbackResolutionopen 
Product Version4.1.0 
Target VersionFixed in Version 
Summary0000584: Watchdog session disconnected when any node disconnected (even the standby)
DescriptionHi,
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.
Tagspgpool-II, standby, streaming replication, virtual ip, watchdog

Activities

tiennguyen

2020-02-18 04:12

reporter   ~0003213

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

hoshiai

2020-02-18 17:13

developer   ~0003216

Could you share pgpool.log and pgpool.conf in all pgpool nodes, when this problem is happend ?

Issue History

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