[pgpool-general: 5147] FATAL: failed to read kind from backend - bug ID 0000231

Wolf Schwurack wolf at uen.org
Wed Dec 7 04:45:59 JST 2016

We are getting the same error that is in bug ID 0000231

Here is what the application is trying to do - how we reproduced it:

We have a Java based application that is using Tomcat, Hibernate Search (Lucene), PostgreSQL and Pgpool-II.  When the application tries to re-create the Lucene indexes it fails and throws this error:
2016-12-05 13:57:25: pid 15638: WARNING: packet kind of backend 1 ['3'] does not match with master/majority nodes packet kind ['1']
2016-12-05 13:57:25: pid 15638: FATAL: failed to read kind from backend
2016-12-05 13:57:25: pid 15638: DETAIL: kind mismatch among backends. Possible last query was: "COMMIT" kind details are: 0[1] 1[3]
2016-12-05 13:57:25: pid 15638: HINT: check data consistency among db nodes

The Java code for re-indexing Lucene can be tuned a little bit by indicating the number of threads that concurrently load records from the DB.

Here is the code we are using:

Wolfgang Schwurack
Database/System Administrator
Utah Education Network
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/20161206/121e4bd3/attachment.html>

More information about the pgpool-general mailing list