public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tatsuo Ishii <[email protected]>
To: [email protected]
Cc: [email protected]
Cc: [email protected]
Cc: [email protected]
Subject: Re: [pgpool-general: 9291] pgpool Connection issue: ERROR: unable to read message kind
Date: Mon, 23 Dec 2024 11:13:50 +0900 (JST)
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAJzgB-FUB6qHADAV=-2B5LQEAiyz1c+TZ_5csejqnzNe8QaOaA@mail.gmail.com>
References: <CAJzgB-FUB6qHADAV=-2B5LQEAiyz1c+TZ_5csejqnzNe8QaOaA@mail.gmail.com>

> 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

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: [pgpool-general: 9291] pgpool Connection issue: ERROR: unable to read message kind
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox