Re: Add Information during standby recovery conflicts - Mailing list pgsql-hackers

From Drouvot, Bertrand
Subject Re: Add Information during standby recovery conflicts
Date
Msg-id e2819497-ff8b-831c-e6aa-6f1e81b1e709@amazon.com
Whole thread Raw
In response to Re: Add Information during standby recovery conflicts  (Masahiko Sawada <sawada.mshk@gmail.com>)
Responses Re: Add Information during standby recovery conflicts  (Masahiko Sawada <sawada.mshk@gmail.com>)
List pgsql-hackers
Hi,

On 11/6/20 3:21 AM, Masahiko Sawada wrote:
> CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you
canconfirm the sender and know the content is safe.
 
>
>
>
> On Fri, Oct 30, 2020 at 6:02 PM Drouvot, Bertrand <bdrouvot@amazon.com> wrote:
>> Hi,
>>
>> On 10/30/20 4:25 AM, Fujii Masao wrote:
>>> CAUTION: This email originated from outside of the organization. Do
>>> not click links or open attachments unless you can confirm the sender
>>> and know the content is safe.
>>>
>>>
>>>
>>> On 2020/10/30 10:29, Masahiko Sawada wrote:
>>>> ,
>>>>
>>>> On Thu, 29 Oct 2020 at 00:16, Fujii Masao
>>>> <masao.fujii@oss.nttdata.com> wrote:
>>>>> I read v8 patch. Here are review comments.
>>>> Thank you for your review.
>>>>
> Thank you for updating the patch!
>
> Looking at the latest version patch
> (v8-0002-Log-the-standby-recovery-conflict-waits.patch), I think it
> doesn't address some comments from Fujii-san.
>
>>>>> When recovery conflict with buffer pin happens, log message is output
>>>>> every deadlock_timeout. Is this intentional behavior? If yes, IMO
>>>>> that's
>>>>> not good because lots of messages can be output.
>>>> Agreed.
> I think the latest patch doesn't fix the above comment. Log message
> for recovery conflict on buffer pin is logged every deadlock_timeout.
>
>>>> if we were to log the recovery conflict only once in bufferpin
>>>> conflict case, we would log it multiple times only in lock conflict
>>>> case. So I guess it's better to do that in all conflict cases.
>>> Yes, I agree that this behavior basically should be consistent between
>>> all cases.
> The latest patch seems not to address this comment as well.

Oh, I missed those ones, thanks for the feedback.

New version attached, so that recovery conflict will be logged only once 
also for buffer pin and lock cases.

Bertrand



Attachment

pgsql-hackers by date:

Previous
From: "Drouvot, Bertrand"
Date:
Subject: Re: [BUG]: segfault during update
Next
From: Dilip Kumar
Date:
Subject: Re: logical streaming of xacts via test_decoding is broken