Re: oldest xmin is far in the past :: BUT xmin is not available in system

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: oldest xmin is far in the past :: BUT xmin is not available in system
Дата
Msg-id CAKFQuwaQsMFvvuK=1GZfaA2Mw1oOcd7tMpyzCCKkD986fVCTGw@mail.gmail.com
обсуждение исходный текст
Ответ на oldest xmin is far in the past :: BUT xmin is not available in system  (bhargav kamineni <kbn98406@gmail.com>)
Ответы Re: oldest xmin is far in the past :: BUT xmin is not available in system  (bhargav kamineni <kbn98406@gmail.com>)
Re: oldest xmin is far in the past :: BUT xmin is not available in system  (Rob Sargent <robjsargent@gmail.com>)
Список pgsql-general
Дерево обсуждения


On Monday, April 18, 2022, bhargav kamineni <kbn98406@gmail.com> wrote:
Hi Team,

It seems vacuum is behaving somewhat weird on postgres database , observing below HINTS on the vacuum logs

WARNING:  oldest xmin is far in the past

HINT:  Close open transactions soon to avoid wraparound problems.

You might also need to commit or roll back old prepared transactions, or drop stale replication slots.


What version?

What other databases are present?

Others can give better (more detailed/nuanced) guidance but if you can just start vacuuming every table in every database manually, you probably should just do that.  Vacuum freeze specifically.

David J.

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

Предыдущее
От: bhargav kamineni
Дата:
Сообщение: oldest xmin is far in the past :: BUT xmin is not available in system
Следующее
От: bhargav kamineni
Дата:
Сообщение: Re: oldest xmin is far in the past :: BUT xmin is not available in system