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@xxxxxxxxxxxxxxxx> wrote:
> On Feb 19, 2025, at 1:46 PM, Siraj G <tosiraj.g@xxxxxxxxx> 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.
