Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] BDR, near xid wraparound, a lot of files in pg_subtrans directory - Mailing list pgsql-general

From Craig Ringer
Subject Re: [GENERAL] BDR, near xid wraparound, a lot of files in pg_subtrans directory
Date
Msg-id CAMsr+YGX2RwHAwnjP2eDYEFAfZZ7h+Rxsfjt9ZhBx0hMLT5+SA@mail.gmail.com
Whole thread Raw
In response to [GENERAL] BDR, near xid wraparound, a lot of files in pg_subtrans directory  (milist ujang <ujang.milist@gmail.com>)
Responses Re: [GENERAL] BDR, near xid wraparound, a lot of files in pg_subtrans directory  (milist ujang <ujang.milist@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [GENERAL] looking for a globally unique row ID
Next
From: George Neuner
Date:
Subject: Re: [GENERAL] looking for a globally unique row ID