[pgpool-general: 5048] Re: FATAL: failed to read kind from backend
Tatsuo Ishii
ishii at sraoss.co.jp
Mon Oct 17 16:11:14 JST 2016
> I upgraded pgpool to 3.5.4 now getting this error
>
> 2016-10-10 13:19:59: pid 18764: WARNING: packet kind of backend 1 ['3'] does not match with master/majority nodes packet kind ['2']
> 2016-10-10 13:19:59: pid 18764: FATAL: failed to read kind from backend
> 2016-10-10 13:19:59: pid 18764: DETAIL: kind mismatch among backends. Possible last query was: "COMMIT" kind details are: 0[2] 1[3]
> 2016-10-10 13:19:59: pid 18764: HINT: check data consistency among db nodes
>
> Our setup using a streaming replication with 2 pgpool hosts using watchdog
> 2 pgpool hosts
> Ubuntu 14.04.5
> pgpool-II version 3.5.4
> 2 postgres hosts
> PostgreSQL 9.5.4
Is there any reliably way to reproduce your problem?
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
More information about the pgpool-general
mailing list