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><br><div class="gmail_quote">On Fri, Jun 29, 2012 at 4:06 PM, Kuczynski, Rafal (LNG-POL) <span dir="ltr"><<a href="mailto:Rafal.Kuczynski@lexisnexis.pl" target="_blank">Rafal.Kuczynski@lexisnexis.pl</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<u></u>
<div link="blue" vlink="blue" lang="PL">
<div>
<div>
<div>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Arial"><span style="font-size:10.0pt;line-height:120%;font-family:Arial;color:navy" lang="EN-US">Size of my pgpool processes (after many days of work without restart)
is abort 12M (with configuration </span></font><font color="navy"><span style="color:navy" lang="EN-US">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><font color="navy" face="Arial"><span style="font-size:10.0pt;line-height:120%;font-family:Arial;color:navy" lang="EN-US"><u></u><u></u></span></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US">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<u></u><u></u></span></font></span></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US">100*5 creates 500 connections to the backend, 30*4 creates 120
connections to the backend.<u></u><u></u></span></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US">In your case 300*1 creates 300 connections to the backend,
what is your average size of the pgpool processes?<u></u><u></u></span></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US">Check it after start of pgpool and after few hours of work and
when you get the error.<u></u><u></u></span></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US"><u></u> <u></u></span></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US">Regards,<u></u><u></u></span></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US">Rafal<u></u><u></u></span></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US">P.S. I have Solaris 10 8/11 s10x_u10wos_17b X86</span></font><font color="navy"><span style="line-height:120%;color:navy" lang="EN-US"><u></u><u></u></span></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US"> </span></font><font color="#333333" face="Calibri" size="1"><span style="font-size:6.0pt;line-height:120%;font-family:Calibri;color:#333333" lang="EN-US"><u></u><u></u></span></font></p>
</div>
</div>
<div>
<div class="MsoNormal" style="text-align:center" align="center"><font face="Times New Roman" size="3"><span style="font-size:12.0pt">
<hr align="center" size="2" width="100%">
</span></font></div>
<p class="MsoNormal"><b><font face="Tahoma"><span style="font-size:10.0pt;font-family:Tahoma;font-weight:bold">From:</span></font></b><font 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></p><div><font face="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> <u></u><a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><u></u><br>
</font></div><font face="Tahoma"><b><span style="font-weight:bold">Subject:</span></b> Re: [pgpool-general: 680]
Re: strange load balancing issue in Solaris</font><u></u><u></u><p></p>
</div><div><div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><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 <u></u><u></u></span></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US">num_init_children = 300</span></font><u></u><u></u></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;color:navy" lang="EN-US">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 color="black" face="Comic Sans MS"><span style="font-size:10.0pt;font-family:"Comic Sans MS"">--Aravinth</span></font><br>
<br>
<u></u><u></u></p>
<div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><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:<u></u><u></u></span></font></p>
<div link="blue" vlink="blue">
<div>
<div>
<div>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US">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><u></u><u></u></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US">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><u></u><u></u></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%" lang="EN-US"> </span><u></u><u></u></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%">Although</span></font><span lang="EN-US">, I have configuration:</span><u></u><u></u></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US">num_init_children = 100</span></font><u></u><u></u></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US">max_pool = 5</span></font><u></u><u></u></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US">Pgpool 3.1.3 on solaris 10 (x86) and did not encounter any
problems with memory leaks.</span></font><u></u><u></u></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US"> </span></font><u></u><u></u></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US">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><u></u><u></u></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US"> </span></font><u></u><u></u></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US">Regards,</span></font><u></u><u></u></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US">Rafal</span></font><u></u><u></u></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US"> </span></font><u></u><u></u></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="#333333" face="Calibri" size="1"><span style="font-size:6.0pt;line-height:120%;font-family:Calibri;color:#333333" lang="EN-US"> </span></font><u></u><u></u></p>
</div>
</div>
<div>
<div class="MsoNormal" style="text-align:center" align="center"><font face="Times New Roman" size="3"><span style="font-size:12.0pt">
<hr align="center" size="2" width="100%">
</span></font></div>
<p class="MsoNormal"><b><font face="Tahoma"><span style="font-size:10.0pt;font-family:Tahoma;font-weight:bold">From:</span></font></b><font 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><u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:12.0pt"> <u></u><u></u></span></font></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><font face="Times New Roman" size="3"><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<u></u><u></u></span></font></p>
<div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><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:<u></u><u></u></span></font></p>
<div link="blue" vlink="blue">
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%" lang="EN-US">> 2012-06-07 08:31:17
ERROR: pid 927: fork() failed. reason: Not enough space</span><u></u><u></u></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%" lang="EN-US"> </span><u></u><u></u></font></p>
</div>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%" lang="EN-US">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><u></u><u></u></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%" lang="EN-US">You have to monitor
ram/swap usage while pgpool is working.</span><u></u><u></u></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%" lang="EN-US"> </span><u></u><u></u></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%" lang="EN-US">Regards,</span><u></u><u></u></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%" lang="EN-US">Rafal</span><u></u><u></u></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%" lang="EN-US"> </span><u></u><u></u></font></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US"> </span></font><u></u><u></u></p>
<p class="MsoNormal" style="line-height:120%;vertical-align:middle"><font color="navy" face="Times New Roman" size="3"><span style="font-size:12.0pt;line-height:120%;color:navy" lang="EN-US"> </span></font><u></u><u></u></p>
</div>
</div>
<div>
<div class="MsoNormal" style="text-align:center" align="center"><font face="Times New Roman" size="3"><span style="font-size:12.0pt">
<hr align="center" size="2" width="100%">
</span></font></div>
<p class="MsoNormal"><b><font face="Tahoma"><span style="font-size:10.0pt;font-family:Tahoma;font-weight:bold">From:</span></font></b><font 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><u></u><u></u></p>
</div>
<div>
<div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:12.0pt"> <u></u><u></u></span></font></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><font face="Times New Roman" size="3"><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<u></u><u></u></span></font></p>
<div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><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:<u></u><u></u></span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:12.0pt">Good. Fix
committed in master/V3_1_STABLE/V3_0_STABLE.<u></u><u></u></span></font></p>
<div>
<div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><br>
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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><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><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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><br>
>> 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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><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><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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><br>
>> >> 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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><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><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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><br>
>> >> > 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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><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><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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><br>
>> >> >>> 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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><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><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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><br>
>> >> >>> >> 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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><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><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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><br>
>> >> >>> >> > 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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><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><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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><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><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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><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><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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><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><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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><u></u><u></u></span></font></p>
</div>
</div>
</div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:12.0pt"> <u></u><u></u></span></font></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><font face="Times New Roman" size="3"><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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><u></u><u></u></span></font></p>
</div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:12.0pt"> <u></u><u></u></span></font></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><font face="Times New Roman" size="3"><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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><u></u><u></u></span></font></p>
</div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
</div></div></div>
</div>
<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);" class="wrc0" style="padding-right:16px;width:16px;height:16px"></span><span style="padding-right:16px;width:16px;min-height:16px"></span><br>
<br></blockquote></div><br>