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 8670.1565754774@sss.pgh.pa.us
Whole thread Raw
In response to BF failure: could not open relation with OID XXXX while querying pg_views  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: BF failure: could not open relation with OID XXXX while queryingpg_views  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
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".

(I suspect BTW that the point is not so much that you better not
*create* such an object, as that you better not *drop* it concurrently
with that query.)

            regards, tom lane



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: using explicit_bzero
Next
From: Michael Paquier
Date:
Subject: Re: Regression test failure in regression test temp.sql