[pgpool-general: 9406] Re: FATAL: failed to read kind from backend

[Tatsuo Ishii]

> PG 16.8
> PgPool 4.5.4
> 
> Three node cluster:
> FISPCDSPGS302a   < Primary DB node
> FISPCDSPGS302b   < DB replica
> FISPCDSPGS302c   < VIP lives here
> 
> FATAL:  failed to read kind from backend
> DETAIL:  kind mismatch among backends. Possible last query was: ...
> HINT:  check data consistency among db nodes
> 
> The last query is in the first attached text file, along with pool node and
> db streaming stats.  It's happening about 20 times per hour.
> 
> (Load balancing is turned off.)
> 
> The only other example of this error is when someone ran pg_dump through
> pgpool.
> 
> What could be causing this?

To find the cause I need more log for pid 1119834 before the FATAL error happend.

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