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 1tffas-0049Uq-R7 for pgsql-hackers@arkaria.postgresql.org; Wed, 05 Feb 2025 13:37:31 +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 1tffar-00EkDO-LE for pgsql-hackers@arkaria.postgresql.org; Wed, 05 Feb 2025 13:37:29 +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 1tffaq-00EkDG-9v for pgsql-hackers@lists.postgresql.org; Wed, 05 Feb 2025 13:37:29 +0000 Received: from fhigh-a6-smtp.messagingengine.com ([103.168.172.157]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tffan-003JtT-2K for pgsql-hackers@lists.postgresql.org; Wed, 05 Feb 2025 13:37:27 +0000 Received: from phl-compute-09.internal (phl-compute-09.phl.internal [10.202.2.49]) by mailfhigh.phl.internal (Postfix) with ESMTP id 96293114008F; Wed, 5 Feb 2025 08:37:24 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-09.internal (MEProxy); Wed, 05 Feb 2025 08:37:24 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eisentraut.org; h=cc:cc:content-transfer-encoding:content-type:content-type :date:date:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:subject:subject:to:to; s=fm2; t=1738762644; x=1738849044; bh=5cLSCT7DMj40F7pS2wOJEW93afmgO/Px eBfZgEDQE4E=; b=R/7UI9kXHn+0Eml8fVBtxX3ToQNluEsdYc/L6e1K7aSaJtgO zFJZqK5E3aCTuIFdq/alwMQInZRhWZu6sz6VY1PPwnqHiXdi/YmWff+928G+fbKh QCR3s3fsZyztC+q/0HHU2piQMaRLyDFowaVx1u7j/aQaTsSI2zKG1Mzl0TNEQHfj QFnUtDfGpZujp/yl0p86RMll371+5DyKGgA/aAUbUZnVN87FkX/pRKtVdhVkBJZL fVQiqvmeYutfw0qgCsJ2546Sg90KQAlGUcchWZ+c6WOx9cKyww5/fcgV704yqcmI lFHuj0Ywi/qiLl2Xlcy5rYxebhE1Oc0Dglem7w== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1738762644; x= 1738849044; bh=5cLSCT7DMj40F7pS2wOJEW93afmgO/PxeBfZgEDQE4E=; b=Q bkbs6yTw9Mv/zET+OcOIWsFEp+LdaySovc9uxQh5l6E4UZdxlnA9sfPDkH0gkJtZ bwmvTZ1eCC/dusJRU6R4pFQpqpjfUVD/RHIS8ABPGp4djxRnEm+nFoxDQ6mokZtU 2CuCcMLDRo+ERM/Kp27s2RHzAkpkf/aRIAGZKvrURpKZDKD8oKi+6wxK/kr9rEAq ARbUTtlgtwJyhDWqON2E2oRui8TCVxOl2XhgKrbMu4LbED57h4XTbRAnSDqz/7wk 9jux/au8OygrZHeYDKKL3ogNw8nPriwkA3HZIvaANWi7XrZGmGYLE4QcYp7yQN0M yOIRV6FsjrOD7mtc1k0Sg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgddvfeehlecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivg hnthhsucdlqddutddtmdenucfjughrpefkffggfgfuvfevfhfhjggtgfesthejredttddv jeenucfhrhhomheprfgvthgvrhcugfhishgvnhhtrhgruhhtuceophgvthgvrhesvghish gvnhhtrhgruhhtrdhorhhgqeenucggtffrrghtthgvrhhnpefgjedthfekfedtuefgieel heetleejgefhueeltdfhueetvdffudekfeejhfegheenucevlhhushhtvghrufhiiigvpe dtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehpvghtvghrsegvihhsvghnthhrrghuthdr ohhrghdpnhgspghrtghpthhtohephedpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtoh epphhjsehilhhluhhmihhnrghtvggutghomhhpuhhtihhnghdrtghomhdprhgtphhtthho pehtghhlsehsshhsrdhpghhhrdhprgdruhhspdhrtghpthhtohepjhhirghnrdhunhhivh gvrhhsrghlihhthiesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdhhrggt khgvrhhssehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrghdprhgtphhtthhopehvih hgnhgvshhhvddusehgmhgrihhlrdgtohhm X-ME-Proxy: Feedback-ID: ie0a040ee:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 5 Feb 2025 08:37:23 -0500 (EST) Message-ID: <50a1d589-4502-459f-8ce7-4e666684f87e@eisentraut.org> Date: Wed, 5 Feb 2025 14:37:21 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: SQL:2011 application time To: Paul Jungwirth Cc: Tom Lane , jian he , PostgreSQL Hackers , vignesh C References: <66e47fc0-77b7-4763-9b70-5c0b7ff15f21@eisentraut.org> <333d3886-b737-45c3-93f4-594c96bb405d@eisentraut.org> <6a2247d9-461d-4b0a-b692-f0f3c0fab27f@eisentraut.org> <8f995a4c-64e3-40cd-bfed-06b54a280d36@illuminatedcomputing.com> <0832f18d-523f-4c15-acb0-338a785150c5@illuminatedcomputing.com> <5f0c25de-2c13-4fb5-a4df-a1e03c43cd14@illuminatedcomputin! g.com> <1b45f81d-4e99-4813-a2c6-72bf5fd80980@eisentraut.org> <3611540.1737518430@sss.pgh.pa.us> <9bb3eea7-820f-4932-92cb-cb564fc44caf@eisentraut.org> <23923ad9-a468-4c2e-8926-e47d15d1eb23@eisentraut.org> Content-Language: en-US From: Peter Eisentraut In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 29.01.25 07:34, Paul Jungwirth wrote: > Is it possible to commit an RI_PLAN_NO_ACTION addition and see if that > makes the buildfarm failures go away? Here is a proposed patch for that > (v48.1). I would understand if this is too questionable a practice---but > it would be nice to get sufficient test exposure to see if it makes a > difference. Since I still haven't reproduced this locally (despite > running continuously for almost a week), it's not an experiment I can do > myself. If it *does* make the failures go away, then it suggests there > is still some latent problem somewhere. I'm tempted to give this a try. But the cfbot is currently in a bit of a mess, so I'll wait until that is clean again so that we can have a usable baseline to work against.