[pgpool-general: 6087] Re: [28259]ERROR: unable to read data from frontend

[Tatsuo Ishii]

These errors typically appear when applications do not disconnect to
Pgpool-II in proper way, or the network connection between
applications and Pgpool-II are broken. So general suggestions are:

1) Fix bug with the application

2) Check the network

There are no configuration parameters that could deal with the
problem.

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

> Hi,
> Suddenly I found out that in the pool`s log I'm getting a lot of those
> errors :
> 
> [jiradb](jiradbuser) - 2018-05-10 23:58:57 - [unknown] [28259]ERROR:
> unable to read data from frontend
> [jiradb](jiradbuser) - 2018-05-10 23:58:57 - [unknown] [28259]DETAIL:
> socket read failed with an error "Connection reset by peer"
> 
> The application owner didnt complain about any problem but I dont like it
> that I'm getting that error. This error is raised sometimes every 3-4
> minutes and sometimes every 3 seconds..
> 
> I can attach the logs if needed.
> 
> Some pool parameters :
> num_init_children = 32
> max_pool = 4
> child_life_time = 300
> child_max_connections = 0
> connection_life_time = 0
> client_idle_limit = 0
> 
> Do you recommend mybe to change those parameters ? Any idea why the error
> is reaised ?