Re: could not truncate directory "pg_subtrans": apparent wraparound - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: could not truncate directory "pg_subtrans": apparent wraparound
Date
Msg-id CAEepm=3_H+e17cc7WF=_ePp_-2GoZ8A0XS6CWeS1jmPQt2S=Wg@mail.gmail.com
Whole thread Raw
In response to Re: could not truncate directory "pg_subtrans": apparent wraparound  (Thomas Munro <thomas.munro@enterprisedb.com>)
Responses Re: could not truncate directory "pg_subtrans": apparent wraparound  (Thomas Munro <thomas.munro@enterprisedb.com>)
List pgsql-hackers
On Mon, Jun 8, 2015 at 12:29 PM, Thomas Munro
<thomas.munro@enterprisedb.com> wrote:
> Here's a repro script and a suggested patch.

Argh... I realised immediately after sending this that subtransaction
truncation doesn't even use the oldest XID computed by vacuum, it uses
GetOldestXmin (the "oldest transaction that was running when any
current transaction was started").  So here is an even simpler repro,
though the fix is the same (with different comments).

--
Thomas Munro
http://www.enterprisedb.com

Attachment

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: could not truncate directory "pg_subtrans": apparent wraparound
Next
From: Alvaro Herrera
Date:
Subject: Re: [CORE] Restore-reliability mode