PoPool + Watchdog Kurulum

Merhaba,

https://www.pgpool.net/docs/latest/en/html/example-cluster.html <https://www.pgpool.net/docs/latest/en/html/example-cluster.html> adresindeki yapıyı kurmak istedim. Loglardan gördüğüm kadarıyla pgpool ve watchdog ayağa kalkııyor ama

pcp_recovery_node -h <virtualIp> -p 9898 -U pgpool -n 1
komutunu çalıştırdığımda failed with error "No route to host” hatası alıyorum.

pgpoolAdmin kurdum,
e1002 pcp_node_count command error occurred.
hatası alıyorum.

kurulumda kullandığım parametreleri bash script haline getirdim. Script çalıştırıldığında kurulum esnasında yapacağı değişiklikleri gösteriyor. Kur demediğiniz sürece sisteminizde değişiklik yapmaz.
https://github.com/akifova/bash_pgpool2_ubuntu

Developer’im ve dolayısı ile DBA’ya uzağım. Çözemedim bu hatanın sebebini.

PgPool Logları şu şekilde:
sudo cat /var/log/syslog | egrep ‘pgpool'
Apr 19 11:51:45 db_srv_slave_1 systemd[1]: Started pgpool-II.
Apr 19 11:51:46 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:46: pid 817: LOG: memory cache initialized
Apr 19 11:51:46 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:46: pid 817: DETAIL: memcache blocks :64
Apr 19 11:51:46 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:46: pid 817: LOG: pool_discard_oid_maps: discarded memqcache oid maps
Apr 19 11:51:46 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:46: pid 817: LOG: waiting for watchdog to initialize
Apr 19 11:51:46 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:46: pid 1051: LOG: setting the local watchdog node name to "10.10.30.86:5433 Linux db_srv_slave_1"
Apr 19 11:51:46 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:46: pid 1051: LOG: watchdog cluster is configured with 2 remote nodes
Apr 19 11:51:46 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:46: pid 1051: LOG: watchdog remote node:0 on 10.10.30.87:9000
Apr 19 11:51:46 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:46: pid 1051: LOG: watchdog remote node:1 on 10.10.30.88:9000
Apr 19 11:51:46 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:46: pid 1051: LOG: interface monitoring is disabled in watchdog
Apr 19 11:51:46 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:46: pid 1051: LOG: connect on socket failed
Apr 19 11:51:46 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:46: pid 1051: DETAIL: connect failed with error: "Network is unreachable"
Apr 19 11:51:46 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:46: pid 1051: LOG: connect on socket failed
Apr 19 11:51:46 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:46: pid 1051: DETAIL: connect failed with error: "Network is unreachable"
Apr 19 11:51:46 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:46: pid 1051: LOG: watchdog node state changed from [DEAD] to [LOADING]
Apr 19 11:51:52 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:52: pid 1051: LOG: watchdog node state changed from [LOADING] to [JOINING]
Apr 19 11:51:52 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:52: pid 1051: LOG: new outbound connection to 10.10.30.87:9000
Apr 19 11:51:52 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:52: pid 1051: LOG: new outbound connection to 10.10.30.88:9000
Apr 19 11:51:52 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:52: pid 1051: LOG: read from socket failed, remote end closed the connection
Apr 19 11:51:52 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:52: pid 1051: LOG: client socket of is closed
Apr 19 11:51:52 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:52: pid 1051: LOG: read from socket failed, remote end closed the connection
Apr 19 11:51:52 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:52: pid 1051: LOG: client socket of is closed
Apr 19 11:51:56 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:56: pid 1051: LOG: watchdog node state changed from [JOINING] to [INITIALIZING]
Apr 19 11:51:57 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:57: pid 1051: LOG: I am the only alive node in the watchdog cluster
Apr 19 11:51:57 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:57: pid 1051: HINT: skipping stand for coordinator state
Apr 19 11:51:57 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:57: pid 1051: LOG: watchdog node state changed from [INITIALIZING] to [MASTER]
Apr 19 11:51:57 db_srv_slave_1 pgpool[817]: 2020-04-19 11:51:57: pid 1051: LOG: I am announcing my self as master/coordinator watchdog node
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 1051: LOG: I am the cluster leader node
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 1051: DETAIL: our declare coordinator message is accepted by all nodes
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 1051: LOG: setting the local node "10.10.30.86:5433 Linux db_srv_slave_1" as watchdog cluster master
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 1051: LOG: I am the cluster leader node but we do not have enough nodes in cluster
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 1051: DETAIL: waiting for the quorum to start escalation process
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 817: LOG: watchdog process is initialized
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 817: DETAIL: watchdog messaging data version: 1.1
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 1051: LOG: new IPC connection received
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 1051: LOG: new IPC connection received
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 817: LOG: Setting up socket for 0.0.0.0:5433
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 817: LOG: Setting up socket for :::5433
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 1657: LOG: 3 watchdog nodes are configured for lifecheck
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 1657: LOG: watchdog nodes ID:0 Name:"10.10.30.86:5433 Linux db_srv_slave_1"
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 1657: DETAIL: Host:"10.10.30.86" WD Port:9000 pgpool-II port:5433
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 1657: LOG: watchdog nodes ID:1 Name:"Not_Set"
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 1657: DETAIL: Host:"10.10.30.87" WD Port:9000 pgpool-II port:9999
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 1657: LOG: watchdog nodes ID:2 Name:"Not_Set"
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 1657: DETAIL: Host:"10.10.30.88" WD Port:9000 pgpool-II port:9999
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 817: LOG: find_primary_node_repeatedly: waiting for finding a primary node
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 817: LOG: find_primary_node: primary node is 0
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 817: LOG: pgpool-II successfully started. version 4.1.1 (karasukiboshi)
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 817: LOG: node status[0]: 1
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 817: LOG: node status[1]: 0
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 817: LOG: node status[2]: 0
Apr 19 11:52:01 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:01: pid 1696: LOG: PCP process: 1696 started
Apr 19 11:52:02 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:02: pid 1662: LOG: set SO_REUSEPORT option to the socket
Apr 19 11:52:02 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:02: pid 1666: LOG: set SO_REUSEPORT option to the socket
Apr 19 11:52:02 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:02: pid 1666: LOG: creating watchdog heartbeat receive socket.
Apr 19 11:52:02 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:02: pid 1666: DETAIL: set SO_REUSEPORT
Apr 19 11:52:02 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:02: pid 1664: LOG: set SO_REUSEPORT option to the socket
Apr 19 11:52:02 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:02: pid 1664: LOG: creating socket for sending heartbeat
Apr 19 11:52:02 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:02: pid 1664: DETAIL: set SO_REUSEPORT
Apr 19 11:52:02 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:02: pid 1662: LOG: creating watchdog heartbeat receive socket.
Apr 19 11:52:02 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:02: pid 1662: DETAIL: set SO_REUSEPORT
Apr 19 11:52:02 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:02: pid 1668: LOG: set SO_REUSEPORT option to the socket
Apr 19 11:52:02 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:02: pid 1668: LOG: creating socket for sending heartbeat
Apr 19 11:52:02 db_srv_slave_1 pgpool[817]: 2020-04-19 11:52:02: pid 1668: DETAIL: set SO_REUSEPORT
Apr 19 12:55:26 db_srv_slave_1 pgpool[817]: 2020-04-19 12:55:26: pid 1688: LOG: pool_reuse_block: blockid: 0
Apr 19 12:55:26 db_srv_slave_1 pgpool[817]: 2020-04-19 12:55:26: pid 1688: CONTEXT: while searching system catalog, When relcache is missed
Apr 19 13:03:23 db_srv_slave_1 pgpool[817]: 2020-04-19 13:03:23: pid 817: LOG: child process with pid: 1688 exits with status 256
Apr 19 13:03:23 db_srv_slave_1 pgpool[817]: 2020-04-19 13:03:23: pid 817: LOG: fork a new child process with pid: 13443
Apr 19 13:05:31 db_srv_slave_1 pgpool[817]: 2020-04-19 13:05:31: pid 1696: LOG: forked new pcp worker, pid=13606 socket=9

Teşekkürler.