[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