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

From Peter Eisentraut
Subject Re: BF failure: could not open relation with OID XXXX while queryingpg_views
Date
Msg-id 4aaff4aa-6d9c-813d-b91a-c82a81611d73@2ndquadrant.com
Whole thread Raw
In response to Re: BF failure: could not open relation with OID XXXX while querying pg_views  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BF failure: could not open relation with OID XXXX while querying pg_views  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 2019-08-14 05:52, Tom Lane wrote:
> Thomas Munro <thomas.munro@gmail.com> writes:
>> Here are three strange recent failures in the "rules" test:
>> ...
>> 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?

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: John Naylor
Date:
Subject: Re: [proposal] de-TOAST'ing using a iterator
Next
From: Tom Lane
Date:
Subject: Re: BF failure: could not open relation with OID XXXX while querying pg_views