Request a Demo
Home   >   mailing lists

Re: Enquiry about long-running queries - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Enquiry about long-running queries
Date
Msg-id CAKAnmm+A90ASkLETXVq8Yc1xs4JqOBY0W055t_fES-JVJWxT0w@mail.gmail.com
Whole thread Raw
In response to Re: Enquiry about long-running queries  (Ashish Mukherjee <ashish.mukherjee@gmail.com>)
List pgsql-general
Tree view
Wow, 9 days is a long time. The fact that it is not responding to pg_terminate_backend means it's not even calling CHECK_FOR_INTERRUPTS inside the WaitForParallelWorkersToFinish loop, so something is seriously wrong. If the PID is still there, please do what Laurenz suggested:

strace -tp 356274

Is the problem reproducible, and has it happened more than once?

Cheers,
Greg




pgsql-general by date:

Previous
From: Radu Radutiu
Date:
Subject: Pgbackrest setup for two sites with limited bandwidth
Next
From: Greg Sabino Mullane
Date:
Subject: Re: Pgbackrest setup for two sites with limited bandwidth