| From: | Siraj G <tosiraj(dot)g(at)gmail(dot)com> |
|---|---|
| To: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
| Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Does export operation cancel SQLs? |
| Date: | 2025-02-19 20:56:57 |
| Message-ID: | CAC5iy63wUT8JxUeu6fUKKT6VOZtC3sT+yDJg+-+9Rtrqc14Vbg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi Scott
The sessions that were getting cancelled were from Google DMS. It appears
the google's service is setting some session specific timeout
(lock_timeout) due to which the sessions are getting cancelled.
But I wonder if pg_dump does acquire locks? If so, are these locks on the
dictionary/catalog objects or on the data tables that are getting exported?
Regards
Siraj
On Thu, Feb 20, 2025 at 2:21 AM Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
wrote:
> > On Feb 19, 2025, at 1:46 PM, Siraj G <tosiraj(dot)g(at)gmail(dot)com> wrote:
> >
> > Waiting processes get cancelled:
> > In the case, all the waiting pid (663355, 675442, 675407) got cancelled
> and the messages are:
>
> As people have described, clients are timing out and canceling queries.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2025-02-19 20:57:51 | Re: Does export operation cancel SQLs? |
| Previous Message | Scott Ribe | 2025-02-19 20:51:21 | Re: Does export operation cancel SQLs? |