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

[Mariel Cherkassky]

You mean psql from the pool server ?  Yes I can connect succesfully and run
queries :
postgres at ptkpl-pgpool1:[~/pgpool/log][PROD-env] : psql -d bitbucket -U
bitbucketuser -h 127.0.0.1 -p 9999
Password for user bitbucketuser:
psql (9.2.23, server 9.6.3)
WARNING: psql version 9.2, server version 9.6.
         Some psql features might not work.
Type "help" for help.

bitbucket=> select * from AO_777666_JIRA_INDEX;
.....works

I will check my app, but it seems weird.
Another question, if my app uses functions, then I should put them in the
pgpool.conf in the blacklist functions so that those functios will be
forwarded to the master right ?




2018-07-25 9:51 GMT+03:00 Tatsuo Ishii <ishii at sraoss.co.jp>:

> Do you see the same error with psql? (start psql, send some queries,
> exit psql in proper way) If not, I still think you should check your
> applications.
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
> > 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/9cbf88a6/attachment.html>