Re: Does export operation cancel SQLs?

Agreed, we are not running this operation in the READ replica.

Regards
Siraj

On Wed, Feb 19, 2025 at 4:48 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:

> On Wed, 2025-02-19 at 12:10 +0100, shammat(at)gmx(dot)net wrote:
> > 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=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.
> > >
> > > 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
> other
> > > 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
> disguise?
>
> That would be a different error message.
>
> Yours,
> Laurenz Albe
>
> --
>
> *E-Mail Disclaimer*
> Der Inhalt dieser E-Mail ist ausschliesslich fuer den
> bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene Adressat
> dieser E-Mail oder dessen Vertreter sein sollten, so beachten Sie bitte,
> dass jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung
> oder
> Weitergabe des Inhalts dieser E-Mail unzulaessig ist. Wir bitten Sie, sich
> in diesem Fall mit dem Absender der E-Mail in Verbindung zu setzen.
>
> *CONFIDENTIALITY NOTICE & DISCLAIMER
> *This message and any attachment are
> confidential and may be privileged or otherwise protected from disclosure
> and solely for the use of the person(s) or entity to whom it is intended.
> If you have received this message in error and are not the intended
> recipient, please notify the sender immediately and delete this message
> and
> any attachment from your system. If you are not the intended recipient, be
> advised that any use of this message is prohibited and may be unlawful,
> and
> you must not copy this message or attachment or disclose the contents to
> any other person.
>
>
>