[pgpool-committers: 8024] pgpool: Fix occasional hang in COPY FROM.

Tatsuo Ishii ishii at sraoss.co.jp
Thu Sep 16 17:01:15 JST 2021


Fix occasional hang in COPY FROM.

If an error occurs while doing COPY FROM, it was possible the
Pgpool-II waited forever for a response from backend after COPY end
marker was sent from frontend. Pgpool expected a new message arrives
to socket, but it is possible that the message (in this case an error
message) is already in the backend read buffer. The fix is, check the
buffer is empty or not before reading from the socket.  New test case
(07.copy_hang) is also added.

The bug was found by Bo Peng.

Branch
------
V4_0_STABLE

Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=8ade8307ff919577ade6037ed6b5b5b90a87a063

Modified Files
--------------
src/protocol/pool_proto_modules.c               | 15 ++++++-
src/test/regression/tests/076.copy_hang/test.sh | 54 +++++++++++++++++++++++++
2 files changed, 67 insertions(+), 2 deletions(-)



More information about the pgpool-committers mailing list