pgpool Connection issue: ERROR: unable to read message kind

From: Mukesh Tanuku <mukesh(dot)postgres(at)gmail(dot)com>
To: pgpool-general(at)pgpool(dot)net, vijay(dot)postgres(at)gmail(dot)com, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: pgpool Connection issue: ERROR: unable to read message kind
Date: 2024-12-20 10:19:16
Message-ID: CAJzgB-FUB6qHADAV=-2B5LQEAiyz1c+TZ_5csejqnzNe8QaOaA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Enrico Schenone 2024-12-20 15:02:26 Re: Intermittent errors when fetching cursor rows on PostgreSQL 16
Previous Message Ekaterina Amez Gonzalez 2024-12-20 10:06:29 Streaming replication problem with collation