<div dir="ltr"><div dir="ltr">Thanks Ishii-san...<div><br></div><div>I have added %a to log_line_prefix and also using the conf file for 4.2 (attached)</div><div><br></div><div><p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">Ahsans-MacBook-Pro:bin ahsanhadi$ ./pgpool -f ~/pgpool.conf.sample_2 -n</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2020-06-22 21:38:17: pid 1471: process main:LOG: creating shared memory for request size: 2228224 </span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2020-06-22 21:38:17: pid 1471: process main:LOG: creating shared memory for request size: 1024 </span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2020-06-22 21:38:17: pid 1471: process main:LOG: creating shared memory for request size: 20 </span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2020-06-22 21:38:17: pid 1471: process main:LOG: creating shared memory for request size: 5264 </span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2020-06-22 21:38:17: pid 1471: process main:LOG: creating shared memory for request size: 4 </span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2020-06-22 21:38:17: pid 1471: process main:LOG: creating shared memory for request size: 6144 </span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2020-06-22 21:38:17: pid 1471: process main:LOG: health_check_stats_shared_memory_size: requested size: 12288</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2020-06-22 21:38:17: pid 1471: process main:LOG: creating shared memory for request size: 12288 </span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2020-06-22 21:38:17: pid 1471: process main:LOG: health_check_stats_shared_memory_size: requested size: 12288</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2020-06-22 21:38:17: pid 1471: process main:LOG: Setting up socket for :::9999</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2020-06-22 21:38:17: pid 1471: process main:LOG: Setting up socket for <a href="http://0.0.0.0:9999">0.0.0.0:9999</a></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2020-06-22 21:38:17: pid 1471: process main:LOG: find_primary_node_repeatedly: waiting for finding a primary node</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2020-06-22 21:38:17: pid 1471: process main:LOG: find_primary_node: primary node is 0</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2020-06-22 21:38:17: pid 1505: process main:LOG: creating shared memory for request size: 1 </span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2020-06-22 21:38:17: pid 1505: process main:FATAL: could not create shared memory for request size: 1</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2020-06-22 21:38:17: pid 1505: process main:DETAIL: attach to shared memory [id:917514] failed with reason: "Too many open files"</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2020-06-22 21:38:17: pid 1471: process main:LOG: pgpool-II successfully started. version 4.2devel (chichiriboshi)</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2020-06-22 21:38:17: pid 1471: process main:LOG: node status[0]: 1</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2020-06-22 21:38:17: pid 1471: process main:LOG: PCP child process with pid: 1505 exits with status 768</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2020-06-22 21:38:17: pid 1471: process main:FATAL: PCP child process exit with fatal error. exiting pgpool-II</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">Ahsans-MacBook-Pro:bin ahsanhadi$ </span></p></div><div><span style="font-variant-ligatures:no-common-ligatures"><br></span></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Jun 19, 2020 at 10:50 AM Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">It seems you are using pgpool.conf for Pgpool-II 4.1, rather than for<br>
master (4.2). I don't think this is directly related to the issue<br>
though.<br>
<br>
It might be helpful to add "%a" to the log_line_prefix to know what<br>
process spits the log:<br>
<br>
> 2020-06-19 09:42:33: pid 58219: FATAL: could not create shared memory for<br>
> request size: 1<br>
<br>
> Hi pgpool hackers,<br>
> <br>
> I am trying to test the WIP ldap patch with pgpool II master branch<br>
> (essentially 4.2), I am running into an issue while trying to start pgpool.<br>
> I am not facing this issue with pgpool II 4.1 stable branch.<br>
> <br>
> I am attaching my sample pgpool configuration, the shared relcache is<br>
> disabled and i also reduced the number of num_jnit_childeren to 2 but still<br>
> no luck...<br>
> <br>
> Ahsans-MacBook-Pro:bin ahsanhadi$<br>
> <br>
> Ahsans-MacBook-Pro:bin ahsanhadi$ ./pgpool -f ~/pgpool.conf.sample -n<br>
> <br>
> 2020-06-19 09:42:33: pid 58215: LOG: creating shared memory for request<br>
> size: 139264<br>
> <br>
> 2020-06-19 09:42:33: pid 58215: LOG: creating shared memory for request<br>
> size: 64<br>
> <br>
> 2020-06-19 09:42:33: pid 58215: LOG: creating shared memory for request<br>
> size: 20<br>
> <br>
> 2020-06-19 09:42:33: pid 58215: LOG: creating shared memory for request<br>
> size: 5264<br>
> <br>
> 2020-06-19 09:42:33: pid 58215: LOG: creating shared memory for request<br>
> size: 4<br>
> <br>
> 2020-06-19 09:42:33: pid 58215: LOG: creating shared memory for request<br>
> size: 6144<br>
> <br>
> 2020-06-19 09:42:33: pid 58215: LOG:<br>
> health_check_stats_shared_memory_size: requested size: 12288<br>
> <br>
> 2020-06-19 09:42:33: pid 58215: LOG: creating shared memory for request<br>
> size: 12288<br>
> <br>
> 2020-06-19 09:42:33: pid 58215: LOG:<br>
> health_check_stats_shared_memory_size: requested size: 12288<br>
> <br>
> 2020-06-19 09:42:33: pid 58215: LOG: Setting up socket for :::9999<br>
> <br>
> 2020-06-19 09:42:33: pid 58215: LOG: Setting up socket for <a href="http://0.0.0.0:9999" rel="noreferrer" target="_blank">0.0.0.0:9999</a><br>
> <br>
> 2020-06-19 09:42:33: pid 58215: LOG: find_primary_node_repeatedly: waiting<br>
> for finding a primary node<br>
> <br>
> 2020-06-19 09:42:33: pid 58215: LOG: find_primary_node: primary node is 0<br>
> <br>
> 2020-06-19 09:42:33: pid 58219: LOG: creating shared memory for request<br>
> size: 1<br>
> <br>
> 2020-06-19 09:42:33: pid 58219: FATAL: could not create shared memory for<br>
> request size: 1<br>
> <br>
> 2020-06-19 09:42:33: pid 58219: DETAIL: attach to shared memory<br>
> [id:589837] failed with reason: "Too many open files"<br>
> <br>
> 2020-06-19 09:42:33: pid 58215: LOG: pgpool-II successfully started.<br>
> version 4.2devel (chichiriboshi)<br>
> <br>
> 2020-06-19 09:42:33: pid 58215: LOG: node status[0]: 1<br>
> <br>
> 2020-06-19 09:42:33: pid 58215: LOG: PCP child process with pid: 58219<br>
> exits with status 768<br>
> <br>
> 2020-06-19 09:42:33: pid 58215: FATAL: PCP child process exit with fatal<br>
> error. exiting pgpool-II<br>
> <br>
> Ahsans-MacBook-Pro:bin ahsanhadi$ vim ~/pgpool.conf.sample<br>
> <br>
> Thanks,<br>
> <br>
> Ahsan<br>
> -- <br>
> Highgo Software (Canada/China/Pakistan)<br>
> URL : <a href="http://www.highgo.ca" rel="noreferrer" target="_blank">http://www.highgo.ca</a><br>
> ADDR: 10318 WHALLEY BLVD, Surrey, BC<br>
> EMAIL: mailto: <a href="mailto:ahsan.hadi@highgo.ca" target="_blank">ahsan.hadi@highgo.ca</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><span style="color:rgb(0,0,0);font-family:Lato;font-size:14px">Highgo Software (Canada/China/Pakistan)</span><br style="color:rgb(0,0,0);font-family:Lato;font-size:14px"><span style="color:rgb(0,0,0);font-family:Lato;font-size:14px">URL : </span><a href="http://www.highgo.ca/" style="color:rgb(89,143,222);font-family:Lato;font-size:14px" target="_blank">http://www.highgo.ca</a><br style="color:rgb(0,0,0);font-family:Lato;font-size:14px"><span style="color:rgb(0,0,0);font-family:Lato;font-size:14px">ADDR: 10318 WHALLEY BLVD, Surrey, BC</span><br style="color:rgb(0,0,0);font-family:Lato;font-size:14px"><span style="color:rgb(0,0,0);font-family:Lato;font-size:14px">EMAIL: mailto: </span><a style="color:rgb(89,143,222);font-family:Lato;font-size:14px">ahsan.hadi@highgo.ca</a><br></div></div>