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

Wolf Schwurack wolf at uen.org
Wed Oct 12 01:32:31 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


Wolfgang Schwurack
Database/System Administrator
Utah Education Network
801-587-9444
wolf at uen.org<mailto:wolf at uen.org>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161011/e8fc0647/attachment.html>


More information about the pgpool-general mailing list