<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<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);">
<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="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 03:41:23: pid 17816: WARNING:<span class="Apple-converted-space">
</span>child process with pid: 18034 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 03:41:23: pid 17816: LOG:<span class="Apple-converted-space">
</span>fork a new child process with pid: 19635</span></p>
<p class="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures">2021-03-26 03:43:19: pid 17816: WARNING:<span class="Apple-converted-space">
</span>child process with pid: 18720 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 03:43:19: pid 17816: LOG:<span class="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="p1" style="margin:0px;font:14px Monaco"><span class="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="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures"><span class="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="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures">Caused by: java.io.EOFException</span></p>
<p class="p1" style="margin:0px;font:14px Monaco"><span class="s1" style="font-variant-ligatures:no-common-ligatures"><span class="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="p1" style="margin:0px;font:14px Monaco"><span class="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>
</body>
</html>