<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:DengXian}
@font-face
{font-family:Calibri}
@font-face
{}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.MsoHyperlink
{color:#0563C1;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:#954F72;
text-decoration:underline}
p.msonormal0, li.msonormal0, div.msonormal0
{margin-right:0cm;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif}
span.EmailStyle18
{font-family:"Calibri",sans-serif;
color:windowtext}
span.EmailStyle19
{font-family:"Calibri",sans-serif;
color:#1F497D}
.MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:72.0pt 72.0pt 72.0pt 72.0pt}
div.WordSection1
{}
-->
</style>
</head>
<body lang="EN-SG" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Hi, </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">We are using pgpool2 version 3.6.7. However, we encountered intermittent query failed on our application and we are using parameterized query.
</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">We noticed there is similar issue reported in <a href="https://github.com/brianc/node-postgres/issues/513">
https://github.com/brianc/node-postgres/issues/513</a> too. </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">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.
</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Anyone has encountered this before? Appreciate any advice. Thanks!</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Best Rdgs,<br>
GB</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:8.0pt; font-family:"Times New Roman",serif; color:#1F497D"> </span></p>
<p class="MsoNormal"> </p>
</div>
<hr>
<font face="Arial" color="Gray" size="2">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.<br>
Towards a sustainable earth: Print only when necessary. Thank you.</font>
</body>
</html>