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

Goh Geok Bee gbgoh at ntu.edu.sg
Thu Jan 11 23:47:16 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!

Best Rdgs,

CONFIDENTIALITY: This email is intended solely for the person(s) named and may be confidential and/or privileged. If you are not the intended recipient, please delete it, notify us and do not copy, use, or disclose its contents.
Towards a sustainable earth: Print only when necessary. Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180111/4882dd6e/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool-problem.log
Type: application/octet-stream
Size: 181222 bytes
Desc: pgpool-problem.log
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180111/4882dd6e/attachment-0001.obj>

More information about the pgpool-general mailing list