[pgpool-general: 4727] Re: Pgpool logging error, when haproxy checking status

[Tatsuo Ishii]

My guess is, Haproxy is broken to handle the PostgreSQL's protocol
(called "frontend/backend protocol"). Haproxy should send a
terminating message before disconnecting to pgpool-II, but it does
not.

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

> Hi.
> 
> I have configuration with two nodes of postgresql, two nodes of pgpool
> but without virtual IP, instead of I use haproxy, with configuration:
> listen postgres-HA :5432
>         mode            tcp
>         balance         roundrobin
>         option          pgsql-check user repmgr
>         server <pgpool host1> <pgpool ip1>:5433 check inter 10000
>         server <pgpool host2> <pgpool ip2>:5433 check inter 10000 backu
> 
> Haproxy checking status of pgpools by query "DISCARD ALL", but always in
> log of pgpool is like this:
> 
> Jun 17 09:51:52 ip-10-0-1-129 pgpool[3687]: [7-1] 2016-06-17 09:51:52:
> pid 3687: LOG:  new connection received
> Jun 17 09:51:52 ip-10-0-1-129 pgpool[3687]: [7-2] 2016-06-17 09:51:52:
> pid 3687: DETAIL:  connecting host=10.0.1.247 port=56692
> Jun 17 09:51:52 ip-10-0-1-129 pgpool: 2016-06-17 09:51:52: pid 3687:
> LOG:  new connection received
> Jun 17 09:51:52 ip-10-0-1-129 pgpool: 2016-06-17 09:51:52: pid 3687:
> DETAIL:  connecting host=10.0.1.247 port=56692
> Jun 17 09:51:52 ip-10-0-1-129 pgpool[3687]: [8-1] 2016-06-17 09:51:52:
> pid 3687: ERROR:  unable to read data from frontend
> Jun 17 09:51:52 ip-10-0-1-129 pgpool[3687]: [8-2] 2016-06-17 09:51:52:
> pid 3687: DETAIL:  socket read failed with an error "Connection reset by
> peer"
> Jun 17 09:51:52 ip-10-0-1-129 pgpool[3687]: [9-1] 2016-06-17 09:51:52:
> pid 3687: LOG:  statement:  DISCARD ALL
> Jun 17 09:51:52 ip-10-0-1-129 pgpool: 2016-06-17 09:51:52: pid 3687:
> ERROR:  unable to read data from frontend
> Jun 17 09:51:52 ip-10-0-1-129 pgpool: 2016-06-17 09:51:52: pid 3687:
> DETAIL:  socket read failed with an error "Connection reset by peer"
> Jun 17 09:51:52 ip-10-0-1-129 pgpool: 2016-06-17 09:51:52: pid 3687:
> LOG:  statement:  DISCARD ALL
> 
> Haproxy see that status status is OK, so I don't know, why pgpool to
> report an error.
> There is any solution to fix this problem? There is not so easy to check
> proper working of pgpool if I have a lot of unnecessary logs.
> 
> Versions (Ubuntu 14.04)
> Pgpool2: 3.4.3-1.pgdg14.04+1
> Postgresql: 9.4.8-1.pgdg14.04+1
> Haproxy: 1.5.14-1ubuntu0.15.10.1~ubuntu14.04.1
> 
> Regards
> Kris
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general