Re: BF failure: could not open relation with OID XXXX while querying pg_views - Mailing list pgsql-hackers

From Tom Lane
Subject Re: BF failure: could not open relation with OID XXXX while querying pg_views
Date
Msg-id 12000.1565759159@sss.pgh.pa.us
Whole thread Raw
In response to Re: BF failure: could not open relation with OID XXXX while queryingpg_views  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: BF failure: could not open relation with OID XXXX while querying pg_views  (Thomas Munro <thomas.munro@gmail.com>)
List pgsql-hackers
Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:
> On 2019-08-14 05:52, Tom Lane wrote:
>> Thomas Munro <thomas.munro@gmail.com> writes:
>>> They all raised "ERROR:  could not open relation with OID <varies>"
>>> while running:
>>> SELECT viewname, definition FROM pg_views
>>> WHERE schemaname IN ('pg_catalog', 'public')
>>> ORDER BY viewname;

>> I think the problem is probably that Peter ignored this bit of advice
>> in parallel_schedule:
>> # rules cannot run concurrently with any test that creates
>> # a view or rule in the public schema
>> when he inserted "collate.linux.utf8" concurrently with "rules".

> This test file is set up to create everything in the "collate_tests"
> schema.  Is that not working correctly?

Oh, hmm --- yeah, that should mean it's safe.  Maybe somebody incautiously
changed one of the other tests that run concurrently with "rules"?

            regards, tom lane



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: BF failure: could not open relation with OID XXXX while queryingpg_views
Next
From: Thomas Munro
Date:
Subject: Re: BF failure: could not open relation with OID XXXX while querying pg_views