pgsql: Fix use of wrong index in ComputeXidHorizons(). - Mailing list pgsql-committers

From Andres Freund
Subject pgsql: Fix use of wrong index in ComputeXidHorizons().
Date
Msg-id E1k7QAL-00024z-HV@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix use of wrong index in ComputeXidHorizons().

This bug, recently introduced in 941697c3c1a, at least lead to vacuum
failing because it found tuples inserted by a running transaction, but
below the freeze limit. The freeze limit in turn is directly affected
by the aforementioned bug.

Thanks to Tom Lane figuring how to make the bug reproducible.

We should add a few more assertions to make sure this type of bug
isn't as hard to notice, but it's not yet clear how to best do so.

Co-Diagnosed-By: Tom Lane <tgl@sss.pgh.pa.us>
Author: Andres Freund <andres@anarazel.de>
Discussion: https://postgr.es/m/1013484.1597609043@sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/f6661d3df228dbbf50efb04f2b760774a6f2bfff

Modified Files
--------------
src/backend/storage/ipc/procarray.c | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)


pgsql-committers by date:

Previous
From: Andres Freund
Date:
Subject: pgsql: Make vacuum a bit more verbose to debug BF failure.
Next
From: Michael Paquier
Date:
Subject: pgsql: doc: Fix description about bgwriter and checkpoint in HA section