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

sukitha jayasinghe sukithaj at gmail.com
Sun May 20 23:52:10 JST 2018


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180520/19282245/attachment.html>


More information about the pgpool-general mailing list