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

From Sean McIntyre
Subject Re: ERROR: found multixact from before relminmxid
Date
Msg-id CAAWwSTru281qbWbuVijr9CGU5asuC08HhvKiyqZ-dXGDSV4xrQ@mail.gmail.com
Whole thread Raw
In response to ERROR: found multixact from before relminmxid  (Sean McIntyre <sean.mcintyre@warbyparker.com>)
Responses Re: ERROR: found multixact from before relminmxid
List pgsql-general
Quick correction :)

I am running PostgreSQL *9.6.8* on AWS RDS. I'm going to try to pg-repack the table and will look to upgrade to *9.6.9* (though it's not presently available on RDS).

Sean

On Fri, Jul 13, 2018 at 11:14 AM Sean McIntyre <sean.mcintyre@warbyparker.com> wrote:
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


--

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

pgsql-general by date:

Previous
From: Edgard Battisti Guimarães
Date:
Subject: Re: ODBC - Getting CONN ERROR: errmsg='The buffer was too small forthe InfoValue'
Next
From: Alvaro Herrera
Date:
Subject: Re: ERROR: found multixact from before relminmxid