[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

Hi Tatsuo,

Attached is the pgpool.conf. Looking forward to your reply. Thanks!

Best Rdgs,

-----Original Message-----
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.

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
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...
Name: pgpool.conf
Type: application/octet-stream
Size: 35312 bytes
Desc: pgpool.conf
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180115/9a3ede2c/attachment-0001.obj>

More information about the pgpool-general mailing list