Re: ERROR: found multixact from before relminmxid

Поиск
Список
Период
Сортировка
От Alexandre Arruda
Тема Re: ERROR: found multixact from before relminmxid
Дата
Msg-id CAGewt-v-5x-MLDObako+QkkZs83uR9DzXHvz5H2=6=XGYcw+ZA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ERROR: found multixact from before relminmxid  (Andres Freund <andres@anarazel.de>)
Ответы Re: ERROR: found multixact from before relminmxid
Список pgsql-general
Em seg, 28 de mai de 2018 às 16:44, Andres Freund <andres@anarazel.de> escreveu:
>
> Hi,
>
> I think I found the bug, and am about to post a fix for it belo
> https://postgr.es/m/20180525203736.crkbg36muzxrjj5e@alap3.anarazel.de.
>
> Greetings,
>
> Andres Freund

Hi Andres,

In end of April we did a complete dump/reload in database to version 10.3.
Today, the problem returns:

production=# vacuum verbose co27t;
INFO:  vacuuming "public.co27t"
ERROR:  found multixact 81704071 from before relminmxid 107665371
production=# vacuum full verbose co27t;
INFO:  vacuuming "public.co27t"
ERROR:  found multixact 105476076 from before relminmxid 107665371
production=# cluster co27t;
ERROR:  found multixact 105476076 from before relminmxid 107665371

But this time, regular vacuum versus full/cluster are different in
multixact number.
Your patch is applicable to this issue and is in 10.4 ?

Best regards,

Alexandre


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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: pg_stats avg_width and null_frac
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Code of Conduct plan