[pgpool-general: 6087] Re: ERROR: unable to read data from frontend
ishii at sraoss.co.jp
Wed May 16 10:42:43 JST 2018
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
SRA OSS, Inc. Japan
> 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] ERROR:
> unable to read data from frontend
> [jiradb](jiradbuser) - 2018-05-10 23:58:57 - [unknown] 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 ?
More information about the pgpool-general