View Issue Details

IDProjectCategoryView StatusLast Update
0000689Pgpool-IIGeneralpublic2021-06-15 16:10
Reporterthesn@hotmail.com Assigned Topengbo  
PriorityhighSeveritymajorReproducibilityalways
Status closedResolutionopen 
Product Version4.1.5 
Summary0000689: master node and virtual ip not assigned
DescriptionHi,

I have INNITIALY setup 3 nodes Pgpool (node-0, node-1, node-2) with with enable_consensus_with_half_votes=on.
When I shutdown node-0, Pgpool master (and virtual ip) is successfully assigned to node-1.
That leaves me with node-1 and node-2.

And then I continue shutdown node-1, but this time Pgpool master (and virtual ip) is not assigned to node-2.
log message in node-2:
I am the cluster leader node but we do not have enough nodes in cluster
waiting for the quorum to start escalation process

Is this the expected behavior?
I thought by setting enable_consensus_with_half_votes=on, will make the Pgpool master (and virtual ip) assigned to node-2.

Thank you.
TagsNo tags attached.

Activities

pengbo

2021-02-15 10:47

developer   ~0003737

> Is this the expected behavior?

Yes. It is the correct behavior.
Because the quorum doesn't exist, VIP will not be assigned.

> I thought by setting enable_consensus_with_half_votes=on, will make the Pgpool master (and virtual ip) assigned to node-2.

This parameter only works for even number of pgpool nodes.

thesn@hotmail.com

2021-02-15 21:00

reporter   ~0003738

> This parameter only works for even number of pgpool nodes.
you mean, even number of pgpool since the beginning (when starting up)?

because when pgpool left me with node-1 and node-2, i thought that's even number (2 nodes)
that's why i tried to set the enable_consensus_with_half_votes=on :)

thanks for your explanation.

pengbo

2021-06-08 13:47

developer   ~0003868

> > This parameter only works for even number of pgpool nodes.
> you mean, even number of pgpool since the beginning (when starting up)?

Yes.

Could I close this issue?

administrator

2021-06-15 16:10

administrator   ~0003877

No response for more than a month.
Close issue.

Issue History

Date Modified Username Field Change
2021-02-14 18:35 thesn@hotmail.com New Issue
2021-02-15 10:47 pengbo Note Added: 0003737
2021-02-15 10:48 pengbo Assigned To => pengbo
2021-02-15 10:48 pengbo Status new => feedback
2021-02-15 21:00 thesn@hotmail.com Note Added: 0003738
2021-02-15 21:00 thesn@hotmail.com Status feedback => assigned
2021-06-08 13:47 pengbo Note Added: 0003868
2021-06-08 13:47 pengbo Status assigned => feedback
2021-06-15 16:10 administrator Note Added: 0003877
2021-06-15 16:10 administrator Status feedback => closed