<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="margin:0px;font-size:12pt;color:black;background-color:rgb(255, 255, 255)"><br>
</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="margin:0px;font-size:12pt;color:black;background-color:rgb(255, 255, 255)">BTW, I am using Pgpool-II 4.2.2 with single instance of PostgreSQL as a backend node. Also, after a series of <span style="font-family:Monaco;font-size:14px;font-variant-ligatures:no-common-ligatures;background-color:rgb(255, 255, 255);display:inline !important">segmentation
fault errors pgpool going into a bad state with errors "<span style="font-variant-ligatures:no-common-ligatures;background-color:rgb(255, 255, 255);display:inline !important">ERROR:</span><span class="Apple-converted-space" style="margin:0px;font-variant-ligatures:no-common-ligatures;background-color:rgb(255, 255, 255)"> <span> </span></span><span style="font-variant-ligatures:no-common-ligatures;background-color:rgb(255, 255, 255);display:inline !important">Sorry,
too many clients already</span>". </span></span></div>
<div style="color: rgb(0, 0, 0);"><span style="margin: 0px; color: black; background-color: rgb(255, 255, 255);"><font face="Monaco"><span style="font-size: 14px; font-variant-ligatures: no-common-ligatures;"><br>
</span></font></span></div>
<div style="color: rgb(0, 0, 0);"><span style="margin: 0px; color: black; background-color: rgb(255, 255, 255);"><font face="Monaco"><span style="font-size: 14px; font-variant-ligatures: no-common-ligatures;">Any pointers around the issue is really appreciated.
Please let me know if need to raise a mantis ticket for tracking this issue. <br>
</span></font></span><br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<p class="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 04:06:56: pid 17816: LOG:<span class="Apple-converted-space">
</span>fork a new child process with pid: 24196</span></p>
<p class="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 04:07:35: pid 17816: WARNING:<span class="Apple-converted-space">
</span>child process with pid: 23965 was terminated by segmentation fault</span></p>
<p class="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 04:07:35: pid 17816: LOG:<span class="Apple-converted-space">
</span>fork a new child process with pid: 24257</span></p>
<p class="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 04:08:20: pid 17816: WARNING:<span class="Apple-converted-space">
</span>child process with pid: 24189 was terminated by segmentation fault</span></p>
<p class="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 04:08:20: pid 17816: LOG:<span class="Apple-converted-space">
</span>fork a new child process with pid: 24314</span></p>
<p class="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 04:08:23: pid 17816: WARNING:<span class="Apple-converted-space">
</span>child process with pid: 24196 was terminated by segmentation fault</span></p>
<p class="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 04:08:23: pid 17816: LOG:<span class="Apple-converted-space">
</span>fork a new child process with pid: 24325</span></p>
<p class="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 04:08:43: pid 17816: WARNING:<span class="Apple-converted-space">
</span>child process with pid: 24181 was terminated by segmentation fault</span></p>
<p class="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 04:08:43: pid 17816: LOG:<span class="Apple-converted-space">
</span>fork a new child process with pid: 24348</span></p>
<p class="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 04:08:47: pid 24314: LOG:<span class="Apple-converted-space">
</span>failed to delete cache on memcached, error:"NOT FOUND"</span></p>
<p class="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 04:09:00: pid 24325: ERROR:<span class="Apple-converted-space">
</span>Sorry, too many clients already</span></p>
<p class="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 04:09:00: pid 24325: ERROR:<span class="Apple-converted-space">
</span>Sorry, too many clients already</span></p>
<p class="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 04:09:00: pid 24325: ERROR:<span class="Apple-converted-space">
</span>Sorry, too many clients already</span></p>
<p class="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 04:09:01: pid 20135: ERROR:<span class="Apple-converted-space">
</span>Sorry, too many clients already</span></p>
<p class="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 04:09:03: pid 17816: WARNING:<span class="Apple-converted-space">
</span>child process with pid: 24314 was terminated by segmentation fault</span></p>
<p class="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 04:09:03: pid 17816: LOG:<span class="Apple-converted-space">
</span>fork a new child process with pid: 24506</span></p>
<p class="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 04:09:04: pid 24506: ERROR:<span class="Apple-converted-space">
</span>Sorry, too many clients already</span></p>
<p class="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 04:09:07: pid 23723: ERROR:<span class="Apple-converted-space">
</span>Sorry, too many clients already</span></p>
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thanks,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Giri</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Madathala, Giridhar R<br>
<b>Sent:</b> Thursday, March 25, 2021 11:51 PM<br>
<b>To:</b> pgpool-general@pgpool.net <pgpool-general@pgpool.net><br>
<b>Subject:</b> Pgpool child process with pid: XXXXX was terminated by segmentation fault</font>
<div> </div>
</div>
<style type="text/css" style="display:none">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
<div dir="ltr">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<a href="mailto:pgpool-general@pgpool.net" style="font-family:Times; font-size:medium; background-color:rgb(255,255,255)"></a>Hi,</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
I have been running into segmentation fault<span style="background-color:rgb(255,255,255); display:inline!important"> </span>errors with pgpool only when using in-memory caching (<span style="background-color:rgb(255,255,255); display:inline!important">memory_cache_enabled
= on). When <span style="background-color:rgb(255,255,255); display:inline!important">
memory_cache_enabled is off, not really seeing any such issues. </span>Any clue on what might be happening or if i missing something? </span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Pgpool errors:</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<p class="x_p1" style="margin:0px; font:14px Monaco"><span class="x_s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 03:41:23: pid 17816: WARNING:<span class="x_Apple-converted-space">
</span>child process with pid: 18034 was terminated by segmentation fault</span></p>
<p class="x_p1" style="margin:0px; font:14px Monaco"><span class="x_s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 03:41:23: pid 17816: LOG:<span class="x_Apple-converted-space">
</span>fork a new child process with pid: 19635</span></p>
<p class="x_p1" style="margin:0px; font:14px Monaco"><span class="x_s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 03:43:19: pid 17816: WARNING:<span class="x_Apple-converted-space">
</span>child process with pid: 18720 was terminated by segmentation fault</span></p>
<p class="x_p1" style="margin:0px; font:14px Monaco"><span class="x_s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 03:43:19: pid 17816: LOG:<span class="x_Apple-converted-space">
</span>fork a new child process with pid: 19683</span></p>
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Client App Errors (Java): </div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<p class="x_p1" style="margin:0px; font:14px Monaco"><span class="x_s1" style="font-variant-ligatures:no-common-ligatures">Caused by: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.</span></p>
<p class="x_p1" style="margin:0px; font:14px Monaco"><span class="x_s1" style="font-variant-ligatures:no-common-ligatures"><span class="x_Apple-tab-span"></span>at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:336) ~[postgresql-42.2.6.jar:42.2.6]</span></p>
..</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
..</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<p class="x_p1" style="margin:0px; font:14px Monaco"><span class="x_s1" style="font-variant-ligatures:no-common-ligatures">Caused by: java.io.EOFException</span></p>
<p class="x_p1" style="margin:0px; font:14px Monaco"><span class="x_s1" style="font-variant-ligatures:no-common-ligatures"><span class="x_Apple-tab-span"></span>at org.postgresql.core.PGStream.receiveChar(PGStream.java:323) ~[postgresql-42.2.6.jar:42.2.6]</span></p>
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span style="margin:0px; font-size:12pt"><br>
</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span style="margin:0px; font-size:12pt"><br>
</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span style="margin:0px; font-size:12pt"><br>
</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span style="margin:0px; font-size:12pt">pgpool.conf configuration ( 1 backend node)</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span style="margin:0px; font-size:12pt"> </span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
<div style="margin:0px; font-size:12pt">backend_clustering_mode = 'raw'
<div style="margin:0px">listen_addresses = '127.0.0.1'</div>
port = 5432</div>
<div style="margin:0px; font-size:12pt">
<p class="x_p1" style="margin:0px; font:14px Monaco"><span class="x_s1" style="font-variant-ligatures:no-common-ligatures">backend_flag0 = 'ALWAYS_PRIMARY'</span></p>
<br>
</div>
<span style="margin:0px; font-size:12pt"></span>enable_pool_hba = on
<div>pool_passwd = ''</div>
<div>authentication_timeout = 1min</div>
<div>allow_clear_text_frontend_auth = on</div>
ssl = on<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
num_init_children = 48
<div>max_pool = 6</div>
<div>listen_backlog_multiplier = 4</div>
serialize_accept = on<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
memory_cache_enabled = on
<div>memqcache_method = 'memcached'</div>
<div>memqcache_memcached_host = '127.0.0.1'</div>
<div>memqcache_memcached_port = 11211</div>
<div>memqcache_total_size = 128MB</div>
<div>memqcache_expire = 3600<br>
</div>
<div>memqcache_auto_cache_invalidation = on</div>
<div>memqcache_maxcache = 512kB</div>
memqcache_cache_block_size = 1MB<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Thanks,</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Giri</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
</div>
</body>
</html>