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 1tOg4j-007zUO-7P for pgsql-general@arkaria.postgresql.org; Fri, 20 Dec 2024 16:42:05 +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 1tOg4i-00DiLM-8e for pgsql-general@arkaria.postgresql.org; Fri, 20 Dec 2024 16:42:03 +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 1tOg4h-00DiLE-EL for pgsql-general@lists.postgresql.org; Fri, 20 Dec 2024 16:42:03 +0000 Received: from fout-a6-smtp.messagingengine.com ([103.168.172.149]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tOg4a-000a35-IU for pgsql-general@lists.postgresql.org; Fri, 20 Dec 2024 16:42:01 +0000 Received: from phl-compute-05.internal (phl-compute-05.phl.internal [10.202.2.45]) by mailfout.phl.internal (Postfix) with ESMTP id ACD851380251; Fri, 20 Dec 2024 11:41:55 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-05.internal (MEProxy); Fri, 20 Dec 2024 11:41:55 -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=1734712915; x=1734799315; bh=unyz/WnVh7+OxYBHU6TJ6pEE4612qTjnjWvoNbMe1Ic=; b= dSANljHNaonijcRKBZejrrewp5Ev1lLzswp0YYhY/lYRHOGYTAhQji0LmSirAQY5 EEYc8Y9M4vsK0ld5t00JHAKmCV4p2+1VLFda48TBqiJB2454Vl7V8Orcda9bB4Kb rGFg9XsObgbXpTDUDwEB9VeDCi61HnkU2kcsXHOpsWACQ0gsUcOwwNR5Qgf2jjra TLmA+OPRjRIq3aLNMREPPXjFwEqQRk3AJ/0hf1slKi5WLOfWwxc/8NDoHtPON24t n/nOTiTm+1lvBqeYb8y2hUtY58rbMbkVLio5Q0vjotqV3YJzCq86KxLNG2u4Wdo3 VcE69howq8QUqXemvBr5mQ== 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=1734712915; x= 1734799315; bh=unyz/WnVh7+OxYBHU6TJ6pEE4612qTjnjWvoNbMe1Ic=; b=5 ic0ME0NaDaJJFPjXxmqAVRbTj0kIZlsYl59BdAh0MwZdvTQsSGB+5ntPPTMHLIM8 TxIDk/PZNZNWYZSPP+wH50x1Ar1v31MflP9oa140Za+IK5v7nbpUUII816yhY0t0 xeLHGd5AEaoN4b98i7sIs3dSKWXv32o6dRkMllovU52p74b8ACBpm4SD3c6JP3qy 5hgHVDh09A4jv+dVfxOZJ0R3Pt/8xEuTxcKjE8Q+8sI5W4ssj8sxjPNkVV1tbZHY KjBQfJxJgjf3WYkOwPsDtlhTVp7kZFxktb75ZUQJgwLWmfGYer5C+zdUJm2ALgHi K/0pWpU6GyCbMjfe18J9A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddruddtvddgkeelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnecujfgurhepkfffgggfuffvvehfhfgjtgfgsehtkeertddtvdej necuhfhrohhmpeetughrihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrh esrghklhgrvhgvrhdrtghomheqnecuggftrfgrthhtvghrnhepvddvudehiedtgedutdeg uedugffggeektdfhfeejudffhedtheffheevgfeuueelnecuffhomhgrihhnpegthigsvg hrthgvtgdqphhoshhtghhrvghsqhhlrdgtohhmnecuvehluhhsthgvrhfuihiivgeptden ucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghklhgrvh gvrhdrtghomhdpnhgspghrtghpthhtohepgedpmhhouggvpehsmhhtphhouhhtpdhrtghp thhtohepvghstghhvghnohhnvgestghlvghishhtvggthhdrihhtpdhrtghpthhtohepph hgshhqlhdqghgvnhgvrhgrlheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhgpdhr tghpthhtohepmhgtrghtthhisegtlhgvihhsthgvtghhrdhithdprhgtphhtthhopehlph hiiiiiohhlohestghlvghishhtvggthhdrihht X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 20 Dec 2024 11:41:54 -0500 (EST) Message-ID: Date: Fri, 20 Dec 2024 08:41:54 -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> <649fadb9-eb67-4b11-beb8-49ff857b355b@cleistech.it> Content-Language: en-US From: Adrian Klaver In-Reply-To: <649fadb9-eb67-4b11-beb8-49ff857b355b@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/19/24 23:57, Enrico Schenone wrote: > At 19/12/24 22:47, Adrian Klaver wrote: >> >> >> So are they building their own driver over libpq? > I think so. > They wrote ... > < > > /The error “no connection to the server“ is definitively a PostgreSQL > error:/ > > /||/ > /|./src/interfaces/libpq/fe-exec.c: libpq_append_conn_error(conn, "no > connection to the server");|/ > > /It is not normal that PostgreSQL client can connect to the server, do > some SQL with success and then the SQL connection gets dropped at the > next SQL statement execution. This is really suspicious./ They must work in a perfect world where networks never fail. One that would render the blog below unneeded: https://www.cybertec-postgresql.com/en/tcp-keepalive-for-a-better-postgresql-experience/ > > > > >> > Best regards. > Enrico -- Adrian Klaver adrian.klaver@aklaver.com