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

[Wolf Schwurack]

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:
{code}
entityManager
  .createIndexer(Person.class)
  .batchSizeToLoadObjects(100)
  .cacheMode(CacheMode.NORMAL)
  .threadsToLoadObjects(5)
  .threadsForSubsequentFetching(10)
  .startAndWait();
{code}


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/20161206/121e4bd3/attachment.html>