Re: Does export operation cancel SQLs?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Siraj G <tosiraj(dot)g(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Does export operation cancel SQLs?
Date: 2025-02-19 13:54:54
Message-ID: CAKFQuwbRW77=4zboZfOv3_E7ct-36gNvnEfk38GhPbCUcNR5Qw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wednesday, February 19, 2025, Siraj G <tosiraj(dot)g(at)gmail(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2025-02-19 15:00:26 Re: Does export operation cancel SQLs?
Previous Message Siraj G 2025-02-19 13:51:49 Re: Does export operation cancel SQLs?