[pgpool-general: 5854] Re: Intermittent query failed when using pgpool2

[Tatsuo Ishii]

> We are using pgpool2 version 3.6.7. However, we encountered intermittent query failed on our application and we are using parameterized query.
> 
> We noticed there is similar issue reported in https://github.com/brianc/node-postgres/issues/513 too.
> 
> We are using master/slave mode for pgpool with 1 master and 1 slave postgresql 9.6 servers and only load balance mode is enabled on pgpool2. I have attached the pgpool log file. Pls check the log for 10:57:16 onwards. The query that did not returned result is "SELECT version FROM qtemplates WHERE qtemplate = 17958;" . However, if the same query is run again, it maybe successful.
> 
> Anyone has encountered this before? Appreciate any advice. Thanks!

Can you share pgpool.conf? Hard to tell what's going on without
configuration data.

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