Postgres Pro
Downloads
Home   >   mailing lists

pgpool Connection issue: ERROR: unable to read message kind - Mailing list pgsql-general

From Mukesh Tanuku
Subject pgpool Connection issue: ERROR: unable to read message kind
Date
Msg-id CAJzgB-FUB6qHADAV=-2B5LQEAiyz1c+TZ_5csejqnzNe8QaOaA@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Ekaterina Amez Gonzalez
Date:
Subject: Streaming replication problem with collation
Next
From: Tom Lane
Date:
Subject: Re: Streaming replication problem with collation