[pgpool-general: 9308] Re: pgpool Connection issue: ERROR: unable to read message kind

[Mukesh Tanuku]

Hi Tatsuo,
as you said i have tested with synchronous_commit = remote_apply and also
with 2 node & 3 node cluster also, but still i see the same kind error

Error in Virtual User 1: Error: Connection to database failed
connection to server at "10.35.8.34", port 9999 failed: ERROR:  unable to
read message kind
DETAIL:  kind does not match between main(53) slot[2] (45)

What could be the problem here?

Regards
Mukesh Tanuku

On Wed, Dec 25, 2024 at 11:11 AM Mukesh Tanuku <mukesh.postgres at gmail.com>
wrote:

> pgpool - II 4.5.2
>
> On Wed, Dec 25, 2024 at 9:50 AM Tatsuo Ishii <ishii at postgresql.org> wrote:
>
>> > I revalidated everything and now the connection is established
>> successfully
>> > to the DB via pgpool, but falling with the actual error.  I have tried
>> > using remote_apply, still seeing the same error.
>> >
>> > Error in Virtual User 1: Error: Connection to database failed
>> > connection to server at "10.35.8.30", port 9999 failed: ERROR:  unable
>> to
>> > read message kind
>> > DETAIL:  kind does not match between main(53) slot[1] (45)
>> >
>> > here are my parameters
>> >
>> >
>> > *pgpool.conf*
>> > listen_addresses = '*'
>> > port = 9999
>> > pcp_listen_addresses = '*'
>> > backend_hostname0 = '10.35.8.30'
>> > backend_port0 = 5432
>> > backend_weight0 = 1
>> > backend_hostname1 = '10.35.8.31'
>> > backend_port1 = 5432
>> > backend_weight1 = 1
>> > load_balance_mode = 'on'
>> > master_slave_mode = 'on'
>> > master_slave_sub_mode = 'stream'
>>
>> What version of pgpool are you using?
>>
>> > master_slave_mode = 'on'
>> > master_slave_sub_mode = 'stream'
>>
>> These parameters are no longer valid in the supported versions of
>> pgpool.
>>
>> Best reagards,
>> --
>> Tatsuo Ishii
>> SRA OSS K.K.
>> English: http://www.sraoss.co.jp/index_en/
>> Japanese:http://www.sraoss.co.jp
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20241230/34821317/attachment.htm>