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

Mariel Cherkassky mariel.cherkassky at gmail.com
Wed Jul 25 15:45:53 JST 2018


Hi tatsuo,
Are you sure about it ? It seems that I'm getting the same error for more
then one application. I dont think that the problem is with one app

2018-05-16 4:42 GMT+03:00 Tatsuo Ishii <ishii at sraoss.co.jp>:

> 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 ?
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180725/3eac8ab7/attachment.html>


More information about the pgpool-general mailing list