Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: MultiXactId xxx has not been created yet - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: ERROR: MultiXactId xxx has not been created yet
Date
Msg-id 20160524160017.GA427890@alvherre.pgsql
Whole thread Raw
In response to ERROR: MultiXactId xxx has not been created yet  (Christophe Pettus <xof@thebuild.com>)
List pgsql-general
Tree view 
Christophe Pettus wrote:
> We have a database (PostgreSQL 9.3.10) which is reporting this error on a TOAST table on a VACUUM.  Is there a
canonicalway of repairing this?  The table is *huge*, so a VACUUM FULL or pg_dump / pg_restore is probably not going to
work.

I don't think toast tables can have multixacts at all, so my guess is
that the tuple header is corrupted.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: ERROR: MultiXactId xxx has not been created yet
Next
From: Manuel Gómez
Date:
Subject: Re: FIRST_VALUE: need to group by argument?