[pgpool-general: 5857] Re: Intermittent query failed when using pgpool2
Goh Geok Bee
gbgoh at ntu.edu.sg
Mon Jan 15 09:33:17 JST 2018
Attached is the pgpool.conf. Looking forward to your reply. Thanks!
From: Tatsuo Ishii [mailto:ishii at sraoss.co.jp]
Sent: Friday, 12 January 2018 6:19 AM
To: Goh Geok Bee <gbgoh at ntu.edu.sg>
Cc: pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 5853] Intermittent query failed when using pgpool2
> 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.
SRA OSS, Inc. Japan
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 --------------
A non-text attachment was scrubbed...
Size: 35312 bytes
More information about the pgpool-general