[pgpool-general: 5854] Re: Intermittent query failed when using pgpool2
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
SRA OSS, Inc. Japan
More information about the pgpool-general