Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pf4D9-0000RE-Qi for pgsql-committers@arkaria.postgresql.org; Wed, 22 Mar 2023 19:33:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pf4D8-0002Zi-Fl for pgsql-committers@arkaria.postgresql.org; Wed, 22 Mar 2023 19:33:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pf4D8-0002ZZ-8V for pgsql-committers@lists.postgresql.org; Wed, 22 Mar 2023 19:33:26 +0000 Received: from relay4-d.mail.gandi.net ([2001:4b98:dc4:8::224]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pf4D4-0006BQ-Px for pgsql-committers@lists.postgresql.org; Wed, 22 Mar 2023 19:33:25 +0000 Received: (Authenticated sender: adsend@dunslane.net) by mail.gandi.net (Postfix) with ESMTPSA id 5E55EE0004; Wed, 22 Mar 2023 19:33:16 +0000 (UTC) Content-Type: multipart/alternative; boundary="------------8dzCqZeR8g2ro550cgnNWkiU" Message-ID: Date: Wed, 22 Mar 2023 15:33:15 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.5.0 Subject: Re: pgsql: Teach verify_heapam() to validate update chains within a page. Content-Language: en-US To: Robert Haas , pgsql-committers@lists.postgresql.org References: From: Andrew Dunstan In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------8dzCqZeR8g2ro550cgnNWkiU Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 2023-03-22 We 09:17, Robert Haas wrote: > Teach verify_heapam() to validate update chains within a page. > > Prior to this commit, we only consider each tuple or line pointer > on the page in isolation, but now we can do some validation of a line > pointer against its successor. For example, a redirect line pointer > shouldn't point to another redirect line pointer, and if a tuple > is HOT-updated, the result should be a heap-only tuple. > > Himanshu Upadhyaya and Robert Haas, reviewed by Aleksander Alekseev, > Andres Freund, and Peter Geoghegan. This has apparently broken one case in the buildfarm, which now fails an upgrade from REL9_2_STABLE because we run amcheck after the upgrade: heap table "regression.public.xacttest", block 0, offset 1:     non-heap-only update produced a heap-only tuple at offset 18 heap table "regression.public.xacttest", block 0, offset 2:     non-heap-only update produced a heap-only tuple at offset 19 heap table "regression.public.xacttest", block 0, offset 4:     non-heap-only update produced a heap-only tuple at offset 20 heap table "regression.public.xacttest", block 0, offset 5:     non-heap-only update produced a heap-only tuple at offset 21 heap table "regression.public.wslot", block 0, offset 89:     non-heap-only update produced a heap-only tuple at offset 95 heap table "regression.public.pslot", block 0, offset 95:     non-heap-only update produced a heap-only tuple at offset 100 heap table "regression.public.pslot", block 0, offset 96:     non-heap-only update produced a heap-only tuple at offset 101 I don't know if this is a bug in this commit or if the REL9_2_STABLE repo is really broken. cheers andrew -- Andrew Dunstan EDB:https://www.enterprisedb.com --------------8dzCqZeR8g2ro550cgnNWkiU Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit


On 2023-03-22 We 09:17, Robert Haas wrote:
Teach verify_heapam() to validate update chains within a page.

Prior to this commit, we only consider each tuple or line pointer
on the page in isolation, but now we can do some validation of a line
pointer against its successor. For example, a redirect line pointer
shouldn't point to another redirect line pointer, and if a tuple
is HOT-updated, the result should be a heap-only tuple.

Himanshu Upadhyaya and Robert Haas, reviewed by Aleksander Alekseev,
Andres Freund, and Peter Geoghegan.


This has apparently broken one case in the buildfarm, which now fails an upgrade from REL9_2_STABLE because we run amcheck after the upgrade:


heap table "regression.public.xacttest", block 0, offset 1:
    non-heap-only update produced a heap-only tuple at offset 18
heap table "regression.public.xacttest", block 0, offset 2:
    non-heap-only update produced a heap-only tuple at offset 19
heap table "regression.public.xacttest", block 0, offset 4:
    non-heap-only update produced a heap-only tuple at offset 20
heap table "regression.public.xacttest", block 0, offset 5:
    non-heap-only update produced a heap-only tuple at offset 21
heap table "regression.public.wslot", block 0, offset 89:
    non-heap-only update produced a heap-only tuple at offset 95
heap table "regression.public.pslot", block 0, offset 95:
    non-heap-only update produced a heap-only tuple at offset 100
heap table "regression.public.pslot", block 0, offset 96:
    non-heap-only update produced a heap-only tuple at offset 101


I don't know if this is a bug in this commit or if the REL9_2_STABLE repo is really broken.


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com
--------------8dzCqZeR8g2ro550cgnNWkiU--