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

From Sean McIntyre
Subject ERROR: found multixact from before relminmxid
Date
Msg-id CAAWwSToHisB17OV2ZDLH-TO578b59H4z1vum-+mb0n4oRi7QLw@mail.gmail.com
Whole thread Raw
Responses Re: ERROR: found multixact from before relminmxid  (Sean McIntyre <sean.mcintyre@warbyparker.com>)
List pgsql-general
Dear all,

I just wanted to report that I found similar error "found multixact from before relminmxid" that Alexandre Arruda and Jeremy Finzel recently reported and discussed with Andres Freund. (Thanks all for good notes.)

I get this error when vacuuming a specific table in my high-transaction OLTP workload database. I am running PostgreSQL 9.5.8 on AWS RDS. I'm going to try to pg-repack the table and will look to upgrade to 9.5.9 (though it's not presently available).

Best,

Sean

--

Sean McIntyre
Summer reading calls for summery frames
We made an app! Download it here
Follow us:  FacebookTwitterInstagramSnapchat

pgsql-general by date:

Previous
From: amul sul
Date:
Subject: Re: PG11 Hash partitioning and null values in the partition key
Next
From: Edgard Battisti Guimarães
Date:
Subject: Re: ODBC - Getting CONN ERROR: errmsg='The buffer was too small forthe InfoValue'