Re: [GENERAL] BDR, near xid wraparound, a lot of files in pg_subtrans directory

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: [GENERAL] BDR, near xid wraparound, a lot of files in pg_subtrans directory
Дата
Msg-id CAMsr+YGX2RwHAwnjP2eDYEFAfZZ7h+Rxsfjt9ZhBx0hMLT5+SA@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] BDR, near xid wraparound, a lot of files in pg_subtrans directory  (milist ujang <ujang.milist@gmail.com>)
Ответы Re: [GENERAL] BDR, near xid wraparound, a lot of files in pg_subtrans directory  (milist ujang <ujang.milist@gmail.com>)
Список pgsql-general
Дерево обсуждения
On 14 September 2017 at 13:35, milist ujang <ujang.milist@gmail.com> wrote:
HI list,

I have a database with bdr environment which keep alerting these messages in log file:

HINT:  Close open transactions soon to avoid wraparound problems.
WARNING:  oldest xmin is far in the past

Do you have any idle/old replication slots, perhaps from failed node joins or abandoned nodes not properly parted?

SELECT *
FROM pg_replication_slots;

Also check

SELECT oid,*
FROM pg_database;


--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: [GENERAL] looking for a globally unique row ID
Следующее
От: George Neuner
Дата:
Сообщение: Re: [GENERAL] looking for a globally unique row ID