Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mtb6D-0007S0-03 for pgsql-performance@arkaria.postgresql.org; Sat, 04 Dec 2021 19:53:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mtb6A-00036c-Vs for pgsql-performance@arkaria.postgresql.org; Sat, 04 Dec 2021 19:53:30 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mtb6A-00036T-EC for pgsql-performance@lists.postgresql.org; Sat, 04 Dec 2021 19:53:30 +0000 Received: from mail-il1-x129.google.com ([2607:f8b0:4864:20::129]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mtb63-0004xg-4x for pgsql-performance@postgresql.org; Sat, 04 Dec 2021 19:53:29 +0000 Received: by mail-il1-x129.google.com with SMTP id h16so6231193ila.4 for ; Sat, 04 Dec 2021 11:53:22 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=ZY70DpiGMKxhalATvB6jA2r+cRR/cOjgrWoZjD1OjSw=; b=a8hlSemeQah4ZGlqOr64fMyrO8txf58Qoo5QIoJXVnSEiXrKWpQMUfxwdIIQ38Dp1I 7H3o2Vx8ptYi6cfKL8k15ZZk8D8OcmRKmA2qGST5wmS0zMbBNI2iKQ3qpiVrIpTSzKgo 9wkuW47gu6bN0kf2ck3ce25sQEPl91aJm8MLKEaMt7pJC/E7RxfjiB9lDmmQBDI4t4d9 6wC45Yef0FLBnW5TeCcBG2fFGUvg9dn8TpcgQXuRtBU0JzF5dDEzMLlxkndM5q6VyHpI xj0f/acA7KHW/1rTK8m1BMiBIL9CV7rZ6l6s2pFzjgl7yp8SEjPt1kw9uczVxKcfKURm nrFA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=ZY70DpiGMKxhalATvB6jA2r+cRR/cOjgrWoZjD1OjSw=; b=W6ses/0s6bSawYoAQ7kpWAgg9GekQpXD3dStIKyNhukBM/CjF9SpGzwhw0jkvFZ4gg NqiUa4Y2h0jJdW0ikrAwv8JyhvFh0UVOcrHnJxC+9TJ/GT/k0RSnsmiD7DD+MTy1ys86 J0B8eTNF9eIH2EfkW3tAWO/KEhu/yp2Xi+0U6pIYY20Ye0WDX4+JfxR5thASox5YBAno a1ksEYdM2Gd5KlxZV+m3XiCJl8EER/YtxnekI4SBR6IPz9IXLtWmtZHcTIRxCAHkkVt7 EjYUiUGqsVHPqez/RqeiYL3EydDvhGmYGsIfDAkWXb/cHROSoHzWuGvFFXmd8bHbkck4 tL9g== X-Gm-Message-State: AOAM530cl8NYMJ848eyK+jyDBGurNX/5Oifge6MttZgK1xghJgBynKCJ AXqnQcMC4eDbksv57/+UWm91cjSUkp8cGQ== X-Google-Smtp-Source: ABdhPJxRD2dbOcCj32dEH6H3zmeN/dD7GwxAhu4/TqDOQ+Iw5a67uXxYwDKlneJDF/1A6//6Y4wyoQ== X-Received: by 2002:a05:6e02:106c:: with SMTP id q12mr22182213ilj.125.1638647602270; Sat, 04 Dec 2021 11:53:22 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id m16sm3503750ilj.45.2021.12.04.11.53.21 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sat, 04 Dec 2021 11:53:21 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 7EE958008F8; Sat, 4 Dec 2021 13:53:20 -0600 (CST) Date: Sat, 4 Dec 2021 13:53:20 -0600 From: Justin Pryzby To: "ldh@laurent-hasson.com" Cc: pgsql-performance@postgresql.org Subject: Re: An I/O error occurred while sending to the backend (PG 13.4) Message-ID: <20211204195320.GD17618@telsasoft.com> References: <20211204175926.GC17618@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, Dec 04, 2021 at 07:18:06PM +0000, ldh@laurent-hasson.com wrote: > It's a remote server, but all on a local network. Network performance is I am sure not the issue. Also, the system is on Windows Server. What are you expecting to see out of a tcpdump? I'll try to get PG logs on the failing query. I'd want to know if postgres sent anything to the client, like TCP RST, or if the client decided on its own that there had been an error. -- Justin