Re: MultiXactId error after upgrade to 9.3.4

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: MultiXactId error after upgrade to 9.3.4
Дата
Msg-id 20160617225517.GA157662@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: MultiXactId error after upgrade to 9.3.4  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
Alvaro Herrera wrote:
> Andrew Gierth wrote:

> > Why is the correct rule not "check for and ignore pre-upgrade mxids
> > before even trying to fetch members"?
>
> I propose something like the attached patch, which implements that idea.

Here's a backpatch of that to 9.3 and 9.4.

I tested this by creating a 9.2 installation with an out-of-range
multixact, and verified that after upgrading this to 9.3 it fails with
the "apparent wraparound" message in VACUUM.  With this patch applied,
it silently removes the multixact.

I will clean this up and push to all branches after the tagging of
9.6beta2 on Monday.

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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Aleksey Demakov
Дата:
Сообщение: Re: Experimental dynamic memory allocation of postgresql shared memory
Следующее
От: Tom Lane
Дата:
Сообщение: Whether to back-patch fix for aggregate transtype width estimates