Postgres Pro
Downloads
Home   >   mailing lists

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

From Teodor Sigaev
Subject Re: \d t: ERROR: XX000: cache lookup failed for relation
Date
Msg-id 82fb4e75-0e5b-d346-0313-a2c4869bdca8@sigaev.ru
Whole thread Raw
In response to Re: \d t: ERROR: XX000: cache lookup failed for relation  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: \d t: ERROR: XX000: cache lookup failed for relation
List pgsql-hackers
Tree view 
> 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.
No-no, I understood that. I tried \d in one more session.

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

both loops run in backgound. I tried to run two scripts -  and got a lot of 
deadlocks but not a probem reproduction.




-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

pgsql-hackers by date:

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