Re: Does export operation cancel SQLs?
| От | Siraj G |
|---|---|
| Тема | Re: Does export operation cancel SQLs? |
| Дата | |
| Msg-id | CAC5iy63wUT8JxUeu6fUKKT6VOZtC3sT+yDJg+-+9Rtrqc14Vbg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Does export operation cancel SQLs? (Scott Ribe <scott_ribe@elevated-dev.com>) |
| Ответы |
Re: Does export operation cancel SQLs?
|
| Список | 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@elevated-dev.com> wrote:
> On Feb 19, 2025, at 1:46 PM, Siraj G <tosiraj.g@gmail.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.
В списке pgsql-admin по дате отправления: