Re: ERROR: MultiXactId xxx has not been created yet

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: ERROR: MultiXactId xxx has not been created yet
Дата
Msg-id 20160524160017.GA427890@alvherre.pgsql
обсуждение исходный текст
Ответ на ERROR: MultiXactId xxx has not been created yet  (Christophe Pettus <xof@thebuild.com>)
Список 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
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 по дате отправления:

Предыдущее
От: Christophe Pettus
Дата:
Сообщение: ERROR: MultiXactId xxx has not been created yet
Следующее
От: Manuel Gómez
Дата:
Сообщение: Re: FIRST_VALUE: need to group by argument?