Re: Does export operation cancel SQLs? - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Does export operation cancel SQLs?
Date
Msg-id CAKFQuwbRW77=4zboZfOv3_E7ct-36gNvnEfk38GhPbCUcNR5Qw@mail.gmail.com
Whole thread Raw
In response to Does export operation cancel SQLs?  (Siraj G <tosiraj.g@gmail.com>)
Responses Re: Does export operation cancel SQLs?
List pgsql-admin
On Wednesday, February 19, 2025, Siraj G <tosiraj.g@gmail.com> wrote:
Hello Experts!

We have PostgreSQL 16 running in GCP cloud SQL. When export job runs we are noticing these messages excessively:

db=postgres,user=postgres ERROR: canceling statement due to user request

Does Export cancel the SQLs? If not, why are we noticing these messages excessively during the export operation? The load on the instance is minimal

It says “user request”.  I’d advise figuring out what was cancelled and what “user” did so.  Probably DDL commands failing to get exclusive locks.

David J.

pgsql-admin by date:

Previous
From: Siraj G
Date:
Subject: Re: Does export operation cancel SQLs?
Next
From: Laurenz Albe
Date:
Subject: Re: Does export operation cancel SQLs?