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 1tkhyA-0069Zd-0e for pgsql-admin@arkaria.postgresql.org; Wed, 19 Feb 2025 11:10:22 +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 1tkhy7-007Ju6-Et for pgsql-admin@arkaria.postgresql.org; Wed, 19 Feb 2025 11:10:19 +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 1tkhy7-007Jtt-0o for pgsql-admin@lists.postgresql.org; Wed, 19 Feb 2025 11:10:19 +0000 Received: from mout.gmx.net ([212.227.15.19]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tkhy5-001hGz-01 for pgsql-admin@lists.postgresql.org; Wed, 19 Feb 2025 11:10:18 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1739963414; x=1740568214; i=shammat@gmx.net; bh=KWDjmqlasDARBeZgy4fLjRdS8Ovzs6TwaMToyEniync=; h=X-UI-Sender-Class:Message-ID:Date:MIME-Version:Subject:To: References:From:In-Reply-To:Content-Type: Content-Transfer-Encoding:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=B0C701Ji98t5NjbQBjHopzunLCeZzQNXvrJzbQnBEq/u3Ty5/wzb1J0x+ostdf3E F64c8X9g/RpqRiOjJxghQfZFouNnj2sYYoLOdJrpquM1ddIsJUgoxPTHyM7fWtepc ad1m3ooSOxYNpBxu2MRaMJ4KVhcyxLUDUAFc5kKRVelYoMLW0Lj5pw149GWkmuwuJ XpzUuJUGIwywfdatEumCgVzdtxBHud4MTPdvwGWBssmKL1UtXhgD1yV5+YW41LOHT pNUoyQhhOLkO7WN4Kplxg2nXE2LZ4FTWL9Abx9tgLg5lv7/dvkMSOAn+LtIxlyqIp apGKPhtO61YALtc9Xw== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.8.0.17] ([185.40.248.10]) by mail.gmx.net (mrgmx005 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MkYc0-1t4B9k20Ja-00nfVz for ; Wed, 19 Feb 2025 12:10:14 +0100 Message-ID: <40fe637f-d3a1-4af5-b100-2e7fedca72bd@gmx.net> Date: Wed, 19 Feb 2025 12:10:13 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Does export operation cancel SQLs? To: pgsql-admin@lists.postgresql.org References: <33a7cbf8b9a5bd90aa2797a1fca3f12e421639cd.camel@cybertec.at> Content-Language: de-DE, en-US From: shammat@gmx.net In-Reply-To: <33a7cbf8b9a5bd90aa2797a1fca3f12e421639cd.camel@cybertec.at> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:coVmN5+S9Cw5q2UyrZ1rkD3YrTVLOlwEjdawJ8fggYZfAeZfcll aVT3bFYRT6e0FVqlmHzE7B5OgFO+XKEuFzCHv0RQg0CQn8QmbGHLFR/dTo1jk1qc6iWLJl1 oRU0rgpWVODuFzREb9eRCY63f4jLVRTPAvRH+MGiycFTDTYNkc4MJqsxBL/DRST4Wmy/sAP 8uSn/C4Nh3Xkoi1de49OQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:s56eFTtn3Js=;TETz4OTcj6Xx5l/fvRVkZtIb2of a5bhB93v7EdwSIvancmAKDXHzpD1AkA1fi/ugLw/B3TpGQQ/tWXneAfHvH1tAHt3ganouunA9 lnFg4j6akYiqrsyXGjVmbX2wC9e8J+sSzewkH5qGgxQLetM1q4WvteQklcsPzE4T+fNK0GqjO ApvEu3rqbie3oQqB47N2i403A7k48gS1HrBjvwsM6Kw8cQi5xN80MCxDtJkvAFdboh1JdWoos 3vhYavHLnBYI2atUsgNzke0F1PPaD3q6OaklWChb5LHfyV8bZpxhk/86Ln8eSEiJcQXgRHQSf Jy3L3fhaTMBUH09PdaxJDRzaX551YCMf47aBB+Bwprx+DcfbaWlQfPvjzUdJxw0uvWbFCFzxp hBkI7VK160ut5D1Ad7ON/JRVjzCq2FuQ6T34iiSpY3xEtapzjO9dHicxzgF8+6iON0kfi5dEf E5eeCPzyNeNwyn4DZ8BwQFo5mmcSZiCpl+YLXFhNQZQNIpcyfCTNZRm7n6Qy9UJMHJJbami9C zjJVz51VFy1tUH06mbyGH0ueXtmMt0d05hSeKYfnS/CMp3yMvpWrUHPaSdM7tdPzNFAQK/OtB +vHzVP21Fm0Y699nQtJqoiMZs1ocS2g8/PHwp29jVVMoFWyu0OB2v7uQp+VKjPCwLekRc9E2a EGKAGYbRPIz0xVhDOm7j1j+38CCMHcPMZWXAqC6ukP8S2UApETjwgC2trI/X2CHRsOs3XpvAo wPDDp4Qd+2RN5qUwEVO1gFC912wRDmGkRm2/9Bdov7tQrG5FGIrl73AqE2q80jNsmnTaNkw1R DCxJbH1l5V71nxHpU0Hw4/1ofbVh9tPPjC8J99odYVjxZETAvbUzkStvLyHubjM7UAlJHNT+M gbEdhVLtBrIwHeL5Mxidvg3U6ebsbzKeS8NwSORtgyzPnJmNVj1/FR2aBn/y9us3SMyteknu+ 92a6hErqoHL+uTi2s4PzVVuzVcuXhbtMWU3+O4Wrh3/0RXvmracFPhjtHA1UpJMXFX1qRg7o6 tmoFQivJyqtahW4osmBUotZNcBJXgwFkj/6iHP3Cke1cNNfS3q/BCnPt37jU+peCGq7H/vjsD 6uStevSxxhtzPw5ALTH+AyiQrSVmRZoOaXvGhstMboPSKfDnpFQALo4cJzPtasRz4DoEpKrs8 SukMgvjX9kKXdAC+t4dIrxgkkwoPMZKp/mXXgDMxHfaavaTKzmgV2V/hVx1cCKwmU+3zFAj63 NEj1z5bPoA+3WGGLMtAbs9YiwGyK4rKXjBQE0hOrTN7e1wcLVswHvWnpsz4S71cztDARwN3Yq GbFpYNGJtZkYXZQyDRfQkNOJ3fugaS0Hr3MeaVx41JV2GRI+D8gu9WCZ5EkAjQse1OTrqpK6z r2y+UQWqpONFvLs5nx5R9OtZ9/tirr9XAv920gKdtElFwt3COXz/1pitTD List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Laurenz Albe schrieb am 19.02.2025 um 09:43: >> We have PostgreSQL 16 running in GCP cloud SQL. When export job runs we >> are noticing these messages excessively: >> >> db=3Dpostgres,user=3Dpostgres ERROR: canceling statement due to user r= equest >> >> Does Export cancel the SQLs? If not, why are we noticing these messages >> excessively during the export operation? The load on the instance is mi= nimal. > > I am not sure what exactly you mean by "export". A pg_dump? > But I am not aware of any operation that would cancel statements in othe= r > sessions. Perhaps someone or something in your application sends cancel > requests when a statement is running too long, and the concurrent export > slows down the system. What if the "export" is done on a read-only replica? Could this be a "canceling statement due to conflict with recovery" in dis= guise?