[pgpool-general: 3417] Re: FATAL: unable to read data from frontend + Pgpool 3.4.0

[Tatsuo Ishii]

These are harmless and are down graded to DEBUG message in the 3.4
stable tree head.

http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=62acd6daebc4a35254f9f1896ac07fa5a33d8c02

We are going to release 3.4.1 in this or next month. If you are hurry,
please grab 3.4 stable source or use the latest RPM in our yum
repository.

http://www.pgpool.net/yum/rpms/3.4/redhat/rhel-6-x86_64/

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

> Hi Team,
> 
> After setting the load-balancing with pgpool 3.4.0 with PostgreSQL 9.3.5 on
> RHEL 6.5 machine. I see lot of messages " FATAL:  unable to read data from
> frontend". However, there's nothing problem with load-balancing its working
> fine without any issues. But lot of these messages.
> 
> Logs:
> 
> 2015-01-11 14:35:00: pid 7308: DETAIL:  EOF encountered with frontend
> 2015-01-11 14:35:05: pid 15274: FATAL:  unable to read data from frontend
> 2015-01-11 14:35:05: pid 15274: DETAIL:  EOF encountered with frontend
> 2015-01-11 14:35:10: pid 20906: FATAL:  unable to read data from frontend
> 2015-01-11 14:35:10: pid 20906: DETAIL:  EOF encountered with frontend
> 2015-01-11 14:35:12: pid 14364: LOG:  DB node id: 1 backend pid: 18325
> statement: select 1;
> 2015-01-11 14:35:12: pid 14364: LOG:  Frontend terminated
> 2015-01-11 14:35:12: pid 14364: DETAIL:  received message kind 'X' from
> frontend
> 2015-01-11 14:35:12: pid 14364: LOG:  DB node id: 0 backend pid: 25540
> statement:  DISCARD ALL
> 2015-01-11 14:35:12: pid 14364: LOG:  DB node id: 1 backend pid: 18325
> statement:  DISCARD ALL
> 2015-01-11 14:35:15: pid 14364: FATAL:  unable to read data from frontend
> 2015-01-11 14:35:15: pid 14364: DETAIL:  EOF encountered with frontend
> 2015-01-11 14:35:20: pid 21002: FATAL:  unable to read data from frontend
> 2015-01-11 14:35:20: pid 21002: DETAIL:  EOF encountered with frontend
> 
> 
> Any help ? Please let me know if any other details required to fix it.
> 
> Thank you in advance
> 
> -- 
> 
> Regards
> Raghav
> Blog: htt://raghavt.blogspot.com/