[pgpool-general: 5667] find_primary_node problem

[Nagy Ákos]

Hi,

I installed a two member pgpool+postgresql cluster, and I have an
interesting problem.

I use LDX containers and ubuntu as OS, and after a clean install I can
start pgpool2 without any problem, but after a service restart or
failover, pgpool2 can't check the primary node from postgresql
master-slave cluster.

I got this error (and after 300 seconds - check interval - the pgpool2
service remain started, but can't connect to postgresql, and can't
determinate the master node):

Aug  1 07:30:00 sd-ro-tm-dev-pg-01 pgpool[27998]: [27-1] 2017-08-01
07:30:00: pid 27998: LOG:  find_primary_node: checking backend no 0
Aug  1 07:30:00 sd-ro-tm-dev-pg-01 pgpool[27998]: [28-1] 2017-08-01
07:30:00: pid 27998: LOG:  find_primary_node: checking backend no 1

-- 
Ákos