Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum

Andres Freund <andres@anarazel.de>

From: Andres Freund <andres@anarazel.de>

To: Dmitry Dolgov <9erthalion6@gmail.com>

Cc: Peter Geoghegan <pg@bowt.ie>, Alexander Lakhin <exclusion@gmail.com>, Matthias van de Meent <boekewurm+postgres@gmail.com>, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

Date: 2021-12-13T18:48:56Z

Lists: pgsql-bugs

On 2021-12-13 13:21:54 +0100, Dmitry Dolgov wrote:
> > On Fri, Dec 10, 2021 at 08:58:26PM -0800, Andres Freund wrote:
> > Does your modified test still find problems with 0001 & 0002 from
> > https://postgr.es/m/20211211045710.ljtuu4gfloh754rs%40alap3.anarazel.de
> > applied?
> 
> Nope, everything seems to be working smoothly.

Thanks!

Commits

vacuumlazy.c: Standardize rel_pages terminology.
- e370f100f05d 15.0 landed
vacuumlazy.c: document vistest and OldestXmin.
- 73f6ec3d3c8d 15.0 landed
heap pruning: Only call BufferGetBlockNumber() once.
- c702d656a283 15.0 landed
Fix possible HOT corruption when RECENTLY_DEAD changes to DEAD while pruning.
- dad1539aec28 14.2 landed
- 18b87b201f73 15.0 landed
Assert redirect pointers are sensible after heap_page_prune().
- bb42bfb5ccb5 15.0 landed
Remove tupgone special case from vacuumlazy.c.
- 8523492d4e34 14.0 cited
Recycle nbtree pages deleted during same VACUUM.
- 9dd963ae2534 14.0 cited
snapshot scalability: Don't compute global horizons while building snapshots.
- dc7420c2c927 14.0 cited
Refactor heap_page_prune so that instead of changing item states on-the-fly,
- 6f10eb21118f 8.4.0 cited