Re: 回复:Queries that should be canceled will get stuck on secure_write function - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: 回复:Queries that should be canceled will get stuck on secure_write function
Date
Msg-id 0a291fee-dd99-abbc-434d-e37eace696cd@oss.nttdata.com
Whole thread Raw
In response to 回复:Queries that should be canceled will get stuck on secure_write function  ("蔡梦娟(玊于)" <mengjuan.cmj@alibaba-inc.com>)
Responses 回复:回复:Queries that should be canceled will get stuck on secure_write function  ("蔡梦娟(玊于)" <mengjuan.cmj@alibaba-inc.com>)
List pgsql-hackers

On 2021/09/22 1:14, 蔡梦娟(玊于) wrote:
> Hi all, I want to know your opinion on this patch, or in what way do you think we should solve this problem?

I agree that something like the patch (i.e., introduction of promotion
from cancel request to terminate one) is necessary for the fix. One concern
on the patch is that the cancel request can be promoted to the terminate one
even when secure_write() doesn't actually get stuck. Is this acceptable?
Maybe I'm tempted to set up the duration until the promotion happens....
Or we should introduce the dedicated timer for communication on the socket?

Regards,

-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: row filtering for logical replication
Next
From: Michael Paquier
Date:
Subject: Re: Estimating HugePages Requirements?