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?
> 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.
