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

[Tatsuo Ishii]

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