Message-ID: <098b7dbed4aa52c97b6159b26c36129ff2f10409.camel@cybertec.at>
Subject: Re: Does export operation cancel SQLs?
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: "David G. Johnston" <david.g.johnston@gmail.com>, Siraj G
	 <tosiraj.g@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Date: Wed, 19 Feb 2025 16:00:26 +0100
In-Reply-To: 
 <CAKFQuwbRW77=4zboZfOv3_E7ct-36gNvnEfk38GhPbCUcNR5Qw@mail.gmail.com>
References: 
	<CAC5iy62t+KuBZJGLjDQ54w6QyELZZyPisacuKvW+KT_+UomPfw@mail.gmail.com>
	 <CAKFQuwbRW77=4zboZfOv3_E7ct-36gNvnEfk38GhPbCUcNR5Qw@mail.gmail.com>
User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) 
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/098b7dbed4aa52c97b6159b26c36129ff2f10409.camel%40cybertec.at>
Precedence: bulk

On Wed, 2025-02-19 at 06:54 -0700, David G. Johnston wrote:
> > We have PostgreSQL 16 running in GCP cloud SQL. When export job runs we=
 are noticing these messages excessively:
> >=20
> > db=3Dpostgres,user=3Dpostgres ERROR:  canceling statement due to user r=
equest
> >=20
> > Does Export cancel the SQLs? If not, why are we noticing these messages=
 excessively during the export operation? The load on the instance is minim=
al
>=20
> It says =E2=80=9Cuser request=E2=80=9D.=C2=A0 I=E2=80=99d advise figuring=
 out what was cancelled and what =E2=80=9Cuser=E2=80=9D did so.
> Probably DDL commands failing to get exclusive locks.

No, that message is from a cancel request, like when you interrupt your
currently running query with Ctrl+C in "psql" or invoke pg_cancel_backend()=
.
PostgreSQL doesn't do that by itself.

Yours,
Laurenz Albe

--=20

*E-Mail Disclaimer*
Der Inhalt dieser E-Mail ist ausschliesslich fuer den=20
bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene Adressat=
=20
dieser E-Mail oder dessen Vertreter sein sollten, so beachten Sie bitte,=20
dass jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung oder=
=20
Weitergabe des Inhalts dieser E-Mail unzulaessig ist. Wir bitten Sie, sich=
=20
in diesem Fall mit dem Absender der E-Mail in Verbindung zu setzen.

*CONFIDENTIALITY NOTICE & DISCLAIMER
*This message and any attachment are=20
confidential and may be privileged or otherwise protected from disclosure=
=20
and solely for the use of the person(s) or entity to whom it is intended.=
=20
If you have received this message in error and are not the intended=20
recipient, please notify the sender immediately and delete this message and=
=20
any attachment from your system. If you are not the intended recipient, be=
=20
advised that any use of this message is prohibited and may be unlawful, and=
=20
you must not copy this message or attachment or disclose the contents to=20
any other person.