Re: ERROR: could not find tuple for statistics object - is there a way to clean this up?

Поиск
Список
Период
Сортировка
От Morris de Oryx
Тема Re: ERROR: could not find tuple for statistics object - is there a way to clean this up?
Дата
Msg-id CAKqnccgXPpc7vQEfH2u97dX8jUBurpBi6eDReaaYghN7jidmEQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ERROR: could not find tuple for statistics object - is there a way to clean this up?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: ERROR: could not find tuple for statistics object - is there a way to clean this up?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
After posting, I realized that this is likely a Stupid User Error. I was mucking around, and did something along the lines of 

delete from pg_statistic_ext;

or
delete from pg_stats_ext;

...instead of DROP STATISTICS calls. Would this likely explain what I'm seeing? If so, bug is in front of keyboard...my understanding is that you shouldn't mess with the catalog data directly.

On Sun, Nov 15, 2020 at 6:08 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Morris de Oryx <morrisdeoryx@gmail.com> writes:
> And here's the error that I get back:
> ERROR:  could not find tuple for statistics object 147574.

Can you give a self-contained recipe for triggering this?

                        regards, tom lane

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Restoring database from false update
Следующее
От: Dilip Kumar
Дата:
Сообщение: Re: Race condition with restore_command on streaming replica