<div dir="rtl"><div dir="ltr">You mean psql from the pool server ? Yes I can connect succesfully and run queries : </div><div dir="ltr"><div dir="ltr">postgres@ptkpl-pgpool1:[~/pgpool/log][PROD-env] : psql -d bitbucket -U bitbucketuser -h 127.0.0.1 -p 9999</div><div dir="ltr">Password for user bitbucketuser: </div><div dir="ltr">psql (9.2.23, server 9.6.3)</div><div dir="ltr">WARNING: psql version 9.2, server version 9.6.</div><div dir="ltr"> Some psql features might not work.</div><div dir="ltr">Type "help" for help.</div><div dir="ltr"><br></div><div dir="ltr">bitbucket=> select * from AO_777666_JIRA_INDEX;</div><div>.....works</div><div><br></div><div>I will check my app, but it seems weird.</div><div>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 ?</div><div><br></div><div dir="ltr"><br></div><div dir="ltr"><br></div></div></div><div class="gmail_extra"><br><div class="gmail_quote"><div dir="ltr">2018-07-25 9:51 GMT+03:00 Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@sraoss.co.jp" target="_blank">ishii@sraoss.co.jp</a>></span>:</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Do you see the same error with psql? (start psql, send some queries,<br>
exit psql in proper way) If not, I still think you should check your<br>
applications.<br>
<div class="HOEnZb"><div class="h5"><br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_<wbr>en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.<wbr>jp</a><br>
<br>
> Hi tatsuo,<br>
> Are you sure about it ? It seems that I'm getting the same error for more<br>
> then one application. I dont think that the problem is with one app<br>
> <br>
> 2018-05-16 4:42 GMT+03:00 Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>>:<br>
> <br>
>> These errors typically appear when applications do not disconnect to<br>
>> Pgpool-II in proper way, or the network connection between<br>
>> applications and Pgpool-II are broken. So general suggestions are:<br>
>><br>
>> 1) Fix bug with the application<br>
>><br>
>> 2) Check the network<br>
>><br>
>> There are no configuration parameters that could deal with the<br>
>> problem.<br>
>><br>
>> Best regards,<br>
>> --<br>
>> Tatsuo Ishii<br>
>> SRA OSS, Inc. Japan<br>
>> English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_<wbr>en.php</a><br>
>> Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.<wbr>jp</a><br>
>><br>
>> > Hi,<br>
>> > Suddenly I found out that in the pool`s log I'm getting a lot of those<br>
>> > errors :<br>
>> ><br>
>> > [jiradb](jiradbuser) - 2018-05-10 23:58:57 - [unknown] [28259]ERROR:<br>
>> > unable to read data from frontend<br>
>> > [jiradb](jiradbuser) - 2018-05-10 23:58:57 - [unknown] [28259]DETAIL:<br>
>> > socket read failed with an error "Connection reset by peer"<br>
>> ><br>
>> > The application owner didnt complain about any problem but I dont like it<br>
>> > that I'm getting that error. This error is raised sometimes every 3-4<br>
>> > minutes and sometimes every 3 seconds..<br>
>> ><br>
>> > I can attach the logs if needed.<br>
>> ><br>
>> > Some pool parameters :<br>
>> > num_init_children = 32<br>
>> > max_pool = 4<br>
>> > child_life_time = 300<br>
>> > child_max_connections = 0<br>
>> > connection_life_time = 0<br>
>> > client_idle_limit = 0<br>
>> ><br>
>> > Do you recommend mybe to change those parameters ? Any idea why the error<br>
>> > is reaised ?<br>
>><br>
</div></div></blockquote></div><br></div>