Re: ERROR: MultiXactId xxx has not been created yet

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Christophe Pettus <xof(at)thebuild(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR: MultiXactId xxx has not been created yet
Date: 2016-05-24 16:00:17
Message-ID: 20160524160017.GA427890@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 canonical way 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Manuel Gómez 2016-05-24 16:12:59 Re: FIRST_VALUE: need to group by argument?
Previous Message Christophe Pettus 2016-05-24 15:47:20 ERROR: MultiXactId xxx has not been created yet