Postgres Pro
Downloads
Home   >   mailing lists

ERROR: found multixact from before relminmxid - Mailing list pgsql-general

From Alexandre Arruda
Subject ERROR: found multixact from before relminmxid
Date
Msg-id CAGewt-ujGpMLQ09gXcUFMZaZsGJC98VXHEFbF-tpPB0fB13K+A@mail.gmail.com
Whole thread Raw
Responses Re: ERROR: found multixact from before relminmxid
List pgsql-general
Tree view
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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: decompose big queries
Next
From: Pavan Deolasee
Date:
Subject: Re: ERROR: unexpected chunk number 0 (expected 1) for toast value76753264 in pg_toast_10920100