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 1tb9qk-008V8K-Jj for pgsql-hackers@arkaria.postgresql.org; Fri, 24 Jan 2025 02:55:15 +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 1tb9qi-008X4Z-Qd for pgsql-hackers@arkaria.postgresql.org; Fri, 24 Jan 2025 02:55:12 +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 1tb9qi-008X4R-HW for pgsql-hackers@lists.postgresql.org; Fri, 24 Jan 2025 02:55:12 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tb9qd-001C31-2p for pgsql-hackers@lists.postgresql.org; Fri, 24 Jan 2025 02:55:11 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 50O2t49c271902; Thu, 23 Jan 2025 21:55:04 -0500 From: Tom Lane To: Paul Jungwirth cc: Peter Eisentraut , jian he , PostgreSQL Hackers , vignesh C Subject: Re: SQL:2011 application time In-reply-to: References: <6dc196d4-8853-49d7-8dd3-e391058451c1@eisentraut.org> <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> <246156.1737674914@sss.pgh.pa.us> Comments: In-reply-to Paul Jungwirth message dated "Thu, 23 Jan 2025 15:54:15 -0800" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <271900.1737687304.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Thu, 23 Jan 2025 21:55:04 -0500 Message-ID: <271901.1737687304@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Paul Jungwirth writes: > On 1/23/25 15:28, Tom Lane wrote: >> I've only noticed the two, but I did not mount an aggressive search. >> It's possible that there were failures before 1772d554b0, since I >> now see that the diff is in a test case that is older than that. > Okay, I'll keep in mind that it could be older. I've now run an exhaustive search through the last three months of buildfarm runs, and found just one additional instance of the same failure. The three matches are https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Dcalliphoridae&dt= =3D2025-01-22%2005%3A49%3A08 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Dindri&dt=3D2025-= 01-22%2001%3A29%3A35 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Dmylodon&dt=3D202= 5-01-22%2001%3A17%3A14 Since those are all post-1772d554b0, it's difficult to avoid the conclusion that that either introduced the error or allowed a pre-existing problem to become visible. regards, tom lane