[pgpool-general: 6090] Re: pgpool3.7.2 not detecting master node?

[Yong Zhang]

I’m using Ubuntu 16.04 with PostgreSQL apt list, looks version 3.7.3 is not there.

From: Tatsuo Ishii<mailto:ishii at sraoss.co.jp>
Sent: Wednesday, May 16, 2018 5:48 PM
To: hiscal at outlook.com<mailto:hiscal at outlook.com>
Cc: pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net>
Subject: Re: [pgpool-general: 6088] pgpool3.7.2 not detecting master node?

> Hi, all
>
> I have pgpool2 3.7.2 with 2 postgresql-10 nodes (version 10.4) in the backend, pgpool starts with below logs:
>
> May 16 16:17:49 pgpool[4496]: 2018-05-16 16:17:49: pid 4496: LOG:  Backend status file /var/log/postgresql/pgpool_status discarded
> May 16 16:17:49 pgpool[4496]: 2018-05-16 16:17:49: pid 4496: LOG:  Setting up socket for 0.0.0.0:9999
> May 16 16:17:49 pgpool[4496]: 2018-05-16 16:17:49: pid 4496: LOG:  Setting up socket for :::9999
> May 16 16:17:49 pgpool[4496]: 2018-05-16 16:17:49: pid 4496: LOG:  find_primary_node_repeatedly: waiting for finding a primary node
> May 16 16:17:49 pgpool[4496]: 2018-05-16 16:17:49: pid 4496: LOG:  find_primary_node: checking backend no 0
> May 16 16:17:49 pgpool[4496]: 2018-05-16 16:17:49: pid 4496: LOG:  find_primary_node: checking backend no 1
> May 16 16:17:49 pgpool[4496]: 2018-05-16 16:17:49: pid 4496: LOG:  find_primary_node: primary node id is 1
>
> Backend0 is my slave node and backend1 is my master node, master and slave are in stream replication mode.
>
> It looks fine from logs, but when clients connected to pgpool, found requests were routed to backend0 not backend1, why???
>
> If I use PostgreSQL-9.6, everything works fine. Please help, thanks.

Sounds like a known bug with Pgpool-II 3.7.2. You should upgrade to 3.7.3.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20180516/406f2405/attachment.htm>