Date: Mon, 23 Dec 2024 11:13:50 +0900 (JST)
Message-Id: <20241223.111350.278027966538000695.ishii@postgresql.org>
To: mukesh.postgres@gmail.com
Cc: pgpool-general@pgpool.net, vijay.postgres@gmail.com,
 pgsql-general@lists.postgresql.org
Subject: Re: [pgpool-general: 9291] pgpool Connection issue: ERROR: unable
 to read message kind
From: Tatsuo Ishii <ishii@postgresql.org>
In-Reply-To: <CAJzgB-FUB6qHADAV=-2B5LQEAiyz1c+TZ_5csejqnzNe8QaOaA@mail.gmail.com>
References: <CAJzgB-FUB6qHADAV=-2B5LQEAiyz1c+TZ_5csejqnzNe8QaOaA@mail.gmail.com>
Mime-Version: 1.0
Content-Type: Text/Plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/20241223.111350.278027966538000695.ishii%40postgresql.org>
Precedence: bulk

> Hello Everyone,
> 
> We have a Postgres setup in Azure (IAAS) with 2 DB nodes in the cluster and
> pgpool is running on each DB node. We have enabled the watchdog.
> 
> What we are doing: We are testing the connectivity to DB cluster via
> HammerDB to apply the load.
> HammerDB is connecting to Delegate IP via 9999 port.
> 
> Issue: when we initiate the connection it gives error, but when we
> re-initiate the connection again then it is successful. What could be the
> issue
> 
> Error message we are seeing when we initiate the connection for the first
> time.
> 
> Error in Virtual User 1: Error: Connection to database failed
> connection to server at "10.35.8.4", port 9999 failed: ERROR:  unable to
> read message kind
> DETAIL:  kind does not match between main(53) slot[1] (45)
> 
> If you want to see any configuration settings that i made, i can share.
> 
> Please help me in this regard.

The error message can be interpreted that primary PostgreSQL sent 0x53
= 'S'(parameter status message) while standby sent 0x45 = 'E' (error
response). Perhaps the parameter status cannot be processed on standby
for some reasons. In order to study the cause of error, I need a
pgpool log with debug level 1 (log_min_messages = debug1). Can you
provide it?

BTW, cross posting pgpool-general and pgsql-general is not
recommended. Please post to pgpool-general only next time.

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