From: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
---|---|
To: | Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: BF failure: could not open relation with OID XXXX while querying pg_views |
Date: | 2019-09-15 10:11:06 |
Message-ID: | 20190915101106.kisedb3vrhgy3qch@development |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
Attachment | Content-Type | Size |
---|---|---|
stats_ext_view.patch | text/plain | 7.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2019-09-15 10:21:05 | Re: [PATCH] Improve performance of NOTIFY over many databases (v2) |
Previous Message | Dean Rasheed | 2019-09-15 09:16:30 | Re: BF failure: could not open relation with OID XXXX while querying pg_views |