<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;}
@font-face
{font-family:"Comic Sans MS";
panose-1:3 15 7 2 3 3 2 2 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;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.Stylwiadomocie-mail19
{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><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'>Yes, my config is streaming replication of two
postgres 9.0.x nodes. Load balance is off.<font color=navy><span
style='color:navy'><o:p></o:p></span></font></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'>Regards,</span><o:p></o:p></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'>Rafal</span><o:p></o:p></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>
<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>
<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> Saturday, June 30, 2012 6:48
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: 682]
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>
I shall try this.<br>
<br>
Was you configuration in streaming replication mode?<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 4:06 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>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
line-height:120%;vertical-align:middle'><font size=2 color=navy face=Arial><span
lang=EN-US style='font-size:10.0pt;line-height:120%;font-family:Arial;
color:navy'>Size of my pgpool processes (after many days of work without
restart) is abort 12M (with configuration </span></font><font color=navy><span
lang=EN-US style='color:navy'>num_init_children = 100</span></font><span
lang=EN-US> <font color=navy><span style='color:navy'>max_pool = 5
child_life_time 300)</span></font></span><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'>I have another pgpool (num_init_children = 30</span></font><span
lang=EN-US> <font color=navy><span style='color:navy'>max_pool = 4
child_life_time 300) and size of the processes is about 4M</span></font></span><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'>100*5 creates 500 connections to the backend, 30*4 creates 120
connections to the backend.</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'>In your case 300*1 creates 300 connections to the backend,
what is your average size of the pgpool processes?</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'>Check it after start of pgpool and after few hours of work and
when you get the error.</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>
<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'>Regards,</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'>Rafal</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'>P.S. I have Solaris 10 8/11 s10x_u10wos_17b X86</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'> Aravinth [mailto:<a
href="mailto:caravinth@gmail.com" target="_blank">caravinth@gmail.com</a>] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, June 29, 2012 11:45
AM</span></font><o:p></o:p></p>
<div>
<p class=MsoNormal><font size=3 face=Tahoma><span style='font-size:12.0pt;
font-family:Tahoma'><br>
<b><span style='font-weight:bold'>To:</span></b> Kuczynski, Rafal (LNG-POL)<br>
<b><span style='font-weight:bold'>Cc:</span></b> <a
href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a></span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><b><font size=3 face=Tahoma><span style='font-size:12.0pt;
font-family:Tahoma;font-weight:bold'>Subject:</span></font></b><font
face=Tahoma><span style='font-family:Tahoma'> Re: [pgpool-general: 680] 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;mso-margin-bottom-alt:auto'><font
size=3 face="Times New Roman"><span style='font-size:12.0pt'>Hi Rafal,<br>
<br>
Thanks for the reply. <br>
Its Solaris 10 64 Bit(Oracle Solaris 10 9/10 s10s_u9wos_14a SPARC)<br>
<br>
In my configuration I have <o:p></o:p></span></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'>num_init_children = 300</span></font><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt'><font
size=3 color=navy face="Times New Roman"><span lang=EN-US style='font-size:
12.0pt;color:navy'>max_pool = 1<br>
child_life_time =
300
<br>
child_max_connections =
0
<br>
connection_life_time =
0
<br>
client_idle_limit =1000<br>
</span></font><br>
<br clear=all>
<font size=2 color=black face="Comic Sans MS"><span style='font-size:10.0pt;
font-family:"Comic Sans MS";color:black'>--Aravinth</span></font><o:p></o:p></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 Fri, Jun 29,
2012 at 3:06 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>
<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'>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?</span><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'>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.</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 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
style='font-size:12.0pt;line-height:120%'>Although</span></font><span
lang=EN-US>, I have configuration:</span><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'>num_init_children = 100</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'>max_pool = 5</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'>Pgpool 3.1.3 on solaris 10 (x86) and did not encounter any
problems with memory leaks.</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>
<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'>Did you have any other software running on server with pgpool?
Is this physical server or virtual machine? What is your solaris version?</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>
<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'>Regards,</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'>Rafal</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>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
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'> </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:caravinth@gmail.com" target="_blank">caravinth@gmail.com</a>
[mailto:<a href="mailto:caravinth@gmail.com" target="_blank">caravinth@gmail.com</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 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> <a
href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><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>
<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'>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<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 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><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><br>
</span>Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><br>
</span><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><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><br>
</span>>> Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><br>
</span>>><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><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><br>
</span>>> >> Japanese: <a href="http://www.sraoss.co.jp"
target="_blank">http://www.sraoss.co.jp</a><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><br>
</span>>> >><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><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><br>
</span>>> >> > Japanese: <a href="http://www.sraoss.co.jp"
target="_blank">http://www.sraoss.co.jp</a><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><br>
</span>>> >> ><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><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><br>
</span>>> >> >>> Japanese: <a
href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><br>
</span>>> >> >>><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><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><br>
</span>>> >> >>> >> Japanese: <a
href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><br>
</span>>> >> >>> >><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><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><br>
</span>>> >> >>> >> > Japanese: <a
href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><br>
</span>>> >> >>> >> ><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><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><br>
</span>>> >> >>> >><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><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><br>
</span>>> >> > _______________________________________________<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><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><br>
</span>>> >> _______________________________________________<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><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><br>
</span>>> >><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><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><br>
</span>>><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><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><o:p></o:p></span></font></p>
</div>
</div>
</div>
</span>
<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='mso-margin-top-alt:auto;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" 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><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><o:p></o:p></span></font></p>
</div>
</span>
<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='mso-margin-top-alt:auto;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" 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><span
onmouseout="cancel = false; window.setTimeout(WRCHideContent, 1000); clearTimeout(showTimer);"
onmouseover=" var self = this; showTimer = window.setTimeout(function(){WRCShowContent({'rating':{'value':-1,'weight':-1},'flags':{'shopping':null,'social':null,'news':null,'it':null,'corporate':null,'pornography':null,'violence':null,'gambling':null,'drugs':null,'illegal':null},'single':true,'ttl':null}, self.className)},600);"><o:p></o:p></span></font></p>
</div>
</span>
<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" 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>
<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>