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

[Tatsuo Ishii]

You might want to try the patch attached to bug 231.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> 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>
>