[pgpool-general: 6097] Re: pgpool2 writes to standby server after online recovery

[Tatsuo Ishii]

Sounds like a known problem with 3.7.2. Please 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

> Hi all,
> 
> I have installed postgresql 9.6 and pgpool2 3.7.2 in ubuntu 14.04 using
> apt-get packages. It seems like pgpool is not reading postgresql status
> properly. It start writing tostandby server after online recovery executed
> and as soon as new standby server attach with pgpool2. PCP command shows
> postgresql node status correctly.
> 
> postgres at DVPPGPOOL:/root$  pcp_node_info -h DVPPGPOOL -U postgres -p 9898
> -w -n 1
> DVPPGSQL2 5432 2 0.500000 up primary
> postgres at DVPPGPOOL:/root$  pcp_node_info -h DVPPGPOOL -U postgres -p 9898
> -w -n 0
> DVPPGSQL1 5432 1 0.500000 waiting standby
> 
> 
> in pgpool2 debug log i can see
> 
> pool_send_and_wait: Error or notice message from backend: : DB node id: 0
> backend pid: 15965 statement: "INSERT INTO ts_test (title)
> 
> May 20 14:44:51 DVPPGPOOL pgpool[2100]: [917-1] 2018-05-20 14:44:51: pid
> 2100: DEBUG:  reading backend data packet kind
> May 20 14:44:51 DVPPGPOOL pgpool[2100]: [917-2] 2018-05-20 14:44:51: pid
> 2100: DETAIL:  master node id: 0
> May 20 14:44:51 DVPPGPOOL pgpool[2100]: [918-1] 2018-05-20 14:44:51: pid
> 2100: DEBUG:  pool_virtual_master_db_node_id: virtual_master_node_id:0
> load_balance_node_id:1 PRIMARY_NODE_ID:0
> 
> 
> still i can see that pgpool2 take node 1 as the primary server
> 
> May 20 14:50:29 DVPPGPOOL pgpool[2215]: [3-1] 2018-05-20 14:50:29: pid
> 2215: LOG:  find_primary_node_repeatedly: waiting for finding a primary node
> May 20 14:50:29 DVPPGPOOL pgpool[2215]: [4-1] 2018-05-20 14:50:29: pid
> 2215: LOG:  find_primary_node: checking backend no 0
> May 20 14:50:29 DVPPGPOOL pgpool[2215]: [5-1] 2018-05-20 14:50:29: pid
> 2215: LOG:  find_primary_node: checking backend no 1
> May 20 14:50:29 DVPPGPOOL pgpool[2215]: [6-1] 2018-05-20 14:50:29: pid
> 2215: LOG:  find_primary_node: primary node id is 1
> 
> 
> what is the reason of this behavior? please help.
> 
> 
> Sukitha.