Re: BUG #15299: relation does not exist errors

Поиск
Список
Период
Сортировка
От Jeff Frost
Тема Re: BUG #15299: relation does not exist errors
Дата
Msg-id 38FCBCD9-0145-4CCD-8A9A-496E532F0AAE@pgexperts.com
обсуждение исходный текст
Ответ на Re: BUG #15299: relation does not exist errors  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #15299: relation does not exist errors  (Andres Freund <andres@anarazel.de>)
Список pgsql-bugs
On Jul 26, 2018, at 12:14 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Jeff Frost <jeff@pgexperts.com> writes:
>> On Jul 26, 2018, at 9:50 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> My first thought would be something to do with a restrictive search_path.
>
>> Good thought. As far as I can tell we never change it from the default and everything in that DB is in the public
schema.
>
> Right, but what I'm half-theorizing is that the patches for CVE-2018-1058
> affected you somehow.  Maybe something "transiently" installed pg_catalog
> (only) as search_path and forgot to remove it again.  It would be easy
> to explain it that way if the errors had been coming out of autovacuum
> worker processes, for instance, though your log didn't match that exactly.
>
> If you see it again it would be a good idea to look very closely at what
> happened right before the errors started.

Oh, I see what you're saying. Don't the autovacuum processes connect to their own backends which then exit after
they'recomplete though? 

I have the logs around, so if you know what I should look for, I'd be happy to dig.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Soni M
Дата:
Сообщение: Scanning all partition when more than 100 items in "where id in ()" clause
Следующее
От: Andres Freund
Дата:
Сообщение: Re: BUG #15299: relation does not exist errors