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 1l811e-00054T-KK for pgsql-admin@arkaria.postgresql.org; Fri, 05 Feb 2021 13:19:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l811d-000383-Ib for pgsql-admin@arkaria.postgresql.org; Fri, 05 Feb 2021 13:19:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l811d-00037w-7g for pgsql-admin@lists.postgresql.org; Fri, 05 Feb 2021 13:19:53 +0000 Received: from mail-ej1-x633.google.com ([2a00:1450:4864:20::633]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1l811a-00011r-Ro for pgsql-admin@lists.postgresql.org; Fri, 05 Feb 2021 13:19:52 +0000 Received: by mail-ej1-x633.google.com with SMTP id hs11so11973045ejc.1 for ; Fri, 05 Feb 2021 05:19:50 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=w28IPiLH0eFFPNs+mwBx+WIPpOlS2dRb4edgH4mn698=; b=a+PWCwkdd9dP5gvEOmN6oJ5w/QpqBn/EvsitQSAzpSfY0KhE8QjOGR2/LpQ0Q691TI kAGQNRAFH4bf6oPlOw4Bdo68lL1CvTdp/E1aPRdf2H9UGIHHbbTmM+0Bv05JLGW1LNac qhnZWLC7HxWha5VDJ52RKwu8BGvGRk19dX5RiCuEUQxvhpko4me94lyE3RlK4A9r4MOE 2kcLbnzcxGG0kbHn+uTW31XeoNrYWGPd8Br/JxZvMWmarFhV6ceicwxETHakl90c3gix XiUVrRJSAbUJjwO4RVbIfR57ryapSXKig/e0lZYIeIN1oqojKtAvn3H2XFz52A3Zr7Se OIkw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=w28IPiLH0eFFPNs+mwBx+WIPpOlS2dRb4edgH4mn698=; b=IwwnM5R5rW/imXWmhAyXMD1NlWGMYgEqCdxTP1hNZz9mDUiAFI3aAgmeB4seqMQk42 vnPANqoUsLSPXwRBjxApVyHm/+9nTvyockb6traqcB3jWWZjtEB7F/ZY9dR2QSSVWLhd VT0z84bLSDBHXv4sYEqt+4ltyowBI5o6wgcUpaaUST5P/YBfaiJSbNInwzMklsMxpMyX bgP6FPVaW1l9DxdxfamHT7Jv7FOFqqovflFu3mq2z6LqkPPejDJlWoy6e+rjn0FCXIrz 3qBq/0GeTIKTJWKM7Tt4Qimz+19XRDnAH1+HJzdhWgZgEYmcWKUElhS3cDVd+dYp+Kzy TxJQ== X-Gm-Message-State: AOAM5308uCASF7wPHxmiiAZWKJAByI1YEcCYVYUodKhfqqIqaPkG5r8+ wIkVE0beTaSxKwriz/3E6GT7DzDUocDaHg== X-Google-Smtp-Source: ABdhPJyR1BSkD2hBAcwSGS93KyrPml7ItUmIZwrMu0q1HrdBAoePV/xP/O+Pj3giuo6LIswgYhxFsg== X-Received: by 2002:a17:906:d8ae:: with SMTP id qc14mr4071230ejb.129.1612531189136; Fri, 05 Feb 2021 05:19:49 -0800 (PST) Received: from localhost.localdomain (217-149-170-172.nat.highway.telekom.at. [217.149.170.172]) by smtp.gmail.com with ESMTPSA id j5sm3963997edl.42.2021.02.05.05.19.48 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 05 Feb 2021 05:19:48 -0800 (PST) Message-ID: Subject: Re: Disconnection errors From: Laurenz Albe To: S Bob , pgsql-admin@lists.postgresql.org Date: Fri, 05 Feb 2021 14:19:47 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Thu, 2021-02-04 at 17:12 -0700, S Bob wrote: > I see lots of errors like this in the log: > > 2021-02-04 23:58:50.135 UTC [32591] ERROR: canceling statement due to user request > 2021-02-04 23:58:50.135 UTC [32591] STATEMENT: > 2021-02-04 23:58:50.135 UTC [32591] LOG: could not send data to client: Broken pipe > 2021-02-04 23:58:50.135 UTC [32591] FATAL: connection to client lost > > Is this due to the end user or app disconnecting? Are there other areas > / details I should be looking at to debug? That looks like the client sent a cancel request and then terminated without closing the database connection. What seems weird is the empty STATEMENT. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com