[pgpool-general: 9301] Re: pgpool Connection issue: ERROR: unable to read message kind

[Tatsuo Ishii]

Hello Mukesh,

> Hello Tatsuo,
> 
> I have few questions, If you again look back the pgpool.log
> 
> at 2024-12-23 04:17:00.310: [unknown] pid 1227285: DETAIL:  SSLRequest from
> client, there is connection to DB and
> at 2024-12-23 04:17:00.392: [unknown] pid 1227285: DETAIL:  destination = 0
> for query= "CREATE DATABASE "tpcc" OWNER "tpcc""
> query got fired to create database tpcc
> 
> again there is new connection at 2024-12-23 04:17:00.653: [unknown] pid
> 1227285: DETAIL:  SSLRequest from client
> then this connection got failed with error message
> 
> Questions:
> 1. what is the destination = 0 means

The query (CREATE DATABASE) will be sent to primary PostgreSQL.

> 2. How can we see which backend node got selected while the connection got
> established?

Enabling log_per_node_statement to on will log the info you need.

> 3. According to your recommendation i have set synchronous commit, but this
> parameter *synchronous_commit = on, *but still failing (intermittently). So
> is the replication delay might be purely on Azure networking?

"on" is not sufficient. You need to use "remote_apply".

Best reagards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp