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 1tO3Cl-003lb6-KG for pgsql-general@arkaria.postgresql.org; Wed, 18 Dec 2024 23:11:48 +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 1tO3Ck-003OvH-UW for pgsql-general@arkaria.postgresql.org; Wed, 18 Dec 2024 23:11:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tO3Cj-003Ov8-LF for pgsql-general@lists.postgresql.org; Wed, 18 Dec 2024 23:11:46 +0000 Received: from fhigh-a7-smtp.messagingengine.com ([103.168.172.158]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tO3Ce-000UDk-O1 for pgsql-general@lists.postgresql.org; Wed, 18 Dec 2024 23:11:44 +0000 Received: from phl-compute-03.internal (phl-compute-03.phl.internal [10.202.2.43]) by mailfhigh.phl.internal (Postfix) with ESMTP id 6BE4B114012C; Wed, 18 Dec 2024 18:11:38 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-03.internal (MEProxy); Wed, 18 Dec 2024 18:11:38 -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=fm3; t=1734563498; x=1734649898; bh=feqZwtNeqeal6EvD6pZUDhxjjJzlhGtE1SisJfhKaF0=; b= VPBkABQhMhfoG/Ny1lTaqMJfjlJmWyQWzKGNaWo6lzfZo0u4ZZSUgsveqrtkOqGW a7mrUPO+uedEYjprMD945P50uUZ/jq3bicf2RFjMqN5Y9Gmhtu9IqdrSPvh0F8JH MkG/X4aa3JUHldVbwki9jVFYbyGe8U+rrzVpg/7+mYqR+ZtWRxsZwFoFK6ePMFNv eK7xpqAPx9HnSWFE+u2tMn4U+jNdV5ZjAi35Pv0xKSyMEhN7+UXQlWWAwdpVTlaF daZG5paFPAX0o5xVRwAaYXXyxkd8hhXmI6rHDVAzGX4Lvxemtqy105DmClpQcv0h yljwdUg3/oHTeGRCA8g/XA== 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=fm1; t=1734563498; x= 1734649898; bh=feqZwtNeqeal6EvD6pZUDhxjjJzlhGtE1SisJfhKaF0=; b=4 b/IG4QdvDTyg9LXikZkz4nTsGqp03gK3GbwKawCd1kdvJSDG1C13W298XC8zoS3b 4KGu1PWSt81opDlWBlckSW/3moOsJq6nf++qBbMWTgxuEXvLOkg4hNhUYBR/9VUP rrLPeqlg2iE2UHVNH+iVPGmzkGdh+oWhk1+MOZJUca0Z1oEJeA48YChv9AMma4ta jGJXiCWYduSwcMzX+YTjpcd7ct0yO+ONCHJdkRPoqKZByPKh/oVZpF2I363dT8MF vntffUcz0P0xmAfS7HQAWwZ8KCB+RjnQKs1BkdGmJPFfQiJw7fHK0h426kTeif7l 91MkaddzFgwr4fLRsf9uA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrleelgddtjecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdpuffr tefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnth hsucdlqddutddtmdenucfjughrpefkffggfgfuvfevfhfhjggtgfesthekredttddvjeen ucfhrhhomheptegurhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrse grkhhlrghvvghrrdgtohhmqeenucggtffrrghtthgvrhhnpedujeekjeevueehleeuhedu veejudevjeettedthfevuddvheefuedutddvfeeuueenucffohhmrghinhepghhruhhpph hotghlvghishdrihhtpdegjhhsrdgtohhmnecuvehluhhsthgvrhfuihiivgeptdenucfr rghrrghmpehmrghilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrh drtghomhdpnhgspghrtghpthhtohepgedpmhhouggvpehsmhhtphhouhhtpdhrtghpthht ohepvghstghhvghnohhnvgestghlvghishhtvggthhdrihhtpdhrtghpthhtohepphhgsh hqlhdqghgvnhgvrhgrlheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhgpdhrtghp thhtohepmhgtrghtthhisegtlhgvihhsthgvtghhrdhithdprhgtphhtthhopehlphhiii iiohhlohestghlvghishhtvggthhdrihht X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 18 Dec 2024 18:11:37 -0500 (EST) Message-ID: <25d5fb16-9bb2-4ad1-969c-eaca03ccbaaf@aklaver.com> Date: Wed, 18 Dec 2024 15:11:36 -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> Content-Language: en-US From: Adrian Klaver In-Reply-To: <446423eb-4a4e-4135-bbb8-4d0e5c7aac3b@cleistech.it> 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 On 12/17/24 08:30, Enrico Schenone wrote: > Good day. > My name is Enrico Schenone, from Genoa, Italy. > I'm a software achitect working at Cleis Tech - Genoa - Italy  - > http://gruppocleis.it > Me and my team are using PostgreSQL v12 to v16 on Debian 10-12 and > Ubuntu Server 22.04 LTS with no-cluster configuration. > Our applications are developed with 4Js Genero platform (classified as > LCAP) - https://4js.com > > I whish to report an issue where I can't say if it happens at server or > client side (or both as well). This: "unexpected EOF on client connection " makes me believe this is on client side. To be clear the client is running on Ubuntu Server 22.04, correct? Have you looked at the OS system log for relevant entries at the time the error occurs? If so what are they? This only happens in production environment, is there anything in it that is materially different from where you ran the test below? > Hoping you can help me or address to someone who can do it. > Thanks in advance. > Enrico > -- > > *Enrico Schenone* > Software Architect > -- Adrian Klaver adrian.klaver@aklaver.com