ERROR: found multixact from before relminmxid

From: Sean McIntyre <sean(dot)mcintyre(at)warbyparker(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: ERROR: found multixact from before relminmxid
Date: 2018-07-13 15:14:36
Message-ID: CAAWwSToHisB17OV2ZDLH-TO578b59H4z1vum-+mb0n4oRi7QLw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
WARBY PARKER
<https://www.warbyparker.com/?utm_source=employee&utm_medium=email&utm_content=signature&utm_campaign=signature&cvosrc=email.employee.signature>

Summer reading calls for summery frames
<https://www.warbyparker.com/summer-2018?utm_source=signature&utm_medium=email&utm_campaign=Summer-2018&cvosrc=email.signature.summer-2018>
We made an app! Download it here
<https://itunes.apple.com/app/apple-store/id1107693363?pt=1427163&ct=Employee%20Email%20Signature&mt=8>
Follow us: Facebook
<http://www.google.com/url?q=http%3A%2F%2Fwww.facebook.com%2Fwarbyparker&sa=D&sntz=1&usg=AFrqEzfUEaV6C9BaTQ8cI-VKdanu2UUQbw>
, Twitter
<http://www.google.com/url?q=http%3A%2F%2Ftwitter.com%2Fwarbyparker&sa=D&sntz=1&usg=AFrqEzczMD6HXAtHLBzviQV_EtD3ckoJVQ>
, Instagram <http://instagram.com/warbyparker>, Snapchat
<https://www.snapchat.com/add/warbyparker>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edgard Battisti Guimarães 2018-07-13 15:32:50 Re: ODBC - Getting CONN ERROR: errmsg='The buffer was too small for the InfoValue'
Previous Message amul sul 2018-07-13 14:56:48 Re: PG11 Hash partitioning and null values in the partition key