回复：Queries that should be canceled will get stuck on secure_write function

[蔡梦娟(玊于)]

Hi all, I want to know your opinion on this patch, or in what way do you think 
we should solve this problem?
------------------------------------------------------------------
发件人：蔡梦娟(玊于) <mengjuan....@alibaba-inc.com>
发送时间：2021年9月9日(星期四) 17:38
收件人：Robert Haas <robertmh...@gmail.com>; Andres Freund <and...@anarazel.de>; 
alvherre <alvhe...@alvh.no-ip.org>; masao.fujii <masao.fu...@oss.nttdata.com>
抄　送：pgsql-hackers <pgsql-hackers@lists.postgresql.org>
主　题：回复：Queries that should be canceled will get stuck on secure_write function


I changed the implementation about this problem: 
a) if the cancel query interrupt is from db for some reason, such as recovery 
conflict, then handle it immediately, and cancel request is treated as 
terminate request;
b) if the cancel query interrupt is from client, then ignore as original way

In the attached patch, I also add a tap test to generate a recovery conflict on 
a standby during the backend process is stuck on client write, check whether it 
can handle the cancel query request due to recovery conflict.

what do you think of it, hope to get your reply

Thanks & Best Regards

0001-Handle-cancel-interrupts-during-client-readwrite.patch
Description: Binary data