Re: BF failure: could not open relation with OID XXXX while querying pg_views

On Sun, Sep 15, 2019 at 10:16:30AM +0100, Dean Rasheed wrote:
>On Sat, 14 Sep 2019 at 05:25, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>
>> Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> writes:
>> > On Wed, Aug 14, 2019 at 05:24:26PM +1200, Thomas Munro wrote:
>> >> On Wed, Aug 14, 2019 at 5:06 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> >>> Oh, hmm --- yeah, that should mean it's safe. Maybe somebody incautiously
>> >>> changed one of the other tests that run concurrently with "rules"?
>>
>> >> Looks like stats_ext.sql could be the problem. It creates and drops
>> >> priv_test_view, not in a schema. Adding Dean, author of commit
>> >> d7f8d26d.
>>
>> > Yeah, that seems like it might be the cause. I'll take a look at fixing
>> > this, probably by creating the view in a different schema.
>>
>> Ping? We're still getting intermittent failures of this ilk, eg
>>
>> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=dragonet&dt=2019-09-14%2003%3A37%3A03
>>
>> With v12 release approaching, I'd like to not have failures
>> like this in a released branch.
>>
>
>Ah sorry, I missed this thread before. As author of that commit, it's
>really on me to fix it, and the cause seems pretty clear-cut, so I'll
>aim to get that done today.
>

FWIW here is a draft patch that I was going to propose - it simply moves
the table+view into a "tststats" schema. I suppose that's rougly what we
discussed earlier in this thread.

regards

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