ERROR: found multixact from before relminmxid

Поиск
Список
Период
Сортировка
От Alexandre Arruda
Тема ERROR: found multixact from before relminmxid
Дата
Msg-id CAGewt-ujGpMLQ09gXcUFMZaZsGJC98VXHEFbF-tpPB0fB13K+A@mail.gmail.com
обсуждение исходный текст
Ответы Re: ERROR: found multixact from before relminmxid  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-general
Hi,

Some time ago, I had this errors frequently showed in logs after some
autovacuum in some tables(pg 9.6). VACUUM FULL or CLUSTER in this tables show the same and not complete the tasks (showed by some table bloat select).
Then, I did a full dump/restore into a new version (10.2) and everything is ok for a couple of months. Now, I have errors like this again:

db1=# cluster pc44t;

ERROR:  found multixact 134100944 from before relminmxid 192042633  

Like before, the only way to make the errors to desapear is by dump/reload the whole table.


Thanks for any help.


Best regards,


Alexandre


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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: decompose big queries
Следующее
От: Pavan Deolasee
Дата:
Сообщение: Re: ERROR: unexpected chunk number 0 (expected 1) for toast value76753264 in pg_toast_10920100