[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,
GB











-----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
Japanese:http://www.sraoss.co.jp
________________________________
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