MIME-Version: 1.0
From: Mukesh Tanuku <mukesh.postgres@gmail.com>
Date: Fri, 20 Dec 2024 15:49:16 +0530
Message-ID: <CAJzgB-FUB6qHADAV=-2B5LQEAiyz1c+TZ_5csejqnzNe8QaOaA@mail.gmail.com>
Subject: pgpool Connection issue: ERROR: unable to read message kind
To: pgpool-general@pgpool.net, vijay.postgres@gmail.com, 
	pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000051b5be0629b0fb77"
Archived-At: <https://www.postgresql.org/message-id/CAJzgB-FUB6qHADAV%3D-2B5LQEAiyz1c%2BTZ_5csejqnzNe8QaOaA%40mail.gmail.com>
Precedence: bulk

--00000000000051b5be0629b0fb77
Content-Type: text/plain; charset="UTF-8"

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.

Thank you
Mukesh Tanuku

--00000000000051b5be0629b0fb77
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hello=C2=A0Everyone,<br><div><br></div><div>We have a Post=
gres setup in Azure (IAAS) with 2 DB nodes in the cluster and pgpool is run=
ning on each DB node. We have enabled the watchdog.=C2=A0</div><div><br></d=
iv><div>What we are doing: We are testing the connectivity to DB cluster vi=
a HammerDB to apply the load.</div><div>HammerDB is connecting to Delegate =
IP via 9999 port.</div><div><br></div><div>Issue: when we initiate the conn=
ection it gives error, but when we re-initiate the connection again then it=
 is successful. What could be the issue</div><div><br></div><div>Error mess=
age we are seeing when we initiate=C2=A0the connection for the first time.<=
/div><div><br></div><div><font color=3D"#ff0000">Error in Virtual User 1: E=
rror: Connection to database failed<br>connection to server at &quot;10.35.=
8.4&quot;, port 9999 failed: ERROR: =C2=A0unable to read message kind<br>DE=
TAIL: =C2=A0kind does not match between main(53) slot[1] (45)</font></div><=
div><font color=3D"#ff0000"><br></font></div><div>If you want to see any co=
nfiguration settings that i made, i can share.</div><div><br></div><div>Ple=
ase help me in this=C2=A0regard.</div><div><br></div><div>Thank you</div><d=
iv>Mukesh Tanuku</div></div>

--00000000000051b5be0629b0fb77--