[pgpool-general: 7625] Re: Pgpool ERROR: unable to read data from frontend

valsaraj pv valsarajpv at gmail.com
Fri Jul 2 16:47:08 JST 2021


This is where I get this error in log:
-bash-4.2$ psql -h 192.168.100.116 -p 9999 -U pgpool postgres -c "show
pool_nodes"
Password for user pgpool:

While prompting for password:
2021-07-02 03:45:23: pid 155112: LOG:  pool_ssl: "SSL_read": "no SSL error
reported"
2021-07-02 03:45:23: pid 155112: ERROR:  unable to read data from frontend
2021-07-02 03:45:23: pid 155112: DETAIL:  socket read failed with error
"Success"

On Fri, Jul 2, 2021 at 6:45 AM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> Did not reproduce here.
>
> > Yes
> >
> > On Thu, 1 Jul 2021, 8:18 pm Tatsuo Ishii, <ishii at sraoss.co.jp> wrote:
> >
> >> > This usually comes when we run the show pool status command from the
> >> > terminal with psql.
> >>
> >> Are you saying that just running "psql -c 'show pool_status' "
> >> produces the error?
> >>
> >> > On Thu, Jul 1, 2021 at 7:55 PM Tatsuo Ishii <ishii at sraoss.co.jp>
> wrote:
> >> >
> >> >> > Hi,
> >> >> >
> >> >> > We see the following logs:
> >> >> > 2021-06-30 07:37:40: pid 83319: LOG:  pool_ssl: "SSL_read": "no SSL
> >> error
> >> >> > reported"
> >> >> > 2021-06-30 07:37:40: pid 83319: ERROR:  unable to read data from
> >> frontend
> >> >> > 2021-06-30 07:37:40: pid 83319: DETAIL:  socket read failed with
> error
> >> >> > "Success"
> >> >> >
> >> >> > Any idea what might be causing this?
> >> >>
> >> >> A client closed the connection to Pgpool-II without proper protocol
> >> >> step. Or it is possible that there was a network issue between the
> >> >> client and Pgpool-II.
> >> >>
> >> >> Best regards,
> >> >> --
> >> >> Tatsuo Ishii
> >> >> SRA OSS, Inc. Japan
> >> >> English: http://www.sraoss.co.jp/index_en.php
> >> >> Japanese:http://www.sraoss.co.jp
> >> >>
> >> >
> >> >
> >> > --
> >> > Life is like this: "Just when we get all the answers of life.... God
> >> > changes the question paper....
> >> >
> >> > Valsaraj Viswanathan
> >>
>


-- 
Life is like this: "Just when we get all the answers of life.... God
changes the question paper....

Valsaraj Viswanathan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20210702/b231d69c/attachment.htm>


More information about the pgpool-general mailing list