[pgpool-general: 5360] Re: ERROR: unable to read data

Tatsuo Ishii ishii at sraoss.co.jp
Tue Mar 7 16:06:04 JST 2017


Please consult the manual.

http://www.pgpool.net/docs/latest/en/html/runtime-config-connection-pooling.html#RUNTIME-CONFIG-CONNECTION-POOLING-SETTINGS

You can disable the behavior by setting client_idle_limit to 0.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

From: "Lazaro Garcia" <lazaro3487 at gmail.com>
Subject: [pgpool-general: 5359] ERROR: unable to read data
Date: Mon, 6 Mar 2017 16:41:26 -0500
Message-ID: <001901d296c2$6969f820$3c3de860$@gmail.com>

> I always see this error in pgpool log when client_idle_limit is reached,
> what this error means?
> 
>  
> 
> Regards.
> 
>  
> 
> Pgpool-II version 3.5.5
> 
>  
> 
>  
> 
> 2017-03-06 16:02:14: pid 46436: LOG:  child process with pid: 52081 exits
> with status 256
> 
> 2017-03-06 16:02:14: pid 46436: LOG:  fork a new child process with pid:
> 54858
> 
> 2017-03-06 16:02:27: pid 47717: ERROR:  unable to read data
> 
> 2017-03-06 16:02:27: pid 47717: DETAIL:  child connection forced to
> terminate due to client_idle_limit:300 is reached
> 
> 2017-03-06 16:02:39: pid 48476: ERROR:  unable to read data
> 
> 2017-03-06 16:02:39: pid 48476: DETAIL:  child connection forced to
> terminate due to client_idle_limit:300 is reached
> 
> 2017-03-06 16:07:27: pid 46436: LOG:  child process with pid: 47717 exits
> with status 256
> 
> 2017-03-06 16:07:27: pid 46436: LOG:  fork a new child process with pid:
> 55462
> 
> 2017-03-06 16:07:39: pid 46436: LOG:  child process with pid: 48476 exits
> with status 256
> 
> 2017-03-06 16:07:39: pid 46436: LOG:  fork a new child process with pid:
> 55483
> 
> 2017-03-06 16:14:57: pid 54850: ERROR:  unable to read data
> 
> 2017-03-06 16:14:57: pid 54850: DETAIL:  child connection forced to
> terminate due to client_idle_limit:300 is reached
> 
> 2017-03-06 16:18:37: pid 46436: LOG:  child process with pid: 54825 exits
> with status 256
> 
> 2017-03-06 16:18:37: pid 46436: LOG:  fork a new child process with pid:
> 56995
> 
> 2017-03-06 16:18:37: pid 46436: LOG:  child process with pid: 54797 exits
> with status 256
> 


More information about the pgpool-general mailing list