Re: postgresql 9.6 - cannot freeze committed xmax

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: postgresql 9.6 - cannot freeze committed xmax
Дата
Msg-id 20180228211621.vikbp5s3rwg47455@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: postgresql 9.6 - cannot freeze committed xmax  (Alexandre Garcia <alexandre@vmfarms.com>)
Ответы Re: postgresql 9.6 - cannot freeze committed xmax  (Alexandre Garcia <alexandre@vmfarms.com>)
Список pgsql-admin
Hi,

On 2018-02-28 21:12:58 +0000, Alexandre Garcia wrote:
> Thanks for your answers, took me a little while to restore a backup from
> before the upgrade on an empty 9.2 server but here we are =>
> https://gist.github.com/kuuji/cc73c3c193a0d58aa0e651fbd7bfec58

Thanks.

> > > > Prod starting throwing the following errors during autovacuum ->
> > 'cannot
> > > > freeze committed xmax <xid>' on 2 different tables. Running vacuum
> > manually
> > > > revealed more tables affected by the same error.

What's an example <xid> in that message that triggers for
problematic_table?  I need that to properly interpret the data you
provided.

Thanks,

Andres


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

Предыдущее
От: Alexandre Garcia
Дата:
Сообщение: Re: postgresql 9.6 - cannot freeze committed xmax
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Reliable WAL file shipping over unreliable network