ERROR: MultiXactId xxx has not been created yet

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: ERROR: MultiXactId xxx has not been created yet
Date: 2016-05-24 15:47:20
Message-ID: 5702C5CF-66E8-4D93-9B30-C4DB001A6F4E@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
-- Christophe Pettus
xof(at)thebuild(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2016-05-24 16:00:17 Re: ERROR: MultiXactId xxx has not been created yet
Previous Message parihaaraka 2016-05-24 15:45:43 Re: pg_upgrade error regarding hstore operator