From: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
---|---|
To: | mukesh(dot)postgres(at)gmail(dot)com |
Cc: | pgpool-general(at)pgpool(dot)net, vijay(dot)postgres(at)gmail(dot)com, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: [pgpool-general: 9291] pgpool Connection issue: ERROR: unable to read message kind |
Date: | 2024-12-23 02:13:50 |
Message-ID: | 20241223.111350.278027966538000695.ishii@postgresql.org |
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.
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
From | Date | Subject | |
---|---|---|---|
Next Message | Michel Pelletier | 2024-12-23 03:52:08 | Re: Using Expanded Objects other than Arrays from plpgsql |
Previous Message | Bharani SV-forum | 2024-12-20 22:51:02 | Re: any tips to have restricted inbound and getting connected with postgresql dB |