<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:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (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]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 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:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
span.Stylwiadomocie-mail17
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=PL link=blue vlink=blue>
<div class=Section1>
<div>
<div>
<p class=MsoNormal style='line-height:120%;vertical-align:middle'><font size=3
color=navy face="Times New Roman"><span lang=EN-US style='font-size:12.0pt;
line-height:120%;color:navy'>Check for memory leaks, it’s possible in
solaris. Maybe after few hours the amount of ram used by pgpool processes is </span></font><span
lang=EN-US>significantly greater?<o:p></o:p></span></p>
<p class=MsoNormal style='line-height:120%;vertical-align:middle'><font size=3
color=navy face="Times New Roman"><span lang=EN-US style='font-size:12.0pt;
line-height:120%;color:navy'>My suggest is to observe ram/swap usage and size
of pgpool proceesses while it’s running, maybe size of the processes
grows in time.<o:p></o:p></span></font></p>
<p class=MsoNormal style='line-height:120%;vertical-align:middle'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt;line-height:
120%'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='line-height:120%;vertical-align:middle'><font size=3
face="Times New Roman"><span style='font-size:12.0pt;line-height:120%'>Although</span></font><span
lang=EN-US>, I have configuration:<o:p></o:p></span></p>
<p class=MsoNormal style='line-height:120%;vertical-align:middle'><font size=3
color=navy face="Times New Roman"><span lang=EN-US style='font-size:12.0pt;
line-height:120%;color:navy'>num_init_children = 100<o:p></o:p></span></font></p>
<p class=MsoNormal style='line-height:120%;vertical-align:middle'><font size=3
color=navy face="Times New Roman"><span lang=EN-US style='font-size:12.0pt;
line-height:120%;color:navy'>max_pool = 5<o:p></o:p></span></font></p>
<p class=MsoNormal style='line-height:120%;vertical-align:middle'><font size=3
color=navy face="Times New Roman"><span lang=EN-US style='font-size:12.0pt;
line-height:120%;color:navy'>Pgpool 3.1.3 on solaris 10 (x86) and did not
encounter any problems with memory leaks.<o:p></o:p></span></font></p>
<p class=MsoNormal style='line-height:120%;vertical-align:middle'><font size=3
color=navy face="Times New Roman"><span lang=EN-US style='font-size:12.0pt;
line-height:120%;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='line-height:120%;vertical-align:middle'><font size=3
color=navy face="Times New Roman"><span lang=EN-US style='font-size:12.0pt;
line-height:120%;color:navy'>Did you have any other software running on server
with pgpool? Is this physical server or virtual machine? What is your solaris
version?<o:p></o:p></span></font></p>
<p class=MsoNormal style='line-height:120%;vertical-align:middle'><font size=3
color=navy face="Times New Roman"><span lang=EN-US style='font-size:12.0pt;
line-height:120%;color:navy'> <o:p></o:p></span></font></p>
<p class=MsoNormal style='line-height:120%;vertical-align:middle'><font size=3
color=navy face="Times New Roman"><span lang=EN-US style='font-size:12.0pt;
line-height:120%;color:navy'>Regards,<o:p></o:p></span></font></p>
<p class=MsoNormal style='line-height:120%;vertical-align:middle'><font size=3
color=navy face="Times New Roman"><span lang=EN-US style='font-size:12.0pt;
line-height:120%;color:navy'>Rafal<o:p></o:p></span></font></p>
<p class=MsoNormal style='line-height:120%;vertical-align:middle'><font size=3
color=navy face="Times New Roman"><span lang=EN-US style='font-size:12.0pt;
line-height:120%;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='line-height:120%;vertical-align:middle'><font size=1
color="#333333" face=Calibri><span lang=EN-US style='font-size:6.0pt;
line-height:120%;font-family:Calibri;color:#333333'><o:p> </o:p></span></font></p>
</div>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
caravinth@gmail.com [mailto:caravinth@gmail.com] <b><span style='font-weight:
bold'>On Behalf Of </span></b>Aravinth<br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, June 29, 2012 11:14
AM<br>
<b><span style='font-weight:bold'>To:</span></b> Kuczynski, Rafal (LNG-POL)<br>
<b><span style='font-weight:bold'>Cc:</span></b> <st1:PersonName w:st="on">pgpool-general@pgpool.net</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [pgpool-general: 677]
Re: strange load balancing issue in Solaris</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>Hi Rafal,<br>
<br>
The total RAM size is 16GB. Also pgpool was able to handle 300 connection for a
few hours.<br>
<br>
I have the same setup in centos machine with less RAM that runs without any
issues. The issue is only in solaris.<br>
<br>
Any thoughts..<br>
<br>
<br clear=all>
Regards,<br>
Aravinth<br>
<br>
<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>On Fri, Jun 29, 2012 at 2:34 PM, Kuczynski, Rafal (LNG-POL) <<a
href="mailto:Rafal.Kuczynski@lexisnexis.pl" target="_blank">Rafal.Kuczynski@lexisnexis.pl</a>>
wrote:<o:p></o:p></span></font></p>
<div link=blue vlink=blue>
<div>
<div>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
line-height:120%;vertical-align:middle'><font size=3 face="Times New Roman"><span
lang=EN-US style='font-size:12.0pt;line-height:120%'>> 2012-06-07 08:31:17
ERROR: pid 927: fork() failed. reason: Not enough space</span><o:p></o:p></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
line-height:120%;vertical-align:middle'><font size=3 face="Times New Roman"><span
lang=EN-US style='font-size:12.0pt;line-height:120%'> </span><o:p></o:p></font></p>
</div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
line-height:120%;vertical-align:middle'><font size=3 face="Times New Roman"><span
lang=EN-US style='font-size:12.0pt;line-height:120%'>This means you have ran
out of ram/swap space. Either you r server doesn’t have enough ram for
300 processes of pgpool, or you have problem with memory leaks.</span><o:p></o:p></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
line-height:120%;vertical-align:middle'><font size=3 face="Times New Roman"><span
lang=EN-US style='font-size:12.0pt;line-height:120%'>You have to monitor
ram/swap usage while pgpool is working.</span><o:p></o:p></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
line-height:120%;vertical-align:middle'><font size=3 face="Times New Roman"><span
lang=EN-US style='font-size:12.0pt;line-height:120%'> </span><o:p></o:p></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
line-height:120%;vertical-align:middle'><font size=3 face="Times New Roman"><span
lang=EN-US style='font-size:12.0pt;line-height:120%'>Regards,</span><o:p></o:p></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
line-height:120%;vertical-align:middle'><font size=3 face="Times New Roman"><span
lang=EN-US style='font-size:12.0pt;line-height:120%'>Rafal</span><o:p></o:p></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
line-height:120%;vertical-align:middle'><font size=3 face="Times New Roman"><span
lang=EN-US style='font-size:12.0pt;line-height:120%'> </span><o:p></o:p></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
line-height:120%;vertical-align:middle'><font size=3 color=navy
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt;line-height:
120%;color:navy'> </span></font><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
line-height:120%;vertical-align:middle'><font size=3 color=navy
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt;line-height:
120%;color:navy'> </span></font><o:p></o:p></p>
</div>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;font-weight:
bold'>From:</span></font></b><font size=2 face=Tahoma><span style='font-size:
10.0pt;font-family:Tahoma'> <a href="mailto:pgpool-general-bounces@pgpool.net"
target="_blank">pgpool-general-bounces@pgpool.net</a> [mailto:<a
href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-bounces@pgpool.net</a>]
<b><span style='font-weight:bold'>On Behalf Of </span></b>Aravinth<br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, June 29, 2012 10:51
AM<br>
<b><span style='font-weight:bold'>To:</span></b> Tatsuo Ishii<br>
<b><span style='font-weight:bold'>Cc:</span></b> <a
href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<b><span style='font-weight:bold'>Subject:</span></b> [pgpool-general: 674] Re:
strange load balancing issue in Solaris</span></font><o:p></o:p></p>
</div>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt'><font
size=3 face="Times New Roman"><span style='font-size:12.0pt'>Guys,<br>
<br>
I am facing another issue in same solaris.<br>
<br>
I have initialized 300 pre-forked connections using num_init_childresn in
streaming replication mode. Every thing works perfectly for a few hours.<br>
<br>
After a few hours the connections drop with the below error . Also pgpool
doesn't allow any new connections. <br>
<br>
Any ideas guys.....<br>
<br>
<br>
<br>
<br>
2012-06-07 08:31:15 DEBUG: pid 927: fork a new child pid 1645<br>
2012-06-07 08:31:15 DEBUG: pid 927: child 1413 exits with status 1 by signal 1<br>
2012-06-07 08:31:15 DEBUG: pid 1645: I am 1645<br>
2012-06-07 08:31:15 DEBUG: pid 1645: pool_initialize_private_backend_status:
initialize backend status<br>
2012-06-07 08:31:15 DEBUG: pid 927: fork a new child pid 1646<br>
2012-06-07 08:31:15 DEBUG: pid 927: child 1410 exits with status 1 by signal 1<br>
2012-06-07 08:31:15 DEBUG: pid 1646: I am 1646<br>
2012-06-07 08:31:15 DEBUG: pid 1646: pool_initialize_private_backend_status:
initialize backend status<br>
2012-06-07 08:31:17 ERROR: pid 927: fork() failed. reason: Not enough space<br>
2012-06-07 08:31:17 DEBUG: pid 2012-06-07 08:31:172012-06-07
08:31:1716382012-06-07 08:31:172012-06-07 08:31:17 DEBUG: pid 2012-06-07
08:31:172012-06-07 08:31:172012-06<br>
-07 08:31:17 DEBUG: pid 2012-06-07 08:31:172012-06-07 08:31:172012-06-07
08:31:172012-06-07 08:31:17: 2012-06-07 08:31:172012-06-07 08:31:172012-06-07
08:31:172012-06-0<br>
7 08:31:172012-06-07 08:31:172012-06-07 08:31:17 DEBUG: pid 2012-06-07
08:31:172012-06-07 08:31:172012-06-07 08:31:172012-06-07 08:31:172012-06-07
08:31:172012-06-07 08<br>
:31:172012-06-07 08:31:17 DEBUG: pid 2012-06-07 08:31:172012-06-07
08:31:172012-06-07 08:31:172012-06-07 08:31:1716402012-06-07 08:31:172012-06-07
08:31:17 DEBUG: pid 2<br>
012-06-07 08:31:172012-06-07 08:31:172012-06-07 08:31:172012-06-07
08:31:172012-06-07 08:31:17 DEBUG: pid DEBUG: pid 1637 DEBUG: pid
DEBUG: pid DEBUG: pid DEBUG: pi<br>
d child received shutdown request signal DEBUG: pid DEBUG:
pid DEBUG: pid DEBUG: pid DEBUG: pid DEBUG: pid 1641
DEBUG: pid DEBUG: pid DEBUG: pid DEBUG: pid DE<br>
BUG: pid DEBUG: pid DEBUG: pid 1642 DEBUG: pid DEBUG:
pid DEBUG: pid DEBUG: pid : DEBUG: pid DEBUG: pid 1636
DEBUG: pid DEBUG: pid DEBUG: pid DEBUG: pid DEBU<br>
G: pid 16341646: 163016351629163115163316431628164516441639:
1632162716251617161516261610: 1614162216181613child received shutdown request
signal 16191612: 161116231621<br>
16241620: : child received shutdown request signal : : : :<br>
: : : : : : child received shutdown request signal : : : : : : : child received
shutdown request signal : : : : 15: : child received shutdown request signal :
: : : : child received shutdown request signal child received shutdown request
signal 15child received shutdown request signal child received shutdown request
signal child received shutdown request signal child received shutdown request
signal child received shutdown request signal child received shutdown request
signal child received shutdown request signal child received shutdown request
signal child received shutdown request signal child received shutdown request
signal 15child received shutdown request signal child received shutdown request
signal child received shutdown request signal child received shutdown request
signal child received shutdown request signal child received shutdown request
signal child received shutdown request signal 15child received shutdown request
signal child received shutdown request signal child received shutdown request
signal child received shutdown request signal<br>
child received shutdown request signal child received shutdown request signal
15child received shutdown request signal child received shutdown request signal
child received shutdown request signal child received shutdown request signal
child received shutdown request signal 1515<br>
15151515151515151515<br>
15151515151515<br>
151515151515<br>
1515151515<br>
<br>
<br>
<br clear=all>
Regards,<br>
Aravinth<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=3 face="Times New Roman"><span style='font-size:12.0pt'>On Thu, May 10,
2012 at 8:15 AM, Tatsuo Ishii <<a href="mailto:ishii@postgresql.org"
target="_blank">ishii@postgresql.org</a>> wrote:<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=3 face="Times New Roman"><span style='font-size:12.0pt'>Good. Fix
committed in master/V3_1_STABLE/V3_0_STABLE.<o:p></o:p></span></font></p>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=3 face="Times New Roman"><span style='font-size:12.0pt'>--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
<br>
> It's working.<br>
><br>
> Regards,<br>
> Aravinth<br>
><br>
><br>
> On Wed, May 9, 2012 at 5:26 PM, Tatsuo Ishii <<a
href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>>
wrote:<br>
><br>
>> Thanks for the hint. Attached is a patch trying to fix the<br>
>> problem. Can you please try it?<br>
>> --<br>
>> Tatsuo Ishii<br>
>> SRA OSS, Inc. Japan<br>
>> English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
>> Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
>><br>
>> > Yes the issue is with random() function.<br>
>> ><br>
>> > Looks like I have solved the problem by using rand.<br>
>> ><br>
>> > Regards,<br>
>> > Aravinth<br>
>> ><br>
>> ><br>
>> > On Wed, May 9, 2012 at 4:02 PM, Tatsuo Ishii <<a
href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>><br>
>> wrote:<br>
>> ><br>
>> >> Thanks. Apparently random() of Solaris could return value
beyond<br>
>> >> RAND_MAX! It's easy to fix the problem, but I would like to
do it with<br>
>> >> respcet to portability. Any idea?<br>
>> >> --<br>
>> >> Tatsuo Ishii<br>
>> >> SRA OSS, Inc. Japan<br>
>> >> English: <a href="http://www.sraoss.co.jp/index_en.php"
target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
>> >> Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
>> >><br>
>> >> >>From Solaris 10 (x86) man page:<br>
>> >> ><br>
>> >> ><br>
>> >> > SYNOPSIS<br>
>> >> > #include <stdlib.h><br>
>> >> ><br>
>> >> > long random(void);<br>
>> >> ><br>
>> >> > void srandom(unsigned int seed);<br>
>> >> ><br>
>> >> > char *initstate(unsigned
int seed, char *state, size_t<br>
>> >> > size);<br>
>> >> ><br>
>> >> > char *setstate(const char *state);<br>
>> >> ><br>
>> >> > DESCRIPTION<br>
>> >> > The random() function uses a
nonlinear additive feedback<br>
>> >> > random-number generator employing a
default state array size<br>
>> >> > of 31 long integers
to return successive pseudo-random<br>
>> >> > numbers in the range from 0 to
2**31 -1. The period of this<br>
>> >> > random-number generator is
approximately 16 x (2 **31 -1).<br>
>> >> > The size of the
state array determines the period of the<br>
>> >> > random-number generator. Increasing
the state array size<br>
>> >> > increases the period.<br>
>> >> ><br>
>> >> > The srandom() function initializes
the current state array<br>
>> >> > using the value of seed.<br>
>> >> ><br>
>> >> ><br>
>> >> > (...)<br>
>> >> ><br>
>> >> ><br>
>> >> ><br>
>> >> > Regards,<br>
>> >> > Rafal<br>
>> >> ><br>
>> >> ><br>
>> >> ><br>
>> >> > -----Original Message-----<br>
>> >> > From: <a href="mailto:pgpool-general-bounces@pgpool.net"
target="_blank">pgpool-general-bounces@pgpool.net</a> [mailto:<br>
>> >> <a href="mailto:pgpool-general-bounces@pgpool.net"
target="_blank">pgpool-general-bounces@pgpool.net</a>] On Behalf Of Tatsuo
Ishii<br>
>> >> > Sent: Wednesday, May 09, 2012 11:44 AM<br>
>> >> > To: <a href="mailto:caravinth@gmail.com" target="_blank">caravinth@gmail.com</a><br>
>> >> > Cc: <a href="mailto:pgpool-general@pgpool.net"
target="_blank">pgpool-general@pgpool.net</a><br>
>> >> > Subject: [pgpool-general: 431] Re: strange load
balancing issue in<br>
>> >> Solaris<br>
>> >> ><br>
>> >> > Thanks.<br>
>> >> ><br>
>> >> > 2012-05-09 14:31:48 LOG: pid 22459: r:
268356063.000000<br>
>> total_weight:<br>
>> >> 32767.000000<br>
>> >> ><br>
>> >> > This is really weird. Here pgpool caculate this:<br>
>> >> ><br>
>> >> > r = (((double)random())/RAND_MAX) *
total_weight;<br>
>> >> ><br>
>> >> > Total weight is same as RAND_MAX. It seems your
random() returns<br>
>> >> > bigger than RAND_MAX, which does not make sense because
man page of<br>
>> >> > random(3) on my Linux says:<br>
>> >> ><br>
>> >> > The random() function
uses a non-linear additive feedback<br>
>> >> random number<br>
>> >> > generator employing a
default table of size 31 long integers<br>
>> to<br>
>> >> return<br>
>> >> > successive pseudo-random
numbers in the range from 0 to<br>
>> RAND_MAX.<br>
>> >> The<br>
>> >> > period of this
random number generator is very large,<br>
>> >> approximately<br>
>> >> > 16 * ((2^31) - 1).<br>
>> >> ><br>
>> >> > What does your man page for random() say on your system?<br>
>> >> > --<br>
>> >> > Tatsuo Ishii<br>
>> >> > SRA OSS, Inc. Japan<br>
>> >> > English: <a href="http://www.sraoss.co.jp/index_en.php"
target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
>> >> > Japanese: <a href="http://www.sraoss.co.jp"
target="_blank">http://www.sraoss.co.jp</a><br>
>> >> ><br>
>> >> >> Sorry . I missed it.<br>
>> >> >><br>
>> >> >> Here is the log file.<br>
>> >> >><br>
>> >> >> --Aravinth<br>
>> >> >><br>
>> >> >><br>
>> >> >> On Wed, May 9, 2012 at 2:07 PM, Tatsuo Ishii <<a
href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>><br>
>> >> wrote:<br>
>> >> >><br>
>> >> >>> > The code you have sent is same in child.c.<br>
>> >> >>><br>
>> >> >>> No.<br>
>> >> >>><br>
>> >> >>> pool_log("r: %f
total_weight: %f", r, total_weight);<br>
>> >> >>><br>
>> >> >>> You need to add the line above to get usefull
information.<br>
>> >> >>> --<br>
>> >> >>> Tatsuo Ishii<br>
>> >> >>> SRA OSS, Inc. Japan<br>
>> >> >>> English: <a
href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
>> >> >>> Japanese: <a href="http://www.sraoss.co.jp"
target="_blank">http://www.sraoss.co.jp</a><br>
>> >> >>><br>
>> >> >>><br>
>> >> >>> > I have attached the log file. Please check<br>
>> >> >>> ><br>
>> >> >>> ><br>
>> >> >>> > --Aravinth<br>
>> >> >>> ><br>
>> >> >>> ><br>
>> >> >>> > On Tue, May 8, 2012 at 6:20 AM, Tatsuo
Ishii <<br>
>> <a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>><br>
>> >> >>> wrote:<br>
>> >> >>> ><br>
>> >> >>> >> I suspect there's some portablity issue
with load balance code.<br>
>> The<br>
>> >> >>> >> actual source code is in
select_load_balancing_nodechild.c).<br>
>> >> >>> >> Please modify source code and connect
to pgpool by using psql.<br>
>> >> >>> >> Please send the log output.<br>
>> >> >>> >> --<br>
>> >> >>> >> Tatsuo Ishii<br>
>> >> >>> >> SRA OSS, Inc. Japan<br>
>> >> >>> >> English: <a
href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
>> >> >>> >> Japanese: <a
href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
>> >> >>> >><br>
>> >> >>> >> int select_load_balancing_node(void)<br>
>> >> >>> >> {<br>
>> >> >>> >> int
selected_slot;<br>
>> >> >>> >> double
total_weight,r;<br>
>> >> >>> >> int i;<br>
>> >> >>> >><br>
>> >> >>> >> /* choose a
backend in random manner with weight */<br>
>> >> >>> >>
selected_slot = MASTER_NODE_ID;<br>
>> >> >>> >> total_weight
= 0.0;<br>
>> >> >>> >><br>
>> >> >>> >> for
(i=0;i<NUM_BACKENDS;i++)<br>
>> >> >>> >> {<br>
>> >> >>> >>
if (VALID_BACKEND(i))<br>
>> >> >>> >>
{<br>
>> >> >>> >>
total_weight +=<br>
>> >> BACKEND_INFO(i).backend_weight;<br>
>> >> >>> >>
}<br>
>> >> >>> >> }<br>
>> >> >>> >> r =
(((double)random())/RAND_MAX) * total_weight;<br>
>> >> >>> >>
pool_log("r: %f total_weight: %f", r, total_weight);<br>
>> >> >>> <--<br>
>> >> >>> >> add this<br>
>> >> >>> >><br>
>> >> >>> >> total_weight
= 0.0;<br>
>> >> >>> >> for
(i=0;i<NUM_BACKENDS;i++)<br>
>> >> >>> >> {<br>
>> >> >>> >>
if (VALID_BACKEND(i) &&<br>
>> >> BACKEND_INFO(i).backend_weight ><br>
>> >> >>> >> 0.0)<br>
>> >> >>> >>
{<br>
>> >> >>> >>
if(r >= total_weight)<br>
>> >> >>> >>
selected_slot = i;<br>
>> >> >>> >>
else<br>
>> >> >>> >>
break;<br>
>> >> >>> >>
total_weight +=<br>
>> >> BACKEND_INFO(i).backend_weight;<br>
>> >> >>> >>
}<br>
>> >> >>> >> }<br>
>> >> >>> >><br>
>> >> >>> >>
pool_debug("select_load_balancing_node: selected backend<br>
>> id<br>
>> >> is<br>
>> >> >>> %d",<br>
>> >> >>> >> selected_slot);<br>
>> >> >>> >> return
selected_slot;<br>
>> >> >>> >> }<br>
>> >> >>> >><br>
>> >> >>> >><br>
>> >> >>> >> > Hi Tatsuo, Thanks for the reply.<br>
>> >> >>> >> ><br>
>> >> >>> >> > The normalized weights are 0.5 for
both nodes and the selected<br>
>> >> node is<br>
>> >> >>> >> always the same node. I hope then it's
srandom().<br>
>> >> >>> >> ><br>
>> >> >>> >> ><br>
>> >> >>> >> > Any idea to solve this srandom
issue<br>
>> >> >>> >> ><br>
>> >> >>> >> ><br>
>> >> >>> >> > Thanks and Regards,<br>
>> >> >>> >> > Aravinth<br>
>> >> >>> >> ><br>
>> >> >>> >> ><br>
>> >> >>> >> > ________________________________<br>
>> >> >>> >> > From: Tatsuo Ishii <<a
href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>><br>
>> >> >>> >> > To: <a
href="mailto:aravinth@mafiree.com" target="_blank">aravinth@mafiree.com</a><br>
>> >> >>> >> > Cc: <a
href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
>> >> >>> >> > Sent: Tuesday, May 1, 2012 4:41 AM<br>
>> >> >>> >> > Subject: Re: [pgpool-general: 396]
strange load balancing<br>
>> issue in<br>
>> >> >>> >> Solaris<br>
>> >> >>> >> ><br>
>> >> >>> >> > First of all please check
"normalized" weights are as you<br>
>> >> expected.<br>
>> >> >>> >> > Run "show pool_status;"
and see "backend_weight0",<br>
>> >> "backend_weight1"<br>
>> >> >>> >> > section. You see a floating point
numbers, which are the<br>
>> >> normalized<br>
>> >> >>> >> > weight between 0.0 and 1.0. If you
see both are 0.5, primary<br>
>> and<br>
>> >> >>> >> > standby are given same weight.<br>
>> >> >>> >> ><br>
>> >> >>> >> > If they are ok, I suspect
srandom() function behavior is<br>
>> different<br>
>> >> >>> >> > from other platforms. Pgpool-II
chooses the load balance node<br>
>> by<br>
>> >> using<br>
>> >> >>> >> > srandom().
select_load_balancing_node() is the function which<br>
>> is<br>
>> >> >>> >> > responsible for selecting the load
balance node. If you run<br>
>> >> pgpool-II<br>
>> >> >>> >> > with -d (debug) option, you will
see following in the log:<br>
>> >> >>> >> ><br>
>> >> >>> >> >
pool_debug("select_load_balancing_node: selected backend<br>
>> id is<br>
>> >> >>> %d",<br>
>> >> >>> >> selected_slot);<br>
>> >> >>> >> ><br>
>> >> >>> >> > If backend_weight in show
pool_status are fine but the line<br>
>> above<br>
>> >> >>> >> > always shows same number, it is
the sign that we have problem<br>
>> with<br>
>> >> >>> >> > srandom().<br>
>> >> >>> >> > --<br>
>> >> >>> >> > Tatsuo Ishii<br>
>> >> >>> >> > SRA OSS, Inc. Japan<br>
>> >> >>> >> > English: <a
href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
>> >> >>> >> > Japanese: <a
href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
>> >> >>> >> ><br>
>> >> >>> >> >> Hi All,<br>
>> >> >>> >> >><br>
>> >> >>> >> >> I am facing a strange issue in
load balancing with replication<br>
>> >> mode<br>
>> >> >>> set<br>
>> >> >>> >> to<br>
>> >> >>> >> >> true in Solaris. Load balancing
algorithm always select the<br>
>> same<br>
>> >> node<br>
>> >> >>> >> >> whatever may be the backend
weight<br>
>> >> >>> >> >><br>
>> >> >>> >> >> Here is the scenario.<br>
>> >> >>> >> >><br>
>> >> >>> >> >> I have a pgpool installed
installed in 1 server<br>
>> >> >>> >> >> 2 postgres nodes in other 2
servers<br>
>> >> >>> >> >> replication mode set to true
and load balancing set to true<br>
>> >> >>> >> >> backend weight of the 2 nodes
is 1.<br>
>> >> >>> >> >><br>
>> >> >>> >> >> When I fire the queries
manuall using different connections or<br>
>> >> using<br>
>> >> >>> >> >> pgbench all the queries hit
the same node. Load balancing<br>
>> >> algorithm<br>
>> >> >>> >> always<br>
>> >> >>> >> >> select the same node.<br>
>> >> >>> >> >> No effect in changing the
backend weight. Only when I set<br>
>> backend<br>
>> >> >>> >> weight to<br>
>> >> >>> >> >> 0 hits go to the other server.<br>
>> >> >>> >> >><br>
>> >> >>> >> >><br>
>> >> >>> >> >> I face this issue only in
solaris. The same setup in other<br>
>> >> servers (<br>
>> >> >>> >> centos<br>
>> >> >>> >> >> ,RHEL, ubunt etc) does the
load balancing perfectly.<br>
>> >> >>> >> >><br>
>> >> >>> >> >> Also tries various postgres
versions and pgpool version with<br>
>> same<br>
>> >> >>> >> result.<br>
>> >> >>> >> >> But every version runs fine in
other servers.<br>
>> >> >>> >> >><br>
>> >> >>> >> >> Has anyone faced this issue?<br>
>> >> >>> >> >><br>
>> >> >>> >> >> Any information would highly
helpful.<br>
>> >> >>> >> >><br>
>> >> >>> >> >> Regards,<br>
>> >> >>> >> >> Aravinth<br>
>> >> >>> >>
_______________________________________________<br>
>> >> >>> >> pgpool-general mailing list<br>
>> >> >>> >> <a
href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
>> >> >>> >> <a
href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
>> >> >>> >><br>
>> >> >>><br>
>> >> > _______________________________________________<br>
>> >> > pgpool-general mailing list<br>
>> >> > <a href="mailto:pgpool-general@pgpool.net"
target="_blank">pgpool-general@pgpool.net</a><br>
>> >> > <a
href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
>> >> > _______________________________________________<br>
>> >> > pgpool-general mailing list<br>
>> >> > <a href="mailto:pgpool-general@pgpool.net"
target="_blank">pgpool-general@pgpool.net</a><br>
>> >> > <a
href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
>> >> _______________________________________________<br>
>> >> pgpool-general mailing list<br>
>> >> <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
>> >> <a
href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
>> >><br>
>><br>
>> _______________________________________________<br>
>> pgpool-general mailing list<br>
>> <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
>> <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general"
target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
>><br>
>><br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><o:p></o:p></span></font></p>
</div>
</div>
</div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
</div>
</div>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><br>
_______________________________________________<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" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>