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

Tatsuo Ishii ishii at sraoss.co.jp
Fri Jan 12 07:19:04 JST 2018

> 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

More information about the pgpool-general mailing list