View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000805 | Pgpool-II | General | public | 2023-06-29 00:11 | 2023-07-03 17:08 |
| Reporter | velasquezjr23 | Assigned To | |||
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Product Version | 4.2.13 | ||||
| Summary | 0000805: I'm trying to create a mega cluster of 6 nodes with postgresql-12 and pgpoll- ii, it fails when I include node 5 and 5 | ||||
| Description | I'm trying to create a mega cluster of 6 nodes with postgresql-12 and pgpoll- ii, all good until when I include the node 5 and 6, annex information of the configuration made in escalation.sh and pgpool.conf, I thank you in advance for all your support, regards ******************* escalation.sh #!/bin/bash # This script is run by wd_escalation_command to bring down the virtual IP on other pgpool nodes # before bringing up the virtual IP on the new active pgpool node. set -o xtrace PGPOOLS=(server01 server02 server03 server04 server05 server06) VIP=192.168.1.08 DEVICE=enp0s3:0 for pgpool in "${PGPOOLS[@]}"; do [ "$HOSTNAME" = "$pgpool" ] && continue ssh -T -o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null postgres@$pgpool -i ~/.ssh/id_rsa_pgpool " /usr/bin/sudo /sbin/ip addr del $VIP/24 dev $DEVICE " done exit 0 ********************** pgpool.conf backend_hostname0 = 'server01' backend_port0 = 5432 backend_weight0 = 1 backend_data_directory0 = '/var/lib/pgsql/12/data' backend_flag0 = 'ALLOW_TO_FAILOVER' backend_hostname1 = 'server02' backend_port1 = 5432 backend_weight1 = 1 backend_data_directory1 = '/var/lib/pgsql/12/data' backend_flag1 = 'ALLOW_TO_FAILOVER' backend_hostname2 = 'server03' backend_port2 = 5432 backend_weight2 = 1 backend_data_directory2 = '/var/lib/pgsql/12/data' backend_flag2 = 'ALLOW_TO_FAILOVER' backend_hostname3 = 'server04' backend_port3 = 5432 backend_weight3 = 1 backend_data_directory3 = '/var/lib/pgsql/12/data' backend_flag3 = 'ALLOW_TO_FAILOVER' backend_hostname4 = 'server05' backend_port4 = 5432 backend_weight4 = 1 backend_data_directory4 = '/var/lib/pgsql/12/data' backend_flag4 = 'ALLOW_TO_FAILOVER' backend_hostname5 = 'server06' backend_port5 = 5432 backend_weight5 = 1 backend_data_directory5 = '/var/lib/pgsql/12/data' backend_flag5 = 'ALLOW_TO_FAILOVER' backend_application_name0 = 'server01' backend_application_name1 = 'server02' backend_application_name2 = 'server03' backend_application_name3 = 'server04' backend_application_name4 = 'server05' backend_application_name5 = 'server06' # - Watchdog communication Settings - hostname0 = 'server01' # Host name or IP address of pgpool node # for watchdog connection # (change requires restart) wd_port0 = 9000 # Port number for watchdog service # (change requires restart) pgpool_port0 = 9999 # Port number for pgpool # (change requires restart) hostname1 = 'server02' wd_port1 = 9000 pgpool_port1 = 9999 hostname2 = 'server03' wd_port2 = 9000 pgpool_port2 = 9999 hostname3 = 'server04' wd_port3 = 9000 pgpool_port3 = 9999 hostname4 = 'server05' wd_port4 = 9000 pgpool_port4 = 9999 hostname5 = 'server06' wd_port5 = 9000 pgpool_port5 = 9999 # -- heartbeat mode -- heartbeat_hostname0 = 'server01' # Host name or IP address used # for sending heartbeat signal. # (change requires restart) heartbeat_port0 = 9694 # Port number used for receiving/sending heartbeat signal # Usually this is the same as heartbeat_portX. # (change requires restart) heartbeat_device0 = '' # Name of NIC device (such like 'eth0') # used for sending/receiving heartbeat # signal to/from destination 0. # This works only when this is not empty # and pgpool has root privilege. # (change requires restart) heartbeat_hostname1 = 'server02' heartbeat_port1 = 9694 heartbeat_device1 = '' heartbeat_hostname2 = 'server03' heartbeat_port2 = 9694 heartbeat_device2 = '' heartbeat_hostname3 = 'server04' heartbeat_port3 = 9694 heartbeat_device3 = '' heartbeat_hostname4 = 'server05' heartbeat_port4 = 9694 heartbeat_device4 = '' heartbeat_hostname5 = 'server06' heartbeat_port5 = 9694 heartbeat_device5 = '' enable_consensus_with_half_votes = on # apply majority rule for consensus and quorum computation # at 50% of votes in a cluster with even number of nodes. | ||||
| Tags | No tags attached. | ||||
|
|
> I'm trying to create a mega cluster of 6 nodes with postgresql-12 and pgpoll- ii, it fails when I include node 5 and 5 Could you share the error meesages or logs? |
|
|
Good morning friend pengbo, I was able to solve it, thanks for your timely response, it was enable_consensus_with_half_votes = off, badly configured, greetings and blessings |
|
|
> Good morning friend pengbo, I was able to solve it, thanks for your timely response, it was enable_consensus_with_half_votes = off, badly configured, greetings and blessings Great! I am goint to close this issue. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-06-29 00:11 | velasquezjr23 | New Issue | |
| 2023-06-29 08:52 | pengbo | Note Added: 0004412 | |
| 2023-06-29 08:52 | pengbo | Assigned To | => pengbo |
| 2023-06-29 08:52 | pengbo | Status | new => feedback |
| 2023-06-29 20:38 | velasquezjr23 | Note Added: 0004414 | |
| 2023-06-29 20:38 | velasquezjr23 | Status | feedback => assigned |
| 2023-07-03 16:59 | pengbo | Note Added: 0004416 | |
| 2023-07-03 17:08 | pengbo | Assigned To | pengbo => |
| 2023-07-03 17:08 | pengbo | Status | assigned => closed |
