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

Tatsuo Ishii ishii at sraoss.co.jp
Wed Jul 25 16:04:17 JST 2018


> 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 ?

Yes, you need to put the function names into the black function list.

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

> 
> 
> 
> 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 ?
>> >>
>>


More information about the pgpool-general mailing list