Postgres Pro
Downloads
Home   >   mailing lists

Re: [External] Re: [PATCH] BUG FIX: inconsistent page found in BRIN_REGULAR_PAGE - Mailing list pgsql-bugs

From 王海洋
Subject Re: [External] Re: [PATCH] BUG FIX: inconsistent page found in BRIN_REGULAR_PAGE
Date
Msg-id CACciXACqJBkVAhj5pobKfgqGnYmqRu13YntFuuO8hZNLxYV=Yw@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] BUG FIX: inconsistent page found in BRIN_REGULAR_PAGE  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Responses Re: [External] Re: [PATCH] BUG FIX: inconsistent page found in BRIN_REGULAR_PAGE
List pgsql-bugs
Tree view
Thanks, I agree. So my new modified patch is attached.

From: "Kyotaro Horiguchi"<horikyota.ntt@gmail.com>
Date: Thu, Aug 4, 2022, 16:12
Subject: [External] Re: [PATCH] BUG FIX: inconsistent page found in BRIN_REGULAR_PAGE
Cc: <pgsql-bugs@lists.postgresql.org>
I'd like to explain a bit further. At Thu, 04 Aug 2022 16:55:35 +0900 (JST), Kyotaro Horiguchi <horikyota.ntt@gmail.com> wrote in > > BRIN_EVACUATE_PAGE is an unlogged bit, which is never set during > > recovery. See brin_start_evacuating_page() for details. That being said, I think that some bug could unexpectedly set the flag during recovery. I sought for clean way to check that only while not in evacuation, but I found none.. regards. -- Kyotaro Horiguchi NTT Open Source Software Center
Attachment

pgsql-bugs by date:

Previous
From: "houzj.fnst@fujitsu.com"
Date:
Subject: RE: No-op updates with partitioning and logical replication started failing in version 13
Next
From: Francisco Olarte
Date:
Subject: Re: ERROR: unterminated dollar-quoted string at or near "$$"