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 1tY5rp-003VMq-99 for pgsql-general@arkaria.postgresql.org; Wed, 15 Jan 2025 16:03:42 +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 1tY5rn-00DaGw-Si for pgsql-general@arkaria.postgresql.org; Wed, 15 Jan 2025 16:03:40 +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 1tY5rm-00DaEa-Ki for pgsql-general@lists.postgresql.org; Wed, 15 Jan 2025 16:03:39 +0000 Received: from fout-b2-smtp.messagingengine.com ([202.12.124.145]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tY5rl-000Yfb-00 for pgsql-general@lists.postgresql.org; Wed, 15 Jan 2025 16:03:38 +0000 Received: from phl-compute-01.internal (phl-compute-01.phl.internal [10.202.2.41]) by mailfout.stl.internal (Postfix) with ESMTP id 7F7EA1140140; Wed, 15 Jan 2025 11:03:35 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-01.internal (MEProxy); Wed, 15 Jan 2025 11:03:35 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; 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=fm1; t=1736957015; x=1737043415; bh=dtkWcnL8voL//Atu4yL/EIRueNdCx71cg5b5Tr40cxs=; b= UdQSw49wmvUbwdn/20NLkz1DT7LAnKNGl7qJZEOTfn0jh3MdK2F+YDwX+yFHkGzT gKFO4U5yWfU9nwgxevFoc4oFI8sW2m3cXPWgovCmam0wixFJVIsMhlptE8wDb3Fz bpqP0MSvnSczE29wf/mJ1/6rJCzk6ADj03nb9GtFZYIy1vNX/toMj4X+WOau9gKY 8WP6Wdfp2yFhkvh6+GvR+pKiyDnuq+cucvrYhl5/AxYbSLr+GBHaw8U9L5zcnjlc tXYFysaVdWinPznOVfYz9GtNdDvrJ4j/0MaNflTDwGJ1bGRNywWsyxJhW1ftrzFz nnl6jv0JGthoC5FM9LeVpA== 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=fm2; t=1736957015; x= 1737043415; bh=dtkWcnL8voL//Atu4yL/EIRueNdCx71cg5b5Tr40cxs=; b=B 2crrXV+5fXO98/HpZJiEPq0sS/7TsOXKPMneVVINodyy+tWLhA/VoWft3lKd+O3/ /G7UM0cKANxTQgj8txruC38JAcD/eCr60PL3M6HFkuYJ+RL2V+utneCtXZxv0mio 2sxK/qhE4Y5YUN3H31XF46ya0UKHD9V26pVsWl4PPvtdy7ejUBnH0jQP/4B0Gmb3 lqUCKzX8COA5H9PX0QP5aL18xVLXwxLaxy6Q6qp6BhWR1GgJUJWVFnbcuYUPAkOs 8gUCe9COUdb9+l2pGvoOxFHdYyGF/RQdtuwhetWyiagjxgi1W9veirGa1y7TyyLd XCwtuzPEy5eCHWqGdUMOg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrudehledgheejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnecujfgurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddtvdej necuhfhrohhmpeetughrihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrh esrghklhgrvhgvrhdrtghomheqnecuggftrfgrthhtvghrnhephfeviefhveelffeftdeh udekveefhfeftdegieefveetfffgfeehtdfftedutedtnecuvehluhhsthgvrhfuihiivg eptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghk lhgrvhgvrhdrtghomhdpnhgspghrtghpthhtohepgedpmhhouggvpehsmhhtphhouhhtpd hrtghpthhtohepvghstghhvghnohhnvgestghlvghishhtvggthhdrihhtpdhrtghpthht ohepphhgshhqlhdqghgvnhgvrhgrlheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorh hgpdhrtghpthhtohepmhgtrghtthhisegtlhgvihhsthgvtghhrdhithdprhgtphhtthho pehlphhiiiiiohhlohestghlvghishhtvggthhdrihht X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 15 Jan 2025 11:03:34 -0500 (EST) Message-ID: <2ad021af-ee3b-4c0a-9b08-fb06a8414432@aklaver.com> Date: Wed, 15 Jan 2025 08:03:33 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Intermittent errors when fetching cursor rows on PostgreSQL 16 To: Enrico Schenone , pgsql-general@lists.postgresql.org Cc: Massimo Catti , Livio Pizzolo References: <446423eb-4a4e-4135-bbb8-4d0e5c7aac3b@cleistech.it> <25d5fb16-9bb2-4ad1-969c-eaca03ccbaaf@aklaver.com> <6ce80aaa-970b-4432-938a-39a07f811599@cleistech.it> <9f60eb26-7d34-4228-bd78-74c6deb90e54@aklaver.com> <282c2a48-bb12-4486-b03d-563523cac81b@cleistech.it> <2645a89e-d661-4f2b-92b3-01154a78d535@aklaver.com> <54689a6a-839c-44c4-90b5-b9692e8e7cb0@aklaver.com> <4efe42a2-789c-4957-a564-25199869f6ec@cleistech.it> <382a1eec-2069-4010-bbdb-37260a1a53a7@cleistech.it> <8d65f84d-ddb3-4d0f-be05-44f443500e41@aklaver.com> <54b91cf3-1d0c-4134-89c8-8e76ed46415c@cleistech.it> <9dab3561-3b45-4dac-9522-c84192f87d52@aklaver.com> <01abb0f3-8225-480c-9ba6-397018902106@cleistech.it> Content-Language: en-US From: Adrian Klaver In-Reply-To: <01abb0f3-8225-480c-9ba6-397018902106@cleistech.it> 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 1/14/25 23:46, Enrico Schenone wrote: >> Which environment did you run the recent prolonged test against? > The first one: Distinct application server and DB server on distinct > subnets. >> Is that the same as where you saw the errors? > *Enrico Schenone* > Software Architect -- Adrian Klaver adrian.klaver@aklaver.com