Re: BUG #11264: Auto vacuum wraparound job blocking everything

Поиск
Список
Период
Сортировка
От Dinesh Bhandary
Тема Re: BUG #11264: Auto vacuum wraparound job blocking everything
Дата
Msg-id 9ac49eee319c43f6a344a2d5d2c38093@CO2PR05MB569.namprd05.prod.outlook.com
обсуждение исходный текст
Ответ на Re: BUG #11264: Auto vacuum wraparound job blocking everything  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-bugs
and that should fix it.  The oldestMulti value in pg_control would get upda=
ted by itself some time later.  If you experience stalls before oldestMulti=
 fixes itself, you could stop the server (cleanly!) and then pg_resetxlog -=
m x,y where x is the correct nextMulti value from pg_controldata and y is 2=
0783.

Are you referreing to NextMultiXactId of current pg_controldata ( from post=
gres 9.3.5) for x?
There is also NextMultiOffset, not sure If you meant to reset this. Please =
confirm.

Thanks,
Dinesh

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #11264: Auto vacuum wraparound job blocking everything
Следующее
От: Dinesh Bhandary
Дата:
Сообщение: Re: BUG #11264: Auto vacuum wraparound job blocking everything