[pgpool-general: 5673] Re: find_primary_node problem
Tatsuo Ishii
ishii at sraoss.co.jp
Wed Aug 2 15:34:38 JST 2017
> 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
No error logs found? Strange...
Is it possible for you to enable debug log of Pgpool-II?
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
More information about the pgpool-general
mailing list