Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sOqE4-001Wwi-4Y for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Jul 2024 03:00:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sOqE2-005bHq-5k for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Jul 2024 03:00:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sOqE1-005bFj-Rv for pgsql-hackers@lists.postgresql.org; Wed, 03 Jul 2024 03:00:06 +0000 Received: from mail-lj1-x230.google.com ([2a00:1450:4864:20::230]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sOqDz-0008K2-Qc for pgsql-hackers@postgresql.org; Wed, 03 Jul 2024 03:00:05 +0000 Received: by mail-lj1-x230.google.com with SMTP id 38308e7fff4ca-2eabd22d3f4so49034371fa.1 for ; Tue, 02 Jul 2024 20:00:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1719975602; x=1720580402; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=P6lNL/nJMf61maGNBVFzKvq8UUiYjHCLtr9I/03d7sE=; b=AnErvw89fINQo1ofUD7OQKip9B9kAolkeLLguxI3OICp1gPK1l7/JZN9uN0l1ZI0zc XZ3mnqpfa00rgztpIERc/ZVuugRhleNEj1V6F+edo/4jXuCUPdvFRACrylssXaP6qQMR QIVfQYLNx8WPOfPPC+1F/uqg5KxYy3W4za4d0JtCAY59tktbxiFksOThpHM2HA7DUHVi JP2sQmXCNnBtQKwZzkhfq7WBxQMQmEOANqWr3ZLAx4mjCsox0ZG4G9tdXCpaBwxZhuIs 1e9pbzYJOKhABVT5MmtK0sqWPkPD3eDilCm1g35lijE9OZaW0gxyJI8GFVINVJNCMLLM lwhA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1719975602; x=1720580402; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=P6lNL/nJMf61maGNBVFzKvq8UUiYjHCLtr9I/03d7sE=; b=XWYjVh4MnPk39CGAbO+azgxtCKKwjah1z8Dn/1Eq8p2UYDuGiBBLxD1BabhN7t9srj NNWLPrlS+Xf5X0ztiUMZO/gOEUvIyoHytTq4o3VGIVK1AWQ240UdlnMW4OiFdlr94NR9 wagoU00vcx5sG4RaTfKfpAxE1TiYKugaqZKnQDp7xyqc5Ce6HqEYI2p5wZXO2J1K1kkY bO/3GlGKKNKWL3pgkXZLMM/gXP6FTzh288H5TG9ZGpdul21F2J3xJkwVQzinctVljniP 0Tu9fR5p8PKvAyQtPuVSVi36wcGeShsDaU1vUptc5MFybY+NkPS+HO1tPZUDsi2tocZe mGdA== X-Forwarded-Encrypted: i=1; AJvYcCUmvYHyvJ+MAINv2AmGZS3rhAgeNXxYlF2xWIVezQNj97wYlGs3vVG3MOf6JPH2Lx+4a2yo9hGruJncje0vHFknUOyjjjNgCXN4OORb X-Gm-Message-State: AOJu0Ywix6baHmgo/amn7e1MKvqGTTXA4lvSl9TffgAB5MNQNKCowQhv NjBNSCIbU9LzywOokeWMVrQFlHmmeoqObdahN4mJQDZfM2qrlKN0 X-Google-Smtp-Source: AGHT+IG7VlCnuTFaFGdF4BfU0Ug2JzVw8lZzdKVHDEmVKM0ls+yzgfuqYuuNBF/2u/i2bssr39srOw== X-Received: by 2002:a2e:309:0:b0:2ee:7bcd:a52 with SMTP id 38308e7fff4ca-2ee7bcd1051mr7203981fa.46.1719975601824; Tue, 02 Jul 2024 20:00:01 -0700 (PDT) Received: from [1.0.0.7] ([178.155.22.46]) by smtp.gmail.com with ESMTPSA id 38308e7fff4ca-2ee516802bdsm18555611fa.84.2024.07.02.20.00.00 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 02 Jul 2024 20:00:01 -0700 (PDT) Message-ID: Date: Wed, 3 Jul 2024 06:00:00 +0300 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: race condition in pg_class Content-Language: en-US To: Noah Misch , Tom Lane Cc: Robert Haas , pgsql-hackers@postgresql.org, Smolkin Grigory , Michael Paquier References: <20231027232612.99.nmisch@google.com> <20231102030915.d3.nmisch@google.com> <20240512232923.aa.nmisch@google.com> <20240605181706.fe.nmisch@google.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> From: Alexander Lakhin In-Reply-To: <20240629024251.03.nmisch@google.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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