Re: [COMMITTERS] pgsql: Fix freezing of a dead HOT-updated tuple - Mailing list pgsql-committers

From Peter Geoghegan
Subject Re: [COMMITTERS] pgsql: Fix freezing of a dead HOT-updated tuple
Date
Msg-id CAH2-Wznm4rCrhFAiwKPWTpEw2bXDtgROZK7jWWGucXeH3D1fmA@mail.gmail.com
Whole thread Raw
In response to [COMMITTERS] pgsql: Fix freezing of a dead HOT-updated tuple  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-committers
On Thu, Sep 28, 2017 at 7:47 AM, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
> Fix freezing of a dead HOT-updated tuple

If I run Dan Wood's test case again, the obvious symptom (spurious
duplicates) goes away. However, the enhanced amcheck, and thus CREATE
INDEX/REINDEX, still isn't happy about this:

postgres=# select bt_index_check('t_pkey', true);
DEBUG:  00000: verifying presence of required tuples in index "t_pkey"
LOCATION:  bt_check_every_level, verify_nbtree.c:424
ERROR:  XX000: failed to find parent tuple for heap-only tuple at
(0,6) in table "t"
LOCATION:  IndexBuildHeapRangeScan, index.c:2597
Time: 3.699 ms

-- 
Peter Geoghegan


-- 
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

pgsql-committers by date:

Previous
From: Alvaro Herrera
Date:
Subject: [COMMITTERS] pgsql: Fix freezing of a dead HOT-updated tuple
Next
From: Peter Eisentraut
Date:
Subject: [COMMITTERS] pgsql: Remove SGML marked sections