On Wed, Jul 24, 2019 at 05:27:18PM +0900, Kyotaro Horiguchi wrote:
> Sorry in advance for link-breaking message forced by gmail..
Using the archives page "Resend email" link avoids that.
> https://www.postgresql.org/message-id/flat/20190202083822.GC32531@gust.leadboat.com
>
> > 1. The result of the test is valid only until we release the SLRU ControlLock,
> > which we do before SlruScanDirCbDeleteCutoff() uses the cutoff to evaluate
> > segments for deletion. Once we release that lock, latest_page_number can
> > advance. This creates a TOCTOU race condition, allowing excess deletion:
> >
> >
> > [local] test=# table trunc_clog_concurrency ;
> > ERROR: could not access status of transaction 2149484247
> > DETAIL: Could not open file "pg_xact/0801": No such file or directory.
>
> It seems like some other vacuum process saw larger cutoff page?
No, just one VACUUM suffices.
> If I'm
> not missing something, the missing page is no longer the
> "recently-populated" page at the time (As I understand it as the last
> page that holds valid data). Couldn't we just ignore ENOENT there?
The server reported this error while attempting to read CLOG to determine
whether a tuple's xmin committed or aborted. That ENOENT means the relevant
CLOG page is not available. To ignore that ENOENT, the server would need to
guess whether to consider the xmin committed or consider it aborted. So, no,
we can't just ignore the ENOENT.
