<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Mar 2, 2016 at 12:52 AM, Burton, Chuck <span dir="ltr"><<a href="mailto:Chuck.Burton@arris.com" target="_blank">Chuck.Burton@arris.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div lang="EN-US" link="#0563C1" vlink="#954F72">
<div>
<p class="MsoNormal">We are running pgpool in our lab in a virtualized, dockerized environment with pgpool managing two streaming replicated Postgres nodes. I am running pgpool 3.5.0.1.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I am using pgbench to connect through pgpool:<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">/usr/pgsql-9.3/bin/pgbench -c 300 -r -j 5 -t 3334 -h pgpool -p 9999 dbname<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">What is happening is I’m getting frequent disconnects of the pcp worker:<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">2016-03-01 19:36:48: pid 5369: LOG: forked new pcp worker, pid=7377 socket=7<u></u><u></u></p>
<p class="MsoNormal">2016-03-01 19:36:48: pid 5369: LOG: PCP process with pid: 7377 exit with SUCCESS.<u></u><u></u></p>
<p class="MsoNormal">2016-03-01 19:36:48: pid 5369: LOG: PCP process with pid: 7377 exits with status 0<u></u><u></u></p>
<p class="MsoNormal">2016-03-01 19:36:48: pid 244: LOG: reload config files.<u></u><u></u></p>
<p class="MsoNormal">2016-03-01 19:36:48: pid 5370: LOG: reloading config file<u></u><u></u></p>
<p class="MsoNormal">2016-03-01 19:37:00: pid 5369: LOG: forked new pcp worker, pid=7433 socket=7<u></u><u></u></p>
<p class="MsoNormal">2016-03-01 19:37:00: pid 5369: LOG: PCP process with pid: 7433 exit with SUCCESS.<u></u><u></u></p>
<p class="MsoNormal">2016-03-01 19:37:00: pid 5369: LOG: PCP process with pid: 7433 exits with status 0<u></u><u></u></p>
<p class="MsoNormal">2016-03-01 19:37:00: pid 244: LOG: reload config files.<u></u><u></u></p>
<p class="MsoNormal">2016-03-01 19:37:03: pid 5370: LOG: reloading config file</p></div></div></blockquote><div><br></div><div>This is the normal life cycle of PCP command in pgpool-II 3.5. Previously pgpool-II could only handle single PCP command at a time and all PCP commands were handled by a single PCP child process which lives throughout the lifespan of pgpool-II main process.</div><div>This is now changed in the latest version 3.5. Now for every PCP command issued to pgpool a new PCP child process is forked and that process exits after execution of that PCP command is complete. So the LOG contains the messages about the creation and exit of a PCP worker process, which is perfectly normal.</div><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div lang="EN-US" link="#0563C1" vlink="#954F72"><div><p class="MsoNormal"><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Also, occasionally:<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">2016-03-01 19:36:18: pid 4497: FATAL: Backend throw an error message<u></u><u></u></p>
<p class="MsoNormal">2016-03-01 19:36:18: pid 4497: DETAIL: Exiting current session because of an error from backend<u></u><u></u></p>
<p class="MsoNormal">2016-03-01 19:36:18: pid 4497: HINT: BACKEND Error: "function pgpool_regclass(unknown) does not exist"</p></div></div></blockquote><div><br></div><div>This error message suggests that pgpool_regclass extension is not installed on the PostgreSQL backend.</div><div><a href="http://www.pgpool.net/mediawiki/index.php/FAQ#Why_do_I_need_to_install_pgpool_regclass.3F">http://www.pgpool.net/mediawiki/index.php/FAQ#Why_do_I_need_to_install_pgpool_regclass.3F</a><br></div><div><br></div><div>Regards</div><div>Muhammad Usama</div><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div lang="EN-US" link="#0563C1" vlink="#954F72"><div><p class="MsoNormal"><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">This happened six times during the five-minute pgbench test.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I am running with:<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">num_init_children = 1000<u></u><u></u></p>
<p class="MsoNormal"> # Number of pools<u></u><u></u></p>
<p class="MsoNormal"> # (change requires restart)<u></u><u></u></p>
<p class="MsoNormal">max_pool = 1<u></u><u></u></p>
<p class="MsoNormal"> # Number of connections per pool<u></u><u></u></p>
<p class="MsoNormal"> # (change requires restart)<u></u><u></u></p>
<p class="MsoNormal">listen_backlog_multiplier = 3<u></u><u></u></p>
<p class="MsoNormal">serialize_accept = on<u></u><u></u></p>
<p class="MsoNormal">child_life_time = 0<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Is this a problem with the pcp worker getting overwhelmed?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Looking at the new metrics on show pool_nodes I see that reads are being distributed.<u></u><u></u></p>
</div>
</div>
<br>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div></div>