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

[Tatsuo Ishii]

> Thanks Tatsuo for giving a response to my ask.
> 
> *doubt:* Is this because we set a Asynchronous streaming replication on
> postgresql nodes?

Yeah, that's a legitimate explanation.

tpcc database was created at 2024-12-23 04:17:00.392.

> 2024-12-23 04:17:00.392: [unknown] pid 1227285: DETAIL:  destination = 0
> for query= "CREATE DATABASE "tpcc" OWNER "tpcc""

273 ms after the error occured.

> 2024-12-23 04:17:00.665: [unknown] pid 1227285: LOG:  pool_read_kind: error
> message from 1 th backend:database "tpcc" does not exist

Probably 273 ms was not enough to replicate the tpcc database.  You
could avoid the error by using synchronous streaming replication with
synchronous_commit = remote_apply option.

Best reagards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp