Sv: Re: ERROR: failed to add item to the index page

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: Peter Geoghegan <pg(at)bowt(dot)ie>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Sv: Re: ERROR: failed to add item to the index page
Date: 2019-04-30 18:54:45
Message-ID: VisenaEmail.41.51d7719d814a1f54.16a6f98a5e9@tc7-visena
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

På tirsdag 30. april 2019 kl. 19:58:31, skrev Peter Geoghegan <pg(at)bowt(dot)ie
<mailto:pg(at)bowt(dot)ie>>: On Tue, Apr 30, 2019 at 9:59 AM Peter Geoghegan
<pg(at)bowt(dot)ie> wrote:
> I'll start investigating the problem right away.

I have found what the problem is. I simply neglected to make a
conservative assumption about suffix truncation needing to add a heap
TID to a leaf page's new high key in nbtsort.c (following commit
dd299df8189), even though I didn't make the same mistake in
nbtsplitloc.c. Not sure how I managed to make such a basic error.

Andreas' test case works fine with the attached patch. I won't push a
fix for this today.

--
Peter Geoghegan Nice, thanks! --
Andreas Joseph Krogh

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2019-04-30 18:55:28 Re: Re: ERROR: failed to add item to the index page
Previous Message Ashwin Agrawal 2019-04-30 18:53:38 Match table_complete_speculative() code to comment