[pgpool-general: 8202] Re: unable to read data from frontend

[Nikola(HM)]

Hello,

Thank you for reply.

In pgpool source code I found this error message raising  in 
"utils\pool_stream.c":

             else
             {
                 /*
                  * if backend offers authentication method, frontend could
                  * close connection
                  */
                 ereport(FRONTEND_ERROR,
                         (errmsg("unable to read data from frontend"),
                          errdetail("EOF encountered with frontend")));
             }

I would like to understand the comment here - "if backend offers 
authentication method, frontend could close connection".

Could you clarify comment of this error message?


Regards,
    Nikola

On 02.06.2022 08:24, Tatsuo Ishii wrote:
>> Hello,
>>
>> Pgpool works in Kubernetes with 3 replicas. Docker image
>> pgpool/pgpool:4.2.2 is used.
>>
>> One of the clients of Pgpool is Kong API Gateway. Periodically the
>> follow error log message is appeared in Pgpool log:
>>
>> -----------------------------
>>
>> pgmoon [10170] kong at kongdb |ERROR:  unable to read data from frontend
>> pgmoon [10170] kong at kongdb |DETAIL:  EOF encountered with frontend
>>
>> -----------------------------
>>
>> pgmoon is a PostgreSQL client library that is used by Kong.
>>
>> My questions are:
>>
>> 1. Why is this error happening?
> It has been already answered here:
> https://www.pgpool.net/pipermail/pgpool-general/2021-December/008014.html
>
>> 2. How I can fix it?
> Ask the pgmoon developer to fix it.
>
>> 3. How does this bug seriously affect the stability and performance of
>> Pgpool?
> There should be no concern about Pgpool stability. It may affect the
> performance of Pgpool if the error happens too frequently though,
> because of the extra logging of the error message.
>
> Best reagards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp