pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@anarazel.de>
Cc: Peter Geoghegan <pg@bowt.ie>
Cc: Dmitry Dolgov <9erthalion6@gmail.com>
Cc: Alexander Lakhin <exclusion@gmail.com>
Cc: Matthias van de Meent <boekewurm+postgres@gmail.com>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum
Date: Thu, 03 Feb 2022 15:54:28 -0500
Message-ID: <294529.1643921668@sss.pgh.pa.us> (raw)
In-Reply-To: <20220114021549.m6ugihzjmsunv3jd@alap3.anarazel.de>
References: <20211111030821.2xxl75qfkynaga4j@alap3.anarazel.de>
	<20211116023918.5g6d6izevronx76m@alap3.anarazel.de>
	<CAH2-Wz=w6wVbat4B=HQTzim5ki=NyPhT6FxWPST=tN2+BjHrpw@mail.gmail.com>
	<20211122175914.ayk6gg6nvdwuhrzb@alap3.anarazel.de>
	<CAH2-Wzk+=kCS5SMMQ++s5vX9NmWKxJmOBfU2wqR-n78cOYFgfA@mail.gmail.com>
	<20211122223436.ov3qa27pakxay6z7@alap3.anarazel.de>
	<20211211045710.ljtuu4gfloh754rs@alap3.anarazel.de>
	<CAH2-WzkNr0t2e9Vr8T8QZNzA1Vze9C7s5-=61nhz2gHAooW05Q@mail.gmail.com>
	<20220112192508.vibr6o64h7sy7mbw@alap3.anarazel.de>
	<CAH2-WzkuGdm6-7euVQaGBK=BD6sOZJckgnkx3XWwYNB_ysjGbQ@mail.gmail.com>
	<20220114021549.m6ugihzjmsunv3jd@alap3.anarazel.de>

Andres Freund <andres@anarazel.de> writes:
>>> I'm just struggling with / procrastinating on the commit message, tbh. The
>>> whole issue is kinda complicated to explain... :/

> After struggling some more, I *finally* pushed the fix and the new assertions.

I'm writing release notes and wondering what I can tell users about
how to detect or recover from this bug.  Is a REINDEX sufficient,
or is the presence of the bogus redirect item going to cause
persistent problems?  If the latter, can we provide some amelioration?
"Your data is broken and there is nothing you can do about it"
is not nice to be writing in release notes.

			regards, tom lane





view thread (90+ messages)  latest in thread

Message-ID: <294529.1643921668@sss.pgh.pa.us>
Permalink:  ../294529.1643921668@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/294529.1643921668@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, andres@anarazel.de, pg@bowt.ie, 9erthalion6@gmail.com, exclusion@gmail.com, boekewurm+postgres@gmail.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum
  In-Reply-To: <294529.1643921668@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox