ERROR: found multixact from before relminmxid

From: Alexandre Arruda <adaldeia(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: ERROR: found multixact from before relminmxid
Date: 2018-04-06 00:09:23
Message-ID: CAGewt-ujGpMLQ09gXcUFMZaZsGJC98VXHEFbF-tpPB0fB13K+A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavan Deolasee 2018-04-06 03:25:37 Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100
Previous Message David G. Johnston 2018-04-05 22:51:10 Re: decompose big queries