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

help / color / mirror / Atom feed
From: Alexander Lakhin <exclusion@gmail.com>
To: Noah Misch <noah@leadboat.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers@postgresql.org, Smolkin Grigory <smallkeen@gmail.com>
Cc: Michael Paquier <michael@paquier.xyz>
Subject: Re: race condition in pg_class
Date: Wed, 3 Jul 2024 06:00:00 +0300
Message-ID: <a295b499-dcab-6a99-c06e-01cf60593344@gmail.com> (raw)
In-Reply-To: <20240629024251.03.nmisch@google.com>
References: <20231027232612.99.nmisch@google.com>
	<20231102030915.d3.nmisch@google.com>
	<20240512232923.aa.nmisch@google.com>
	<20240605181706.fe.nmisch@google.com>
	<CA+TgmobfMU5pdXP36D5iAwxV5WKE_vuDLtp_1QyH+H5jMMt21g@mail.gmail.com>
	<20240611024525.9f.nmisch@google.com>
	<20240614003549.c2.nmisch@google.com>
	<20240621212842.98.nmisch@google.com>
	<20240628051353.a0.nmisch@google.com>
	<1914892.1719551842@sss.pgh.pa.us>
	<20240629024251.03.nmisch@google.com>

Hello Noah,

29.06.2024 05:42, Noah Misch wrote:
> Good point, any effort on (2) would be wasted once the fixes get certified.  I
> pushed (1).  I'm attaching the rebased fix patches.

Please look at a new anomaly, introduced by inplace110-successors-v5.patch:
CREATE TABLE t (i int) PARTITION BY LIST(i);
CREATE TABLE p1 (i int);
ALTER TABLE t ATTACH PARTITION p1 FOR VALUES IN (1);
ALTER TABLE t DETACH PARTITION p1;
ANALYZE t;

triggers unexpected
ERROR:  tuple to be updated was already modified by an operation triggered by the current command

Best regards,
Alexander





view thread (86+ messages)  latest in thread

Message-ID: <a295b499-dcab-6a99-c06e-01cf60593344@gmail.com>
Permalink:  ../a295b499-dcab-6a99-c06e-01cf60593344@gmail.com/
Also on:    postgresql.org/message-id/a295b499-dcab-6a99-c06e-01cf60593344@gmail.com

 · 

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-hackers@postgresql.org
  Cc: exclusion@gmail.com, noah@leadboat.com, tgl@sss.pgh.pa.us, robertmhaas@gmail.com, smallkeen@gmail.com, michael@paquier.xyz
  Subject: Re: race condition in pg_class
  In-Reply-To: <a295b499-dcab-6a99-c06e-01cf60593344@gmail.com>

* 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