Re: \d t: ERROR: XX000: cache lookup failed for relation - Mailing list pgsql-hackers

From Justin Pryzby
Subject Re: \d t: ERROR: XX000: cache lookup failed for relation
Date
Msg-id 20180604164033.GC5164@telsasoft.com
Whole thread Raw
In response to Re: \d t: ERROR: XX000: cache lookup failed for relation  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: \d t: ERROR: XX000: cache lookup failed for relation
List pgsql-hackers
On Mon, Jun 04, 2018 at 07:12:53PM +0300, Teodor Sigaev wrote:
> 
> >Is that considered an actionable problem?
> 
> 
> I think so. but I'm not able to reproduce that, I wrote a script to simplify

The failure is triggered by running "\d t" in (yet) another session - sorry if
that was unclear.  It fails very consistently, probably over 75% of the time.

Also note that my "INSERT" was run in a separate loop, concurrent with the
VACUUM and ALTER, but yours is running consecutively.

Justin


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Remove mention in docs that foreign keys on partitioned tablesare not supported
Next
From: Fujii Masao
Date:
Subject: Recovery performance of DROP DATABASE with many tablespaces