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

Tatsuo Ishii ishii at sraoss.co.jp
Thu Sep 16 17:01:26 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_2_STABLE

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

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



More information about the pgpool-committers mailing list