[pgpool-committers: 2087] pgpool: Fix reset query stuck problem.

Tatsuo Ishii ishii at postgresql.org
Fri Jul 18 17:05:17 JST 2014

Fix reset query stuck problem.

It is reported that reset query (DISCARD ALL etc.) occasionally does
not finish and pgpool child remain waiting for reply from backend thus
client cannot connect to pgpool (for example
http://www.pgpool.net/mantisbt/view.php?id=107).  The cause of problem
is not identified yet but if client suddenly closes connection to
pgpool in the middle of query processing, backend may not accept the
reset queries because they are not ready for query.

The fix is, if frontend closes connection in unexpected way, query
process loop immediately returns with new state:
POOL_END_WITH_FRONTEND_ERROR and pgpool closes connection to
PostgreSQL then goes back to new connection request waiting loop.



Modified Files
child.c              |    5 ++++-
pool.h               |    3 ++-
pool_proto_modules.c |    2 +-
3 files changed, 7 insertions(+), 3 deletions(-)

More information about the pgpool-committers mailing list