Re: XX000: enum value 117721 not found in cache for enum enumcrash

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Andres Freund <andres(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: XX000: enum value 117721 not found in cache for enum enumcrash
Date: 2012-07-01 19:59:08
Message-ID: 27898.1341172748@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Sat, Jun 30, 2012 at 5:51 AM, Andres Freund <andres(at)2ndquadrant(dot)com> wrote:
>> This is not surprising. psql 2's backend finds rows in the index with enum
>> values that are not visible in its mvcc snapshot.

> I think the problem is that load_enum_cache_data() uses
> GetTransactionSnapshot() rather than GetLatestSnapshot().

That would only make the race condition window smaller (ie, hard
to reproduce manually like this, but not gone).

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2012-07-01 20:18:48 Re: XX000: enum value 117721 not found in cache for enum enumcrash
Previous Message Alex Hunsaker 2012-07-01 19:20:58 Re: Support for array_remove and array_replace functions