<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1531450770;
mso-list-type:hybrid;
mso-list-template-ids:1268913230 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Resolved, changed parameter from the default 32 to 128; num_init_children = 128
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#1F497D">Wolf<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> pgpool-general-bounces@pgpool.net [mailto:pgpool-general-bounces@pgpool.net]
<b>On Behalf Of </b>Wolf Schwurack<br>
<b>Sent:</b> Tuesday, July 23, 2013 9:22 AM<br>
<b>To:</b> 'pgpool-general@pgpool.net'<br>
<b>Subject:</b> [pgpool-general: 1924] load test fails<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I am running a load test on pgpool and it fails over at 40 clients 5 transaction and just hangs. When I run the same load test on the postgres database I can run 100 clients 10 transaction pre client with out any problems. Are there any
setting I can set on pgpool. I have pgpool running in debug mode but doesn’t tell me why its failing over.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">2 postgres servers Ubuntu 10.04.4 postgres 9.2.4 master/stream
<o:p></o:p></p>
<p class="MsoNormal">2 pgpool servers Ubuntu 10.04.4 pgpool-II version 3.2.5 using watchdog<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo2"><![if !supportLists]><span style="mso-list:Ignore">1.<span style="font:7.0pt "Times New Roman"">
</span></span><![endif]><u>This show load test on postgres database server completed<o:p></o:p></u></p>
<p class="MsoNormal"><b>$ pgbench -U test -c 100 -t 10 bench<o:p></o:p></b></p>
<p class="MsoNormal">starting vacuum...end.<o:p></o:p></p>
<p class="MsoNormal">transaction type: TPC-B (sort of)<o:p></o:p></p>
<p class="MsoNormal">scaling factor: 1<o:p></o:p></p>
<p class="MsoNormal">query mode: simple<o:p></o:p></p>
<p class="MsoNormal">number of clients: 100<o:p></o:p></p>
<p class="MsoNormal">number of threads: 1<o:p></o:p></p>
<p class="MsoNormal">number of transactions per client: 10<o:p></o:p></p>
<p class="MsoNormal">number of transactions actually processed: 1000/1000<o:p></o:p></p>
<p class="MsoNormal">tps = 279.137721 (including connections establishing)<o:p></o:p></p>
<p class="MsoNormal">tps = 445.681855 (excluding connections establishing)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo2"><![if !supportLists]><span style="mso-list:Ignore">2.<span style="font:7.0pt "Times New Roman"">
</span></span><![endif]> <u>Load test on pgpool – shows 30 clients 5 transaction completed and 40 clients 5 transaction hung
<o:p></o:p></u></p>
<p class="MsoNormal"><b>$ pgbench -h wd-pgtest.uen.org -U test -p 9999 -c 30 -t 5 bench<o:p></o:p></b></p>
<p class="MsoNormal">starting vacuum...end.<o:p></o:p></p>
<p class="MsoNormal">transaction type: TPC-B (sort of)<o:p></o:p></p>
<p class="MsoNormal">scaling factor: 1<o:p></o:p></p>
<p class="MsoNormal">query mode: simple<o:p></o:p></p>
<p class="MsoNormal">number of clients: 30<o:p></o:p></p>
<p class="MsoNormal">number of threads: 1<o:p></o:p></p>
<p class="MsoNormal">number of transactions per client: 5<o:p></o:p></p>
<p class="MsoNormal">number of transactions actually processed: 150/150<o:p></o:p></p>
<p class="MsoNormal">tps = 134.569579 (including connections establishing)<o:p></o:p></p>
<p class="MsoNormal">tps = 186.005908 (excluding connections establishing)<o:p></o:p></p>
<p class="MsoNormal"><b>$ pgbench -h wd-pgtest.uen.org -U test -p 9999 -c 40 -t 5 bench<o:p></o:p></b></p>
<p class="MsoNormal">starting vacuum...end.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo2"><![if !supportLists]><span style="mso-list:Ignore">3.<span style="font:7.0pt "Times New Roman"">
</span></span><![endif]> <u>Pgpool log file – This show at the time of the fail over but not why its failing
<o:p></o:p></u></p>
<p class="MsoNormal">2013-07-23 08:32:40 DEBUG: pid 1338: wd_lifecheck: checking pgpool 0 (pgtest-con2:9999)<o:p></o:p></p>
<p class="MsoNormal">2013-07-23 08:32:40 DEBUG: pid 1338: wd_lifecheck: OK, status: 2<o:p></o:p></p>
<p class="MsoNormal">2013-07-23 08:32:40 DEBUG: pid 1338: wd_lifecheck: checking pgpool 1 (pgtest-con1:9999)<o:p></o:p></p>
<p class="MsoNormal">2013-07-23 08:32:40 DEBUG: pid 1338: wd_lifecheck: NG, status: 3 life:1<o:p></o:p></p>
<p class="MsoNormal">2013-07-23 08:32:40 LOG: pid 1338: wd_lifecheck: lifecheck failed 3 times. pgpool 1 (pgtest-con1:9999) seems not to be working<o:p></o:p></p>
<p class="MsoNormal">2013-07-23 08:32:40 DEBUG: pid 1338: wd_stand_for_master: send the packet to be the new master<o:p></o:p></p>
<p class="MsoNormal">2013-07-23 08:32:40 LOG: pid 1338: wd_escalation: escalated to master pgpool<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> 0___ Wolfgang Schwurack<br>
c/ /'_ System/Database Administrator<br>
(*) \(*) Utah Education Network<br>
Tel: (801) 587-9444<br>
email: <u><span style="color:blue"><a href="wolf@uen.org">wolf@uen.org</a></span></u></span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>