<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><a name="_MailEndCompose"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Interesting…I got the “kind mismatch” errors with load balancing turned ON, and they disappeared when it was turned OFF…so the opposite.<o:p></o:p></span></a></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></span></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Developers, should we expect that any of these bugs around load balancing are fixed in the upcoming 3.6.0 release?<o:p></o:p></span></span></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="1086" style="width:407.25pt">
<tbody>
<tr>
<td colspan="3" style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><img width="1086" height="140" id="Picture_x0020_1" src="cid:image003.png@01D238E7.F8957170" alt="banner2"></span></span><span style="mso-bookmark:_MailEndCompose"><span style="color:#1F497D"><o:p></o:p></span></span></p>
</td>
<span style="mso-bookmark:_MailEndCompose"></span>
</tr>
<tr style="height:7.5pt">
<td style="padding:0in 0in 0in 0in;height:7.5pt">
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:1.0pt;color:#1F497D"> <o:p></o:p></span></span></p>
</td>
<span style="mso-bookmark:_MailEndCompose"></span>
<td style="padding:0in 0in 0in 0in;height:7.5pt"><span style="mso-bookmark:_MailEndCompose"></span></td>
<span style="mso-bookmark:_MailEndCompose"></span>
<td style="padding:0in 0in 0in 0in;height:7.5pt"><span style="mso-bookmark:_MailEndCompose"></span></td>
<span style="mso-bookmark:_MailEndCompose"></span>
</tr>
<tr>
<td nowrap="" valign="top" style="padding:0in 0in 0in .25in">
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><b><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">David Sisk</span></b></span><span style="mso-bookmark:_MailEndCompose"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666"><o:p></o:p></span></span></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">Engineer - Software<o:p></o:p></span></span></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"></span><a href="mailto:dsisk@cisco.com"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666;text-decoration:none">dsisk@cisco.com</span></span></a><span style="mso-bookmark:_MailEndCompose"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></span></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">Tel:
<o:p></o:p></span></span></p>
</td>
<span style="mso-bookmark:_MailEndCompose"></span>
<td width="550" valign="top" style="width:206.25pt;padding:0in 0in 0in 15.0pt">
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><b><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">Cisco Systems, Inc.<o:p></o:p></span></b></span></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">7025-6 Kit Creek Road PO Box 14987<br>
RESEARCH TRIANGLE PARK<br>
27709-4987<br>
United States<br>
cisco.com<o:p></o:p></span></span></p>
</td>
<span style="mso-bookmark:_MailEndCompose"></span>
<td style="padding:0in 0in 0in 0in"><span style="mso-bookmark:_MailEndCompose"></span></td>
<span style="mso-bookmark:_MailEndCompose"></span>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span lang="EN-GB" style="color:#1F497D;display:none"><o:p> </o:p></span></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="800" style="width:300.0pt">
<tbody>
<tr>
<td style="padding:0in 15.0pt 0in .25in">
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#009900"><img border="0" width="36" height="38" id="Picture_x0020_3" src="cid:image004.png@01D238E7.F8957170" alt="http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif">Think
before you print.<o:p></o:p></span></span></p>
</td>
<span style="mso-bookmark:_MailEndCompose"></span>
</tr>
<tr>
<td style="padding:0in 15.0pt 0in .25in">
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#999999">This email may contain confidential and privileged material for the sole use of the intended recipient. Any review, use,
distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender by reply email and delete all copies of this message.<o:p></o:p></span></span></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#999999">Please
</span></span><a href="http://www.cisco.com/web/about/doing_business/legal/cri/index.html" title="Legal Information"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#0E58A0">click here</span></span><span style="mso-bookmark:_MailEndCompose"></span></a><span style="mso-bookmark:_MailEndCompose"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#999999">
for Company Registration Information.<o:p></o:p></span></span></p>
</td>
<span style="mso-bookmark:_MailEndCompose"></span>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></span></p>
<span style="mso-bookmark:_MailEndCompose"></span>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> pgpool-general-bounces@pgpool.net [mailto:pgpool-general-bounces@pgpool.net]
<b>On Behalf Of </b>erdenebat@skysys.mn<br>
<b>Sent:</b> Sunday, November 6, 2016 7:13 AM<br>
<b>To:</b> pgpool-general@pgpool.net<br>
<b>Subject:</b> [pgpool-general: 5103] Re: About SELECT load balancing in master/slave mode<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">I'm testing pgpool-II 3.5.4. While load balancing is turned off, pgpool-II gives a following error:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span style="font-family:"Courier New"">LOG: pool_read_kind: error message from 1 th kind backend:database "mydb" does not exist</span><o:p></o:p></p>
</blockquote>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span style="font-family:"Courier New"">ERROR: unable to read message kind</span><o:p></o:p></p>
</blockquote>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">DETAIL: kind does not match between master(53) slot[1] (45)</span><o:p></o:p></p>
</div>
</blockquote>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">backend1 is standby server. I don't understand why pgpool-II tries to read from standby while load balancing is off.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Regards,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Erdenebat<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">06.11.2016, 19:31, "<a href="mailto:erdenebat@skysys.mn">erdenebat@skysys.mn</a>" <<a href="mailto:erdenebat@skysys.mn">erdenebat@skysys.mn</a>>:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">I turned off load balancing. But it seems that load balancing is still working.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">On the standby, it gives an error 'database does not exist'.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">I understand that pgpool-II does not access standby while load balancing is off.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">02.11.2016, 17:57, "<a href="mailto:erdenebat@skysys.mn">erdenebat@skysys.mn</a>" <<a href="mailto:erdenebat@skysys.mn">erdenebat@skysys.mn</a>>:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">Hello guys,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">In <a href="http://www.pgpool.net/mediawiki/index.php/FAQ#It_seems_my_pgpool-II_does_not_do_load_balancing._Why.3F">
pgpool-II FAQ</a>, it states that "<span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#252525;background:white">SELECT will be load balanced even in a transaction if operated in the master/slave mode".</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#252525;background:white">Is there any way to do it in reverse? Is there any configuration not to load balance SELECT statement if a transaction is in the master/slave mode?</span><br>
<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Thanks in advance,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Erdenebat Oyungerel<o:p></o:p></p>
</div>
</blockquote>
<p class="MsoNormal">,<o:p></o:p></p>
<p>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><o:p></o:p></p>
</blockquote>
</div>
</body>
</html>