Thread: ERROR: found multixact from before relminmxid
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
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
On 2018-Jul-13, Sean McIntyre wrote: > 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). Yay RDS ... -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services