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

Tatsuo Ishii ishii at sraoss.co.jp
Wed May 16 18:48:05 JST 2018


> 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


More information about the pgpool-general mailing list