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 1riZDz-000KkW-IW for pgsql-hackers@arkaria.postgresql.org; Fri, 08 Mar 2024 12:21:20 +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 1riZDx-00CWvF-A4 for pgsql-hackers@arkaria.postgresql.org; Fri, 08 Mar 2024 12:21:17 +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 1riZDw-00CWv7-W0 for pgsql-hackers@lists.postgresql.org; Fri, 08 Mar 2024 12:21:17 +0000 Received: from mail-ej1-x633.google.com ([2a00:1450:4864:20::633]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1riZDs-003Tbx-2e for pgsql-hackers@lists.postgresql.org; Fri, 08 Mar 2024 12:21:15 +0000 Received: by mail-ej1-x633.google.com with SMTP id a640c23a62f3a-a293f2280c7so328801666b.1 for ; Fri, 08 Mar 2024 04:21:12 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1709900470; x=1710505270; darn=lists.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=Gf6espHv09qYdiGMxQa/eTXIW07IBR+w+m3nO3baOh8=; b=YkCbkJFC5T66K2oCjE8a5Ca+yAc1LvyboxQC2a2LlB1erJSxQJ7uz4zwV4byeokW8s k5L8XCVhbKYDARdseVe8WBMiaMNGS9qhSRlCuL5g/2Z9waPfNtj+Cp4t2K9IYfC6LUNc 7QeEsD0EFkmQT3XKQ4tQurBcShiRgzCAutq85UrZSTN1UQ8oZ7yki9Sm4zr8cRSuIQVL 9imCt+FNz1SUxn1VFj88RQ3aR/BmXkygIAqavrZWCTZbJLviKMwRU50iz45MAl4qh76A XBN/wFffLoqHlnV2GAbYvo6vSpsWBwM+dGvicNuEqt+EPCJ+o2EYQ1rek0EHrvH2VVxm K3sw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1709900470; x=1710505270; 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=Gf6espHv09qYdiGMxQa/eTXIW07IBR+w+m3nO3baOh8=; b=B4TLUw4jC9xwsrhXgV/v3Nx7BZQg82CyonhmADkpWS2T7RC8Q3v1vK/HI1KhWZz9Pp yUn0j6mVY11qPXJ0JUJLsE6yb0VZoMOqKW72E5+efDNYmPQ43px8OS94eVJrU9kC0tmn hwadYrZuSpmWsxs5ge4VfWWcydWLqXUq6qdl6G+LkDgi1jb754XjVWIp9GIUg5T/c6CB obpf0XqjXCj94v5B1rBUYMkKuSOScgkFtig8vg6SXtEejd5koS8rs2MTSIf2bfZJu/oY IVYBYcibsUBMESekIp8GQLtNQYmHgY/r5Etb4rbIoHS1sKhJ2EUApazCMZLDB5/EebBE nURQ== X-Forwarded-Encrypted: i=1; AJvYcCWDfinMwHvKyUD9Yi1c1dls306Z0VGazVe9otgD83P2acJpudycB5xCUuD52uBK02FIIQugRyhJtcwjQe8D9+ZHl9fXAt3/cR3bFNkQ0+5glrtw X-Gm-Message-State: AOJu0Yzb0C+5P1WUCLw3WD2Lzkz/kiSgYuPdYMmdIA5S9NISlkPsXBBg reZCzB5u5cZ5IEoGAPd7N1W8stH5h73qI5f2h4V2LdoFuwsXN/SMkWzYhWsWPw== X-Google-Smtp-Source: AGHT+IFcYBEQV6NYwKU0B8BnWwjtCkXcGaUvNkICglRGYmjK8SWD3xM4zY1Y0f3/lAgXrW0+IB9U3A== X-Received: by 2002:a17:906:f108:b0:a43:e63b:2ecc with SMTP id gv8-20020a170906f10800b00a43e63b2eccmr14784879ejb.67.1709900470560; Fri, 08 Mar 2024 04:21:10 -0800 (PST) Received: from [10.137.0.18] (ip-86-49-229-30.bb.vodafone.cz. [86.49.229.30]) by smtp.gmail.com with ESMTPSA id mp7-20020a1709071b0700b00a440ceb4110sm9330513ejc.183.2024.03.08.04.21.10 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 08 Mar 2024 04:21:10 -0800 (PST) Message-ID: Date: Fri, 8 Mar 2024 13:21:09 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Failures in constraints regression test, "read only 0 of 8192 bytes" Content-Language: en-US To: Thomas Munro Cc: Ronan Dunklau , PostgreSQL Hackers References: <2185821.Icojqenx9y@aivenlaptop> <5c5a0015-723a-4fa7-85d5-2f0f47b92094@enterprisedb.com> From: Tomas Vondra In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 3/8/24 09:33, Thomas Munro wrote: > Happened again. I see this is OpenSUSE. Does that mean the file > system is Btrfs? It is, but I don't think that matters - I've been able to reproduce this locally on my laptop using ext4 filesystem. I'd bet the important piece here is -DCLOBBER_CACHE_ALWAYS (and it seems avocet/trilobite are the only animals running with this). Also, if this really is a filesystem (or environment) issue, it seems very strange it'd only affect HEAD and not the other branches. So it seems quite likely this is actually triggered by a commit. Looking at the commits from the good/bad runs, I see this: avocet: good=4c2369a bad=f5a465f trilobite: good=d13ff82 bad=def0ce3 That means the commit would have to be somewhere here: f5a465f1a07 Promote assertion about !ReindexIsProcessingIndex to ... 57b28c08305 Doc: fix minor typos in two ECPG function descriptions. 28e858c0f95 Improve documentation and GUC description for ... a661bf7b0f5 Remove flaky isolation tests for timeouts 874d817baa1 Multiple revisions to the GROUP BY reordering tests 466979ef031 Replace lateral references to removed rels in subqueries a6b2a51e16d Avoid dangling-pointer problem with partitionwise ... d360e3cc60e Fix compiler warning on typedef redeclaration 8af25652489 Introduce a new smgr bulk loading facility. e612384fc78 Fix mistake in SQL features list d13ff82319c Fix BF failure in commit 93db6cbda0. My guess would be 8af25652489, as it's the only storage-related commit. I'm currently running tests to verify this. regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company