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

Krzysztof Mościcki stivi at kity.pl
Fri Jun 17 19:36:52 JST 2016


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


More information about the pgpool-general mailing list