[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